weihua zhang created IMPALA-14132:
-------------------------------------
Summary: Calcite Planner: EXTRACT-FROM not handle correctly
Key: IMPALA-14132
URL: https://issues.apache.org/jira/browse/IMPALA-14132
Project: IMPALA
Issue Type: Sub-task
Reporter: weihua zhang
{code:sql}
set use_calcite_planner=1;
select EXTRACT(DAY FROM DATE'2019-08-17');
{code}
{code:java}
select EXTRACT(DAY FROM DATE'2019-08-17')
2025-06-09 05:04:43 [Exception] ERROR: Query 494f60abbeb506be:1a2188a000000000
failed:
ParseException: Encountered "FROM" at line 1, column 20.
Was expecting one of:
"EXCEPT" ...
"FETCH" ...
"INTERSECT" ...
"LIMIT" ...
"OFFSET" ...
"ORDER" ...
"PARTITION" ...
"MINUS" ...
"UNION" ...
")" ...
"," ...
"=>" ...
"." ...
"NOT" ...
"IN" ...
"<" ...
"<=" ...
">" ...
">=" ...
"=" ...
"<>" ...
"!=" ...
"BETWEEN" ...
"LIKE" ...
"ILIKE" ...
"RLIKE" ...
"SIMILAR" ...
"<=>" ...
"REGEXP" ...
"IREGEXP" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"CONTAINS" ...
"OVERLAPS" ...
"EQUALS" ...
"PRECEDES" ...
"SUCCEEDS" ...
"IMMEDIATELY" ...
"MULTISET" ...
"[" ...
"FORMAT" ...
"(" ...
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
