[
https://issues.apache.org/jira/browse/CALCITE-6434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17854487#comment-17854487
]
Julian Hyde commented on CALCITE-6434:
--------------------------------------
The summary seems to describe the fix rather than the problem. The problem
seems to be that the JDBC adapter generates wrong SQL for Spark and Hive
because it fails to quote an identifier containing '$'. Do I have that right?
> Specify identifier quoting for HiveSqlDialect and SparkSqlDialect
> -----------------------------------------------------------------
>
> Key: CALCITE-6434
> URL: https://issues.apache.org/jira/browse/CALCITE-6434
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.37.0
> Reporter: xiong duan
> Assignee: xiong duan
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.38.0
>
>
> The SQL:
> {code:java}
> SELECT product.product_class_id C
> FROM foodmart.product
> LEFT JOIN (SELECT CASE COUNT(*) WHEN 0 THEN NULL WHEN 1 THEN
> MIN(product_class_id) ELSE (SELECT NULL
> UNION ALL
> SELECT NULL) END $f0
> FROM foodmart.product) t0 ON TRUE
> WHERE product.net_weight > t0.$f0{code}
> Generate by SINGLE_VALUE agg function.
> This SQL will parse failed in Spark Unless we add the identifier quoting like
> `t0`.`$f0`
> I will add identifier Quote String for Spark and Hive, Here is the document:
> * [https://spark.apache.org/docs/latest/sql-ref-identifier.html]
> *
> [https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.support.quoted.identifiers]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
