Reply
Explorer
Posts: 6
Registered: ‎11-05-2018

Compute stats step in an Impala query, when executed turns up a message Could not execute.

We have a 4 series of steps in impala query, as follows.

step 1: Drop table xx.xx1

stepe: 2: create table xx.xx1

Step3: Insert in to table xx.xx1 from ....

step 4: rename table xx1 to yy1

step 5: Compute stats step  yy1 (Warning message memory limit exeeded),

followed by Could not execute the query(trying to figure out, if any memorey properties has to be increased.

Cloudera Employee
Posts: 739
Registered: ‎03-23-2015

Re: Compute stats step in an Impala query, when executed turns up a message Could not execute.

Please share the contents of the PROFILE for the failed query (compute stats), so that we can check the query settings and exact error messages.

Thanks