Hi,
I have two large tables which I need to perform an equijoinon. I have bucketed and sorted the two tables on the join key. I have then madethe following specifications when running the join SQL:- SET hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;SET hive.auto.convert.sortmerge.join=true;SET hive.optimize.bucketmapjoin=true;SET hive.optimize.bucketmapjoin.sortedmerge=true;SET hive.auto.convert.sortmerge.join.noconditionaltask=true; However I get this error:- FAILED: SemanticException [Error 10135]: Sort merge bucketedjoin could not be performed. If you really want to perform the operation,either set hive.optimize.bucketmapjoin.sortedmerge=false, or sethive.enforce.sortmergebucketmapjoin=false. What am I doing wrong? The version of Hive is0.13.0.2.1.2.0-402 Thanks
