[
https://issues.apache.org/jira/browse/CALCITE-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu updated CALCITE-7096:
---------------------------
Summary: Invalid unparse for EXTRACT in StarRocks (was: Invalid unparse
for EXTRACT from DATETIME in StarRocks)
> Invalid unparse for EXTRACT in StarRocks
> ----------------------------------------
>
> Key: CALCITE-7096
> URL: https://issues.apache.org/jira/browse/CALCITE-7096
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
> Fix For: 1.41.0
>
>
> starrocks sql:
> {code:java}
> select EXTRACT(HOUR FROM DATETIME '2023-12-01 00:00:00') {code}
> {code:java}
> com.starrocks.common.AnalysisException: Getting syntax error. Detail message:
> Parse Error : unknown type DATETIME.
> at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:477)
> ~[starrocks-fe.jar:?]
> at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:778)
> ~[starrocks-fe.jar:?]
> at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:1072)
> ~[starrocks-fe.jar:?]
> at
> com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
> ~[starrocks-fe.jar:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> ~[?:?]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> ~[?:?]
> at java.lang.Thread.run(Thread.java:833) ~[?:?]
> {code}
>
> StarRocks not support EXTRACT from DATETIME type
> ([https://docs.starrocks.io/docs/sql-reference/sql-functions/date-time-functions/timestamp/]),
> should use timestamp
> {code:java}
> select EXTRACT(HOUR FROM TIMESTAMP ('2023-12-01 12:00:00')){code}
> result is ok:
> {code:java}
> 12{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
