[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
xiong duan updated CALCITE-6431: -------------------------------- Description: When we use the SQL including the scalar query, converting this SQL Rel to HiveSQL will include the SINGLE_VALUE aggregation function(HiveSQL can't handle it) in the dialect SQL. In this PR, I will add Identifier Quote String for Spark and Hive, Here is the was:When we use the SQL including the scalar query, converting this SQL Rel to HiveSQL will include the SINGLE_VALUE aggregation function(HiveSQL can't handle it) in the dialect SQL. > Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect > ---------------------------------------------------------------------------- > > Key: CALCITE-6431 > URL: https://issues.apache.org/jira/browse/CALCITE-6431 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.37.0 > Reporter: xiong duan > Assignee: xiong duan > Priority: Major > Fix For: 1.38.0 > > > When we use the SQL including the scalar query, converting this SQL Rel to > HiveSQL will include the SINGLE_VALUE aggregation function(HiveSQL can't > handle it) in the dialect SQL. > In this PR, I will add Identifier Quote String for Spark and Hive, Here is > the > -- This message was sent by Atlassian Jira (v8.20.10#820010)