[jira] [Updated] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

2024-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6431: Labels: pull-request-available (was: ) > Implement the SINGLE_VALUE aggregation in

[jira] [Updated] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

2024-06-07 Thread xiong duan (Jira)
[ 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

[jira] [Updated] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

2024-06-07 Thread xiong duan (Jira)
[ 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

[jira] [Resolved] (CALCITE-6370) AS operator problems with USING clause

2024-06-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6370. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6311) Support PostgreSQL DATE_PART

2024-06-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6311. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-6430) SINGLE_VALUE rewrite to wrong sql when the sub-query return one NOT-NULL value and NULL value in PostgreSQL、MySQL、HSQL dialect

2024-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6430: Labels: pull-request-available (was: ) > SINGLE_VALUE rewrite to wrong sql when the

[jira] [Updated] (CALCITE-6430) SINGLE_VALUE rewrite to wrong sql when the sub-query return one NOT-NULL value and NULL value in PostgreSQL、MySQL、HSQL dialect

2024-06-07 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6430: Summary: SINGLE_VALUE rewrite to wrong sql when the sub-query return one NOT-NULL value and NULL

[jira] [Created] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

2024-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-6431: --- Summary: Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect Key: CALCITE-6431 URL: https://issues.apache.org/jira/browse/CALCITE-6431

[jira] [Updated] (CALCITE-6430) SINGLE_VALUE rewrite to wrong sql when the sub-query return one not-null value and NULL value in PostgreSQL、MySQL、HSQL dialect

2024-06-07 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6430: Description: Calcite rewrite the SINGLE_VALUE to different sql : For example in HSQL:

[jira] [Created] (CALCITE-6430) SINGLE_VALUE rewrite to wrong sql when the sub-query return one not-null value and NULL value in PostgreSQL、MySQL、HSQL dialect

2024-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-6430: --- Summary: SINGLE_VALUE rewrite to wrong sql when the sub-query return one not-null value and NULL value in PostgreSQL、MySQL、HSQL dialect Key: CALCITE-6430 URL:

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB when joining two tables with many fields

2024-06-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17853044#comment-17853044 ] Stamatis Zampetakis commented on CALCITE-3094: -- Hey James, I see no significant objections