[jira] [Created] (IMPALA-10461) Flaky exception when use cast to timestamp in query

["Sheng Wang (Jira)" <ji...@apache.org>]

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)