What is bucketing in Hive?

Answer Posted / rajasekhar

Bucketing is one of the data sclicing mechanism in hive to improve the query performance.
For performing the Bucketing in Hive we have to use clustered by column name into number of buckets
note:--set hive.enforce.bucketing=true should be first enabled to work for bucketing

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about ACID transactions in Hive?

439


What does the "USE" command in hive do?

424


When you should use Hbase?

578


What is the difference between Cassandra, Pig and Hive?

585


What are the different Data Types available in Hive?

435






How can you delete the DBPROPERTY in Hive?

401


What is the need for custom serde?

443


Hive new version supported Hadoop Versions ?

347


How would you drop a table in Hive?

426


What is ObjectInspector functionality?

483


Can we say cogroup is a group of more than 1 data set?

442


Explain ALTER Table statement in Hive?

431


Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

446


Does the archiving of hive tables give any space saving in hdfs?

656


Why do we need hive?

410