ChenLuyang created CALCITE-6150:
-----------------------------------
Summary: Clickhouse does not support certain EXTRACT Unit syntax.
Key: CALCITE-6150
URL: https://issues.apache.org/jira/browse/CALCITE-6150
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.36.0
Reporter: ChenLuyang
Attachments: image-2023-12-01-20-16-17-974.png,
image-2023-12-01-20-16-48-298.png, image-2023-12-01-20-17-20-716.png
Clickhouse does not support the following EXTRACT Unit syntax, and
ClickHouseSqlDialect may need some adaptation.
`SELECT EXTRACT(DOW FROM Date '2023-12-01')`
!image-2023-12-01-20-16-17-974.png|width=483,height=105!
`SELECT EXTRACT(DOY FROM Date '2023-12-01')`
!image-2023-12-01-20-16-48-298.png|width=476,height=96!
`SELECT EXTRACT(WEEK FROM Date '2023-12-01')`
!image-2023-12-01-20-17-20-716.png|width=1041,height=80!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
