Creating databases and tables in Hadoop - Quick Revision & Summary

Recall & Review

beginner

What is a database in Hadoop's Hive?

A database in Hive is a namespace that organizes tables. It helps keep data organized like folders on your computer.

beginner

How do you create a new database in Hive?

Use the command: <br>CREATE DATABASE database_name;<br>This makes a new space to store tables.

beginner

What is a table in Hive?

A table is like a spreadsheet with rows and columns where data is stored inside a database.

beginner

How do you create a table in Hive?

Use the command:<br>CREATE TABLE table_name (column1 TYPE, column2 TYPE, ...);<br>This sets up a table with columns and their data types.

beginner

What data types can you use when creating tables in Hive?

Common types include INT (numbers), STRING (text), FLOAT (decimal numbers), and BOOLEAN (true/false).

Which command creates a new database in Hive?

A CREATE DATABASE mydb;

B MAKE DATABASE mydb;

C NEW DATABASE mydb;

D CREATE TABLE mydb;

The correct syntax to create a database in Hive is CREATE DATABASE followed by the database name.

What does a table in Hive represent?

A A folder to store files

B A spreadsheet-like structure with rows and columns

C A programming function

D A type of database

A table stores data organized in rows and columns, similar to a spreadsheet.

Which data type is used for text in Hive tables?

A FLOAT

B BOOLEAN

C INT

D STRING

STRING is the data type used for text values in Hive tables.

How do you specify columns when creating a table in Hive?

A List column names only

B List data types only

C List column names with data types

D No need to specify columns

You must specify both column names and their data types when creating a table.

What is the purpose of a database in Hive?

A To organize tables into groups

B To store files

C To run queries

D To create users

Databases group tables together to keep data organized.

Explain how to create a database and a table in Hive, including the syntax and purpose of each.

Think about how folders and files work on your computer.

Describe common data types used when creating tables in Hive and why choosing the right type matters.

Consider how you choose the right container for different items.