I have a table which is bucketed and sorted by a bigint column and I am performing a self join over the same column. But when I print the query plan using explain or explain extended statement, the query plan shows HybridGraceHashJoin being performed on mapjoin phase and not resorting to sort merge bucket join.
Is there anything I need to do, other than setting these settings
set hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
set hive.optimize.bucketmapjoin=true;
set hive.optimize.bucketmapjoin.sortedmerge=true;
help would be appreciated.