Fredy Wijaya created IMPALA-7250: ------------------------------------ Summary: AnalysisException in select datediff() with group by Key: IMPALA-7250 URL: https://issues.apache.org/jira/browse/IMPALA-7250 Project: IMPALA Issue Type: Bug Components: Frontend Affects Versions: Impala 2.12.0, Impala 3.0 Reporter: Fredy Wijaya
{noformat} [localhost:21000] default> select datediff(day,now()) from test_table where day>=(now() - interval 5 days) group by datediff(day,now()); Query: select datediff(day,now()) from test_table where day>=(now() - interval 5 days) group by datediff(day,now()) Query submitted at: 2018-06-05 21:11:23 (Coordinator: http://impala-dev:25000) ERROR: AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?): datediff(day, TIMESTAMP '2018-06-05 21:11:23.320564000') [localhost:21000] default> set ENABLE_EXPR_REWRITES=0; ENABLE_EXPR_REWRITES set to 0 [localhost:21000] default> select datediff(day,now()) from test_table where day>=(now() - interval 5 days) group by datediff(day,now()); Query: select datediff(day,now()) from test_table where day>=(now() - interval 5 days) group by datediff(day,now()) Query submitted at: 2018-06-05 21:11:31 (Coordinator: http://impala-dev:25000) Query progress can be monitored at: http://impala-dev:25000/query_plan?query_id=b64c8eabcedc58e5:da9edc8600000000 Fetched 0 row(s) in 0.21s {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)