Re: Query Failures

2020-02-14 Thread David Mollitor
https://community.cloudera.com/t5/Support-Questions/Map-and-Reduce-Error-Java-heap-space/td-p/45874 On Fri, Feb 14, 2020, 6:58 PM David Mollitor wrote: > Hive has many optimizations. One is that it will load the data directly > from storage (HDFS) if it's a trivial query. For example: > > Sele

Re: Query Failures

2020-02-14 Thread David Mollitor
Hive has many optimizations. One is that it will load the data directly from storage (HDFS) if it's a trivial query. For example: Select * from table limit 10; In natural language it says "give me any ten rows (if available) from the table." You don't need the overhead of launching a full mapr

Re: Query Failures

2020-02-11 Thread Pau Tallada
Hi, Do you have more complete tracebacks? Missatge de Charles Givre del dia dt., 11 de febr. 2020 a les 2:54: > Hello Everyone! > I recently joined a project that has a Hive/Impala installation and we are > experience a significant number of query failures. We are using an older > version of H