Yu Xu created CALCITE-7096:
------------------------------
Summary: Invalid unparse for DateTime 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
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 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)
