[ https://issues.apache.org/jira/browse/CALCITE-6150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6150: ------------------------------------ Labels: pull-request-available (was: ) > 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 > Priority: Minor > Labels: pull-request-available > 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)