Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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.