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)