Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/Joins" page has been changed by NamitJain. http://wiki.apache.org/hadoop/Hive/LanguageManual/Joins?action=diff&rev1=16&rev2=17 -------------------------------------------------- FROM A a join B b on a.key = b.key }}} can be done on the mapper only. The mapper for the bucket for A will traverse the corresponding bucket for B. This is not the default behavior, and the following parameters need to be set: + ((( - '''set hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat''' + set hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat; - '''set hive.optimize.bucketmapjoin = true''' + set hive.optimize.bucketmapjoin = true; - '''set hive.optimize.bucketmapjoin.sortedmerge = true''' + set hive.optimize.bucketmapjoin.sortedmerge = true; + )))
