[jira] [Closed] (CALCITE-6814) Support weekofyear functions for Hive

[ https://issues.apache.org/jira/browse/CALCITE-6814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yu Xu closed CALCITE-6814. -- Resolution: Won't Fix > Support weekofyear functions for Hive > - > >

[jira] [Updated] (CALCITE-6883) Move RelRoot tests to dedicated test class

[ https://issues.apache.org/jira/browse/CALCITE-6883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Niels Pardon updated CALCITE-6883: -- Fix Version/s: 1.39.0 > Move RelRoot tests to dedicated test class >

[jira] [Assigned] (CALCITE-6883) Move RelRoot tests to dedicated test class

[ https://issues.apache.org/jira/browse/CALCITE-6883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Niels Pardon reassigned CALCITE-6883: - Assignee: Niels Pardon > Move RelRoot tests to dedicated test class >

[jira] [Updated] (CALCITE-6883) Move RelRoot tests to dedicated test class

[ https://issues.apache.org/jira/browse/CALCITE-6883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6883: Labels: pull-request-available (was: ) > Move RelRoot tests to dedicated test class > --

[jira] [Created] (CALCITE-6883) Move RelRoot tests to dedicated test class

Niels Pardon created CALCITE-6883: - Summary: Move RelRoot tests to dedicated test class Key: CALCITE-6883 URL: https://issues.apache.org/jira/browse/CALCITE-6883 Project: Calcite Issue Type:

[jira] [Assigned] (CALCITE-6875) EnumerableFilterRule/EnumerableProjectRule should not convert a Logical Filter/Project to Enumerable Filter/Project when it contains Subquery

[ https://issues.apache.org/jira/browse/CALCITE-6875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan reassigned CALCITE-6875: --- Assignee: xiong duan > EnumerableFilterRule/EnumerableProjectRule should not convert a Log

[jira] [Commented] (CALCITE-6727) Column uniqueness constrain should only apply to inner join

[ https://issues.apache.org/jira/browse/CALCITE-6727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933920#comment-17933920 ] Stamatis Zampetakis commented on CALCITE-6727: -- [~joeyutong] I added you a

[jira] [Updated] (CALCITE-6884) RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables

[ https://issues.apache.org/jira/browse/CALCITE-6884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jie Yang updated CALCITE-6884: -- Description: The `RelToSqlConverter` class has a bug when converting a `Correlate` operator to SQL f

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

[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6431: Fix Version/s: 1.40.0 > Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDial

[jira] [Updated] (CALCITE-6884) RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables

[ https://issues.apache.org/jira/browse/CALCITE-6884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jie Yang updated CALCITE-6884: -- Description: The `RelToSqlConverter` class has a bug when converting a `Correlate` operator to SQL f

[jira] [Created] (CALCITE-6884) RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables

Jie Yang created CALCITE-6884: - Summary: RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables Key: CALCITE-6884 URL: https://issues.apache.org/jira/browse/CALCITE-6884

[jira] [Updated] (CALCITE-6884) RelToSqlConverter generates invalid MySQL syntax for Correlate operator with multiple tables

[ https://issues.apache.org/jira/browse/CALCITE-6884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jie Yang updated CALCITE-6884: -- Description: The `RelToSqlConverter` class has a bug when converting a `Correlate` operator to SQL f

[jira] [Comment Edited] (CALCITE-6815) Support bin function for Spark and Hive Library

[ https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934112#comment-17934112 ] Yu Xu edited comment on CALCITE-6815 at 3/11/25 6:28 AM: - Thank

[jira] [Updated] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yu Xu updated CALCITE-6881: --- Description: Currently Druid Adapter can not handle for strlen(char_length and charactor_length both would

[jira] [Assigned] (CALCITE-6831) Add ARRAY_SLICE function（enabled in Hive Library）

[ https://issues.apache.org/jira/browse/CALCITE-6831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6831: - Assignee: Yu Xu > Add ARRAY_SLICE function（enabled in Hive Library） >

[jira] [Assigned] (CALCITE-6812) Support base64 and unbase64 fucntions for Hive

[ https://issues.apache.org/jira/browse/CALCITE-6812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6812: - Assignee: Yu Xu > Support base64 and unbase64 fucntions for Hive > ---

[jira] [Updated] (CALCITE-6595) AggregateExpandWithinDistinctRule drops aggregateCall.collation on non-distinct agg

[ https://issues.apache.org/jira/browse/CALCITE-6595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6595: - Fix Version/s: 1.38.0 > AggregateExpandWithinDistinctRule drops aggregateCall.c

[jira] [Commented] (CALCITE-6846) Support basic DPhyp join reorder algorithm

[ https://issues.apache.org/jira/browse/CALCITE-6846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933873#comment-17933873 ] Stamatis Zampetakis commented on CALCITE-6846: -- For the record, my [previo

[jira] [Assigned] (CALCITE-6605) Lattice SQL supports complex column expressions

[ https://issues.apache.org/jira/browse/CALCITE-6605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6605: Assignee: EveyWu > Lattice SQL supports complex column expressions > --

[jira] [Updated] (CALCITE-6274) Join between Elasticsearch indexes returns empty result

[ https://issues.apache.org/jira/browse/CALCITE-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6274: - Summary: Join between Elasticsearch indexes returns empty result (was: Two Ela

[jira] [Updated] (CALCITE-6844) Enable various existing ARRAY functions in Hive

[ https://issues.apache.org/jira/browse/CALCITE-6844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6844: - Summary: Enable various existing ARRAY functions in Hive (was: Add all array s

[jira] [Created] (CALCITE-6881) Druid Adapter can not handle for strlen call

Yu Xu created CALCITE-6881: -- Summary: Druid Adapter can not handle for strlen call Key: CALCITE-6881 URL: https://issues.apache.org/jira/browse/CALCITE-6881 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6881: - Fix Version/s: 1.40.0 (was: 1.39.0) > Druid Adapter can

[jira] [Updated] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yu Xu updated CALCITE-6881: --- Description: Currently Druid Adapter can not handle for strlen call such as:  *test:* final String sql1 =

[jira] [Updated] (CALCITE-6875) EnumerableFilterRule/EnumerableProjectRule should not convert a Logical Filter/Project to Enumerable Filter/Project when it contains Subquery

[ https://issues.apache.org/jira/browse/CALCITE-6875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6875: Fix Version/s: 1.40.0 > EnumerableFilterRule/EnumerableProjectRule should not convert a Logical

[jira] [Assigned] (CALCITE-6699) Invalid unparse for Varchar in StarRocksDialect

[ https://issues.apache.org/jira/browse/CALCITE-6699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6699: Assignee: xiaochen.zhou > Invalid unparse for Varchar in StarRocksDialec

[jira] [Assigned] (CALCITE-6727) Column uniqueness constrain should only apply to inner join

[ https://issues.apache.org/jira/browse/CALCITE-6727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6727: Assignee: Yu Tang > Column uniqueness constrain should only apply to inn

[jira] [Assigned] (CALCITE-6850) ProjectRemoveRule with two Projects does not keep field names from the top one

[ https://issues.apache.org/jira/browse/CALCITE-6850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6850: Assignee: Zhen Chen > ProjectRemoveRule with two Projects does not keep

[jira] [Updated] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

[ https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viggo Chen updated CALCITE-3373: Description: The current approach to generate semi-join from IN/EXISTS is as below (except the g

[jira] [Commented] (CALCITE-6595) AggregateExpandWithinDistinctRule drops aggregateCall.collation on non-distinct agg

[ https://issues.apache.org/jira/browse/CALCITE-6595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933975#comment-17933975 ] Stamatis Zampetakis commented on CALCITE-6595: -- Fixed in https://github.c

[jira] [Updated] (CALCITE-6872) Release Calcite 1.39.0

[ https://issues.apache.org/jira/browse/CALCITE-6872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6872: Labels: pull-request-available (was: ) > Release Calcite 1.39.0 > --

[jira] [Assigned] (CALCITE-6815) Support bin function for Spark and Hive Library

[ https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6815: - Assignee: Yu Xu > Support bin function for Spark and Hive Library > --

[jira] [Updated] (CALCITE-6855) Report elapsed time in ConnectionPropertiesHATest assert

[ https://issues.apache.org/jira/browse/CALCITE-6855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6855: - Fix Version/s: avatica-1.27.0 > Report elapsed time in ConnectionPropertiesHATe

[jira] [Updated] (CALCITE-6755) Add SUBSTRING function(enabled in MSSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6755: - Fix Version/s: 1.39.0 > Add SUBSTRING function(enabled in MSSQL library) >

[jira] [Resolved] (CALCITE-6788) LoptOptimizeJoinRule should be able to delegate costs to the planner

[ https://issues.apache.org/jira/browse/CALCITE-6788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-6788. Resolution: Fixed Done via [{{ac7d25c}}|https://github.com/apache/calcite/commit/ac7d25c74f5ba33

[jira] [Updated] (CALCITE-6841) Elasticsearch Adapter version should support util 8.x

[ https://issues.apache.org/jira/browse/CALCITE-6841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6841: - Fix Version/s: 1.39.0 > Elasticsearch Adapter version should support util 8.x >

[jira] [Updated] (CALCITE-6626) SqlToRelConverter mixes uses of configured RelBuilder and Logical.create methods.

[ https://issues.apache.org/jira/browse/CALCITE-6626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6626: - Fix Version/s: 1.39.0 > SqlToRelConverter mixes uses of configured RelBuilder a

[jira] [Commented] (CALCITE-6815) Support bin function for Spark and Hive Library

[ https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934320#comment-17934320 ] Julian Hyde commented on CALCITE-6815: -- That's great. Thank you! > Support bin fu

[jira] [Commented] (CALCITE-5036) `RelMetadataQuery#getPulledUpPredicates` support to analyze constant key for the operator of IS_NOT_DISTINCT_FROM

[ https://issues.apache.org/jira/browse/CALCITE-5036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933969#comment-17933969 ] Stamatis Zampetakis commented on CALCITE-5036: -- [~nobigo] What exactly hap

[jira] [Updated] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-2530: - Fix Version/s: 1.18.0 > TRIM function does not throw exception when the length

[jira] [Updated] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6881: Labels: pull-request-available (was: ) > Druid Adapter can not handle for strlen call >

[jira] [Commented] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933989#comment-17933989 ] Stamatis Zampetakis commented on CALCITE-6881: -- I started the release proc

[jira] [Updated] (CALCITE-6881) Druid Adapter can not handle for strlen call

[ https://issues.apache.org/jira/browse/CALCITE-6881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yu Xu updated CALCITE-6881: --- Description: Currently Druid Adapter can not handle for strlen call such as:   final String sql1 = "SELECT

[jira] [Updated] (CALCITE-6718) Optimize SubstitutionVisitor's splitFilter with early return and uniform simplification for equivalence checking

[ https://issues.apache.org/jira/browse/CALCITE-6718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6718: - Fix Version/s: (was: 1.39.0) > Optimize SubstitutionVisitor's splitFilter w

[jira] [Updated] (CALCITE-6750) ProjectWindowTransposeRule does not consider references in bounds

[ https://issues.apache.org/jira/browse/CALCITE-6750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6750: - Fix Version/s: 1.39.0 > ProjectWindowTransposeRule does not consider references

[jira] [Commented] (CALCITE-6882) RelMdColumnUniqueness incorrectly claims fields are not unique if constant refinement occurs in a node above join

[ https://issues.apache.org/jira/browse/CALCITE-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934047#comment-17934047 ] Ian Bertolacci commented on CALCITE-6882: - Some pertinant exerpts from the emai

[jira] [Commented] (CALCITE-6882) RelMdColumnUniqueness incorrectly claims fields are not unique if constant refinement occurs in a node above join

[ https://issues.apache.org/jira/browse/CALCITE-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934324#comment-17934324 ] Julian Hyde commented on CALCITE-6882: -- Let me attempt to paraphrase what you said

[jira] [Updated] (CALCITE-6673) Add regression tests for shaded Avatica jar

[ https://issues.apache.org/jira/browse/CALCITE-6673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6673: - Fix Version/s: avatica-1.26.0 > Add regression tests for shaded Avatica jar > -

[jira] [Updated] (CALCITE-6653) http client and slf4j not relocated by shaded avatica artifact

[ https://issues.apache.org/jira/browse/CALCITE-6653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6653: - Fix Version/s: avatica-1.26.0 > http client and slf4j not relocated by shaded a

[jira] [Created] (CALCITE-6882) RelMdColumnUniqueness incorrectly claims fields are not unique if constant refinement occurs in a node above join

Ian Bertolacci created CALCITE-6882: --- Summary: RelMdColumnUniqueness incorrectly claims fields are not unique if constant refinement occurs in a node above join Key: CALCITE-6882 URL: https://issues.apache.org/j

[jira] [Updated] (CALCITE-6797) Run Avatica CI with JDK23

[ https://issues.apache.org/jira/browse/CALCITE-6797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6797: - Fix Version/s: avatica-1.26.0 > Run Avatica CI with JDK23 > ---

[jira] [Commented] (CALCITE-6876) Druid Adapter support more functions

[ https://issues.apache.org/jira/browse/CALCITE-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933774#comment-17933774 ] Stamatis Zampetakis commented on CALCITE-6876: -- Hey [~xuzifu666], I added

[jira] [Updated] (CALCITE-6705) Allow for dialect-specific unparsing for numeric literals

[ https://issues.apache.org/jira/browse/CALCITE-6705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6705: - Fix Version/s: 1.39.0 > Allow for dialect-specific unparsing for numeric litera

[jira] [Commented] (CALCITE-6879) Dialect support APPROX_DISTINCT_COUNT for more dialects

[ https://issues.apache.org/jira/browse/CALCITE-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933704#comment-17933704 ] Yu Xu commented on CALCITE-6879: Hi [~asolimando] , I had addressed comments in PR, cou