If you want to use hint, you have to set paremeter below as false (default is true): set hive.ignore.mapjoin.hint=false; ... View more