[jira] [Created] (CALCITE-7096) Invalid unparse for DateTime in StarRocks

["Yu Xu (Jira)" <ji...@apache.org>]

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)