Bucketing in Hive

Question

Could you please let me know by default, how many buckets are created in hdfs location while inserting data if buckets are not defined in create statement?

Answer 1

By default, only 1 bucket will be created but that is not going to be efficient. The number of buckets should be equal to or less than the number of files in the HDFS. But, if there are more buckets (for example 1 bucket for each file), then the storage will be very inefficient. So, the optimal numbers of buckets should be decided based on the number of files and the size of files.