Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

compute incremental stats fail for new partition

Solved Go to solution
Highlighted

compute incremental stats fail for new partition

Contributor

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

Accepted Solutions

Re: compute incremental stats fail for new partition

Master Collaborator

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.

 

1 REPLY 1

Re: compute incremental stats fail for new partition

Master Collaborator

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.

 

Don't have an account?
Coming from Hortonworks? Activate your account here