HIVE

How does partitioning work in Hive?

• It stores data in a single directory

• It organizes data into separate folders based on column values

• It splits data into multiple tables

• It creates indexes for faster searching

What is bucketing in Hive used for?

• To randomly distribute data across multiple files

• To group data based on the hash value of a column

• To create multiple databases

• To replace partitioning

Which clause is used to create bucketing in a Hive table?

• PARTITIONED BY

• CLUSTERED BY

• GROUP BY

• DISTRIBUTE BY

What is the primary benefit of using bucketing in Hive?

• Enhanced data security

• Faster data ingestion

• Reduced storage costs

• Improved query performance

Which of the following statements is true about Hive partitioning?

• It requires a separate database for each partition

• It is mandatory for all Hive tables

• It allows for efficient querying of large datasets

• It can only be applied to string columns

In Hive, what is the effect of using the 'CLUSTERED BY' clause?

• It creates a unique index on the table

• It specifies the columns used for bucketing

• It defines the number of partitions

• It merges multiple tables into one

What is the main purpose of using the 'DISTRIBUTE BY' clause in Hive?

• To optimize data storage

• To create a unique identifier for each row

• To define the schema of the table

• To control the distribution of data across reducers

How can you improve query performance in Hive when dealing with large datasets?

• By using only text file formats

• By reducing the number of columns in the table

• By increasing the number of partitions and buckets

• By using more complex SQL queries

What is the role of the 'SORT BY' clause in Hive?

• To sort the output of a query

• To define the order of data distribution

• To create a temporary view

• To optimize data retrieval

What is the purpose of the 'WHERE' clause in a Hive query?

• To filter records based on specific conditions

• To group records for aggregation

• To join multiple tables

• To define the output format