Why do we need to perform partitioning in Hive?

1.	Why do we need to perform partitioning in Hive?
Answer» Apache HIVE organizes tables into PARTITIONS. Partitioning is the manner in which a table is split into RELATED components depending on the values of APPROPRIATE columns like date, city, and department. Every table in the hive can have one or more than one partition keys to recognize a distinct partition. With the help of partitions, it is effortless to do queries on SLICES of the data.

Answer»

Apache HIVE organizes tables into PARTITIONS. Partitioning is the manner in which a table is split into RELATED components depending on the values of APPROPRIATE columns like date, city, and department.

Every table in the hive can have one or more than one partition keys to recognize a distinct partition. With the help of partitions, it is effortless to do queries on SLICES of the data.

Discussion

No Comment Found

Related InterviewSolutions

Mention the consequences of Distributed Applications.
Explain the architecture of Flume.
What is Apache Flume in Hadoop ?
What is the default File format to import data using Apache sqoop?
Where is table data stored in Apache Hive by default?
If the source data gets updated every now and then, how will you synchronize the data in HDFS that is imported by Sqoop?
How do you differentiate inner bag and outer bag in Pig.
Why do we need to perform partitioning in Hive?
Are Multiline Comments supported in Hive? Why?
Compare differences between Local Metastore and Remote Metastore

Why do we need to perform partitioning in Hive?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment