xiong duan created CALCITE-6434:
-----------------------------------
Summary: 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
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`
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
