Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.