Re: Error when running TPCDS query with Hive+LLAP

2017-09-25 Thread Gopal Vijayaraghavan
> Caused by: > org.apache.hadoop.hive.ql.exec.mapjoin.MapJoinMemoryExhaustionError: > VectorMapJoin Hash table loading exceeded memory limits. > estimatedMemoryUsage: 1644167752 noconditionalTaskSize: 463667612 > inflationFactor: 2.0 threshold: 927335232 effectiveThreshold: 927335232 Most lik

Error when running TPCDS query with Hive+LLAP

2017-09-25 Thread Krishnanand Khambadkone
Hi, I am trying to run one of the TPC-DS  queries, query25 against a 25GB dataset (my instance memory size is 64GB) and I get this error, Caused by: org.apache.hadoop.hive.ql.exec.mapjoin.MapJoinMemoryExhaustionError: VectorMapJoin Hash table loading exceeded memory limits. estimatedMemoryUsage: