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 eqvivalent 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.
