Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Bucketing external tables

Copy link to this message
Re: Bucketing external tables
I was able to load data into bucketed tables. I verified that the number of
files created in each of the partitioned folder matches the number of
buckets specified in my CREATE statement. But I don't see any immprovements
in the query speed. I tried with 90 buckets, 360 and 720 buckets. I have
SET hive.enforce.bucketing=true and set hive.optimize.bucketmapjoin=true;
Do I need to set any other parameters? Do I need to use MAPJOIN hint in my
join for it to use bucket join. I am not sure where to look for to verify
that it's using the map side bucket joins. Greatly appreciate any  help /
insgught .