[
https://issues.apache.org/jira/browse/CALCITE-6150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ChenLuyang updated CALCITE-6150:
--------------------------------
Description:
Clickhouse does not support the following EXTRACT Unit syntax, and
ClickHouseSqlDialect may need some adaptation.
`SELECT EXTRACT(DOW FROM Date '2023-12-01')`
Syntax error: failed at position 20 ('FROM'):
SELECT EXTRACT(DOW FROM Date '2023-12-01');
Expected one of: UUID, NOT, AND, BETWEEN, ILIKE, IN, OR, alias, Arrow, AS,
LIKE, token, MOD, DIV, NOT LIKE, NOT ILIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN,
IS, Comma, Dot, QuestionMark, DoubleColon, end of query
`SELECT EXTRACT(DOY FROM Date '2023-12-01')`
Syntax error: failed at position 20 ('FROM'):
SELECT EXTRACT(DOY FROM Date '2023-12-01');
Expected one of: UUID, NOT, AND, BETWEEN, ILIKE, IN, OR, alias, Arrow, AS,
LIKE, token, MOD, DIV, NOT LIKE, NOT ILIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN,
IS, Comma, Dot, QuestionMark, DoubleColon, end of query
`SELECT EXTRACT(WEEK FROM Date '2023-12-01')`
Exception on client:
Code: 62. DB::Exception: The syntax 'EXTRACT(WEEK FROM date)' is not supported,
cannot extract the number of a week
was:
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!
> 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')`
> Syntax error: failed at position 20 ('FROM'):
> SELECT EXTRACT(DOW FROM Date '2023-12-01');
> Expected one of: UUID, NOT, AND, BETWEEN, ILIKE, IN, OR, alias, Arrow, AS,
> LIKE, token, MOD, DIV, NOT LIKE, NOT ILIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN,
> IS, Comma, Dot, QuestionMark, DoubleColon, end of query
>
> `SELECT EXTRACT(DOY FROM Date '2023-12-01')`
> Syntax error: failed at position 20 ('FROM'):
> SELECT EXTRACT(DOY FROM Date '2023-12-01');
> Expected one of: UUID, NOT, AND, BETWEEN, ILIKE, IN, OR, alias, Arrow, AS,
> LIKE, token, MOD, DIV, NOT LIKE, NOT ILIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN,
> IS, Comma, Dot, QuestionMark, DoubleColon, end of query
>
> `SELECT EXTRACT(WEEK FROM Date '2023-12-01')`
> Exception on client:
> Code: 62. DB::Exception: The syntax 'EXTRACT(WEEK FROM date)' is not
> supported, cannot extract the number of a week
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
