[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=17934112#comment-17934112 ] Yu Xu commented on CALCITE-6815: Thanks for [~julianhyde]  remind,  I added an exaplme

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

[ https://issues.apache.org/jira/browse/CALCITE-6814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934116#comment-17934116 ] Yu Xu commented on CALCITE-6814: [~zabetak] Sorry for late, thanks for reminder, I clos

[jira] [Updated] (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 ] Yu Xu updated CALCITE-6815: --- Description: Currently calcite not support bin functions for Hive and Spark Library, need to support it.

[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=17934110#comment-17934110 ] Yu Xu commented on CALCITE-6876: [~zabetak] OK, thank you very much~ > Druid Adapter s

[jira] [Assigned] (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 reassigned CALCITE-6881: -- Assignee: Yu Xu > 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=17934063#comment-17934063 ] Yu Xu commented on CALCITE-6881: [~zabetak] OK, thanks~ > Druid Adapter can not handle

[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=17934061#comment-17934061 ] xiong duan commented on CALCITE-5036: - Sorry for causing this inconvenience. Next t

[jira] [Commented] (CALCITE-6877) Generate LogicalProject in RelRoot.project() when mapping is not name trivial

[ https://issues.apache.org/jira/browse/CALCITE-6877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934043#comment-17934043 ] Niels Pardon commented on CALCITE-6877: --- > Why were the tests added to RelToSqlCo

[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 ] Julian Hyde updated CALCITE-2530: - Description: Calcite's TRIM function takes the first character of string to trim the , wherea

[jira] [Comment Edited] (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:comment-tabpanel&focusedCommentId=17914105#comment-17914105 ] Julian Hyde edited comment on CALCITE-2530 at 3/10/25 8:09 PM: --

[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934042#comment-17934042 ] Ian Bertolacci commented on CALCITE-3428: - [~julianhyde] We opened CALCITE-6882

[jira] [Updated] (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:all-tabpanel ] Ian Bertolacci updated CALCITE-6882: Description: There is some overly conservative logic in determining uniqueness of columns

[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934032#comment-17934032 ] Julian Hyde commented on CALCITE-3428: -- [~ian.bertolacci], Can you please open a n

[jira] [Commented] (CALCITE-6877) Generate LogicalProject in RelRoot.project() when mapping is not name trivial

[ https://issues.apache.org/jira/browse/CALCITE-6877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934030#comment-17934030 ] Julian Hyde commented on CALCITE-6877: -- [~zrlpar], Why were the tests added to Rel

[jira] [Closed] (CALCITE-3471) Only return 10 records use jdbc:calcite method

[ https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-3471. Resolved in release 1.18.0 (2012-12-21) > Only return 10 records use jdbc:calcite method > -

[jira] [Closed] (CALCITE-899) Make NonReservedKeyWord List Extendable

[ https://issues.apache.org/jira/browse/CALCITE-899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-899. --- > Make NonReservedKeyWord List Extendable > --- > >

[jira] [Commented] (CALCITE-899) Make NonReservedKeyWord List Extendable

[ https://issues.apache.org/jira/browse/CALCITE-899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934019#comment-17934019 ] Julian Hyde commented on CALCITE-899: - Resolved in release 1.18.0 (2012-12-21) > Ma

[jira] [Closed] (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 ] Julian Hyde closed CALCITE-2530. Resolved in release 1.18.0 (2012-12-21) > TRIM function does not throw exception when the length of

[jira] [Created] (CALCITE-6880) Implement IntersectToSemiJoinRule

Zhen Chen created CALCITE-6880: -- Summary: Implement IntersectToSemiJoinRule Key: CALCITE-6880 URL: https://issues.apache.org/jira/browse/CALCITE-6880 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6734) RelFieldTrimmer should trim Aggregate's input fields which are arguments of unused aggregate functions

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

[jira] [Assigned] (CALCITE-6734) RelFieldTrimmer should trim Aggregate's input fields which are arguments of unused aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-6734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6734: Assignee: Viggo Chen > RelFieldTrimmer should trim Aggregate's input fie

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

[ https://issues.apache.org/jira/browse/CALCITE-6814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933863#comment-17933863 ] Stamatis Zampetakis commented on CALCITE-6814: -- Removed the fix version si

[jira] [Assigned] (CALCITE-6663) Support SPLIT_PART function for Postgres

[ https://issues.apache.org/jira/browse/CALCITE-6663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6663: Assignee: Qi Zhu (was: zhuqi) > Support SPLIT_PART function for Postgre

[jira] [Commented] (CALCITE-6663) Support SPLIT_PART function for Postgres

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

[jira] [Assigned] (CALCITE-6663) Support SPLIT_PART function for Postgres

[ https://issues.apache.org/jira/browse/CALCITE-6663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6663: Assignee: zhuqi > Support SPLIT_PART function for Postgres > ---

[jira] [Commented] (CALCITE-6804) Anti-join with WHERE NOT EXISTS syntax has corrupted condition

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

[jira] [Assigned] (CALCITE-6796) Convert Type from BINARY to VARBINARY in PrestoDialect

[ https://issues.apache.org/jira/browse/CALCITE-6796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6796: Assignee: xiaochen.zhou (was: xiaochen.zhou) > Convert Type from BINARY

[jira] [Resolved] (CALCITE-6796) Convert Type from BINARY to VARBINARY in PrestoDialect

[ https://issues.apache.org/jira/browse/CALCITE-6796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-6796. -- Resolution: Fixed > Convert Type from BINARY to VARBINARY in PrestoDialect >

[jira] [Reopened] (CALCITE-6796) Convert Type from BINARY to VARBINARY in PrestoDialect

[ https://issues.apache.org/jira/browse/CALCITE-6796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reopened CALCITE-6796: -- Assignee: xiaochen.zhou > Convert Type from BINARY to VARBINARY in PrestoDi

[jira] [Assigned] (CALCITE-6804) Anti-join with WHERE NOT EXISTS syntax has corrupted condition

[ https://issues.apache.org/jira/browse/CALCITE-6804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6804: Assignee: Anton Kovalevsky > Anti-join with WHERE NOT EXISTS syntax has

[jira] [Resolved] (CALCITE-6879) Support APPROX_DISTINCT_COUNT for more dialects

[ https://issues.apache.org/jira/browse/CALCITE-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-6879. -- Assignee: Yu Xu Resolution: Fixed Fixed in https://github.com/apache/c

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

[ https://issues.apache.org/jira/browse/CALCITE-6846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-6846. -- Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/618e601b

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

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

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

[ https://issues.apache.org/jira/browse/CALCITE-6846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6846: - Summary: Support basic DPhyp join reorder algorithm (was: Support basic dphyp

[jira] [Resolved] (CALCITE-6877) Generate LogicalProject in RelRoot.project() when mapping is not name trivial

[ https://issues.apache.org/jira/browse/CALCITE-6877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-6877. -- Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/29452b34

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

[ https://issues.apache.org/jira/browse/CALCITE-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6876: - Assignee: Alessandro Solimando > Druid Adapter support more functions

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

[ https://issues.apache.org/jira/browse/CALCITE-6814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6814: - Fix Version/s: (was: 1.39.0) > Support weekofyear functions for Hive >

[jira] [Commented] (CALCITE-6646) Support timestamp data type in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933855#comment-17933855 ] Stamatis Zampetakis commented on CALCITE-6646: -- I removed the fix version

[jira] [Updated] (CALCITE-6646) Support timestamp data type in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-6646: - Fix Version/s: (was: 1.39.0) > Support timestamp data type in Arrow adapter

[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17933853#comment-17933853 ] Stamatis Zampetakis commented on CALCITE-6718: -- I removed the fix version

[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] [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: Attachment: image-2025-03-10-19-19-59-437.png > Decorrelate boolean context IN or existential sub

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

[ https://issues.apache.org/jira/browse/CALCITE-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-6876: Assignee: Yu Xu (was: Alessandro Solimando) > Druid Adapter support mor

[jira] [Assigned] (CALCITE-6800) Enable a few existing functions to Hive library

[ https://issues.apache.org/jira/browse/CALCITE-6800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6800: - Assignee: Yu Xu > Enable a few existing functions to Hive library > --

[jira] [Assigned] (CALCITE-6847) ClickHouse doesn't support TRUE/FALSE keywords in its Join predicate

[ https://issues.apache.org/jira/browse/CALCITE-6847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6847: - Assignee: Yu Xu > ClickHouse doesn't support TRUE/FALSE keywords in it

[jira] [Assigned] (CALCITE-6844) Add all array spark functions which also support in Hive(enable in Hive Library)

[ https://issues.apache.org/jira/browse/CALCITE-6844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6844: - Assignee: Yu Xu > Add all array spark functions which also support in

[jira] [Assigned] (CALCITE-6805) Support hex function for Hive and Spark Library

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

[jira] [Assigned] (CALCITE-6818) Write LIMIT for fetch operations in Snowflake

[ https://issues.apache.org/jira/browse/CALCITE-6818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6818: - Assignee: Yu Xu > Write LIMIT for fetch operations in Snowflake >

[jira] [Assigned] (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 ] Alessandro Solimando reassigned CALCITE-6841: - Assignee: Yu Xu > Elasticsearch Adapter version should support util 8.

[jira] [Assigned] (CALCITE-6821) Support crc32 function for Hive and Spark library

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

[jira] [Assigned] (CALCITE-6867) Druid Adapter transforms an SQL NOT IN filter to a Druid IN filter

[ https://issues.apache.org/jira/browse/CALCITE-6867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6867: - Assignee: Yu Xu (was: Mihai Budiu) > Druid Adapter transforms an SQL

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

[ https://issues.apache.org/jira/browse/CALCITE-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6876. --- Resolution: Fixed Fixed via [{{569ed6b}}|https://github.com/apache/calcite