Data is not loaded properly in hive bucket table

Have created one hive table with 16 buckets , but after loading data by using insert command , not able to see 16 dir inside table dir.It’s showing only one dir .

For more detail please look into attached snapshot

For loading in bucketed table you need to set the property hive.enforce.bucketing=true. By this Hive will load data in partitions as per no of buckets, in u r case 16.
Else you need to explicitly mention parallel 16 I.e no of buckets.

1 Like

Ok , Thanks :slight_smile: