[
https://issues.apache.org/jira/browse/CALCITE-7103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18008280#comment-18008280
]
Zhen Chen commented on CALCITE-7103:
------------------------------------
I understand that you should test whether using or omitting "AS" causes errors
in Hive or Spark directly, rather than relying on Calcite's dialect conversion.
The purpose of dialect conversion is to transform standard SQL supported by
Calcite into specific SQL forms compatible with various database dialects.
> Keep ALLOWS_AS in Hive and Spark SqlDialects
> --------------------------------------------
>
> Key: CALCITE-7103
> URL: https://issues.apache.org/jira/browse/CALCITE-7103
> Project: Calcite
> Issue Type: Bug
> Reporter: xiaochen.zhou
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2025-07-20-03-55-59-759.png,
> image-2025-07-20-03-56-55-568.png, image-2025-07-20-04-21-14-158.png
>
>
> In Hive and Spark engines, the {{AS}} syntax is supported.
> [https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select.html|http://example.com/]
> !image-2025-07-20-03-56-55-568.png!
> However, currently, the Hive and Spark dialects will remove the {{AS}} during
> parsing.
> !image-2025-07-20-04-21-14-158.png|width=709,height=290!
>
> Therefore, we should set the default value of the method:
> {{!image-2025-07-20-03-55-59-759.png|width=655,height=149!}}
> to {{true}} in their respective dialects.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
