compute incremental stats fail for new partition

maurin — Fri, 16 Sep 2022 10:40:05 GMT

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

Re: compute incremental stats fail for new partition

alex.behm — Tue, 20 Sep 2016 15:03:04 GMT

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.

question Re: compute incremental stats fail for new partition in Archives of Support Questions (Read Only)

compute incremental stats fail for new partition

Re: compute incremental stats fail for new partition