Hive Queries on AWS EMR with ORC formatted dataasets - isgaur/AWS-BigData-Solutions GitHub Wiki

SET hive.fetch.task.conversion = more; SET hive.fetch.task.conversion.threshold = 10737418240; -- 10 GB SET hive.optimize.ppd = true; SET hive.optimize.index.filter = true;