Why doesn't hive bucketing work at partition level?

vinpot — Fri, 28 Oct 2022 21:41:18 GMT

Any hive bucketing experts here?

I have this scenario where my each of my individual partitions needs to be bucketed at a different level. I have tried the following scenarios but it doesn't work.

Created a bucketed table and created a partition (date_id='2022-10-22') and set the bucketing number to 64.

Result: No of files created in the target partition is equivalent to no of buckets in the source table (6). Expected file count is 64.

Created a non bucketed table and created a partition (date_id='2022-10-22') and set the bucketing number to 64. Result: No of files created the target is not related to source files count either

Please share your thoughts.

Thanks

Re: Why doesn't hive bucketing work at partition level?

ggangadharan — Mon, 09 Oct 2023 13:27:28 GMT

Could you kindly provide the DDL and a sample dataset to facilitate a more in-depth explanation?

question Why doesn't hive bucketing work at partition level? in Support Questions

Why doesn't hive bucketing work at partition level?

Re: Why doesn't hive bucketing work at partition level?