[
https://issues.apache.org/jira/browse/IMPALA-14132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
weihua zhang updated IMPALA-14132:
----------------------------------
Summary: Calcite Planner: support SQL-standardized EXTRACT-FROM syntax
(was: Calcite Planner: EXTRACT-FROM not handle correctly)
> Calcite Planner: support SQL-standardized EXTRACT-FROM syntax
> -------------------------------------------------------------
>
> Key: IMPALA-14132
> URL: https://issues.apache.org/jira/browse/IMPALA-14132
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: weihua zhang
> Priority: Major
>
> {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]
