I am accustomed to using partitioned tables to obtain separate directories
for data files in each partition.
When looking at the documentation for bucketed tables it seems they are
typically used in conjunction with distribute by/sort by and an appropriate
partitioning key - and thus provide ability to do map side joins.
An explanation of when to use bucketed tables by themselves (in lieu of
partitioned tables) as well as in conjunction with partitoined tables
would be appreciated.
bejoy_ks@... 2013-06-17, 07:38