Sheng Wang created IMPALA-10461: ----------------------------------- Summary: Flaky exception when use cast to timestamp in query Key: IMPALA-10461 URL: https://issues.apache.org/jira/browse/IMPALA-10461 Project: IMPALA Issue Type: Bug Affects Versions: Impala 3.4.0, Impala 2.12.0 Reporter: Sheng Wang
Recently, I found a probelm for execute below query in version 3.4.0 and 2.12.0: {code:java} create table test_table(dt STRING) partitioned by(day STRING) STORED AS PARQUET; SELECT (CASE WHEN (DAYS_ADD(CAST(CAST(TO_DATE(TO_TIMESTAMP(`t1`.`dt`, 'yyyy-MM-dd')) AS TIMESTAMP) AS TIMESTAMP), 7) > CAST('2021-01-26' AS TIMESTAMP)) THEN 0 ELSE 1 END) `d1` FROM (SELECT dt FROM test_table WHERE day=to_date(days_sub(now(),1)) GROUP BY dt) `t1` GROUP BY (CASE WHEN (DAYS_ADD(CAST(CAST(TO_DATE(TO_TIMESTAMP(`t1`.`dt`, 'yyyy-MM-dd')) AS TIMESTAMP) AS TIMESTAMP), 7) > CAST('2021-01-26' AS TIMESTAMP)) THEN 0 ELSE 1 END) LIMIT 20; {code} The above query sometime execute success, but sometimes failed like this: {code:java} Create execute plan failed :Create execute plan failed :org.apache.impala.common.AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?): (CASE WHEN (days_add(CAST(CAST(to_date(to_timestamp(t1.dt, 'yyyy-MM-dd')) AS TIMESTAMP) AS TIMESTAMP), 7) > TIMESTAMP '2021-01-26 00:00:00') THEN 0 ELSE 1 END) d1 at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.verifyAggregation(SelectStmt.java:832) at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:233){code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org