In many cases the issue is caused by the pushdown optimization. You can disable the push down optimization using the following command: set hive.optimize.ppd=false; ... View more