Support Questions

Find answers, ask questions, and share your expertise

compute incremental stats fail for new partition

avatar
Rising Star

Hi,

I am using impala 2.5 with cdh 5.7.3

I trigger daily a compute incremental stats and it always worked until now, but today I got an exception.

The table is partitioned by a `date` column

When I do a profile, I get: 

Query Runtime Profile:
Query (id=fb406e80eb5f914e:99174c15db345bae):
  Summary:
    Session ID: 664b8c1d2ff32921:113c2504377e33a8
    Session Type: BEESWAX
    Start Time: 2016-09-20 00:33:29.069428000
    End Time: 2016-09-20 00:33:30.112705000
    Query Type: DDL
    Query State: EXCEPTION
    Query Status: AnalysisException: Syntax error in line 1:
...imension='2016-09-17' AND ``date``='2016-09-18') OR (d...
                             ^
Encountered: EMPTY IDENTIFIER
Expected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUNCATE, TRUE, IDENTIFIER

any idea why the date get suddently double escaped? 

 

thanks

1 ACCEPTED SOLUTION

avatar

Thanks for reporting this issue! Sorry for the trouble.

 

I was able to reproduce the issue and can confirm this is a regression from previous Impala versions.

 

I filed https://issues.cloudera.org/browse/IMPALA-4170 to track progress on the issue.

 

View solution in original post

1 REPLY 1

avatar

Thanks for reporting this issue! Sorry for the trouble.

 

I was able to reproduce the issue and can confirm this is a regression from previous Impala versions.

 

I filed https://issues.cloudera.org/browse/IMPALA-4170 to track progress on the issue.