[jira] [Assigned] (CALCITE-5638) Assertion Failure during planning correlated query with orderby

2024-02-23 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-5638: Assignee: Hanumath Rao Maduri > Assertion Failure during planning

[jira] [Assigned] (CALCITE-5390) RelDecorrelator throws NullPointerException

2024-02-22 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-5390: Assignee: Hanumath Rao Maduri (was: Dan Zou) > RelDecorrelator throws

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

2024-02-22 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17819894#comment-17819894 ] Hanumath Rao Maduri commented on CALCITE-5390: -- [~FrankZou]  Is it fine if I assign this

[jira] [Comment Edited] (CALCITE-6032) Multilevel correlated query is failing in RelDecorrelator code path

2024-02-20 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17818756#comment-17818756 ] Hanumath Rao Maduri edited comment on CALCITE-6032 at 2/20/24 10:48 AM:

[jira] [Commented] (CALCITE-6032) Multilevel correlated query is failing in RelDecorrelator code path

2024-02-20 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17818756#comment-17818756 ] Hanumath Rao Maduri commented on CALCITE-6032: -- The NullPoinerException reported in this

[jira] [Updated] (CALCITE-6242) The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic.

2024-02-03 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-6242: - Description: The following query is throwing a "param not found" in calcite

[jira] [Created] (CALCITE-6242) The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic.

2024-02-03 Thread Hanumath Rao Maduri (Jira)
Hanumath Rao Maduri created CALCITE-6242: Summary: The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic. Key: CALCITE-6242 URL:

[jira] [Commented] (CALCITE-6178) WITH RECURSIVE query when cloned using SqlShuttle loses RECURSIVE property

2024-01-08 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804429#comment-17804429 ] Hanumath Rao Maduri commented on CALCITE-6178: -- [~julianhyde]  This

[jira] [Comment Edited] (CALCITE-6178) WITH RECURSIVE query when cloned using SqlShuttle loses RECURSIVE property

2024-01-08 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804429#comment-17804429 ] Hanumath Rao Maduri edited comment on CALCITE-6178 at 1/8/24 7:06 PM:

[jira] [Updated] (CALCITE-6178) WITH RECURSIVE query when cloned using SqlShuttle looses RECURSIVE property

2024-01-08 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-6178: - Summary: WITH RECURSIVE query when cloned using SqlShuttle looses RECURSIVE

[jira] [Created] (CALCITE-6178) WITH RECURSIVE query when cloned using sqlshuttle looses RECURSIVE property

2023-12-25 Thread Hanumath Rao Maduri (Jira)
Hanumath Rao Maduri created CALCITE-6178: Summary: WITH RECURSIVE query when cloned using sqlshuttle looses RECURSIVE property Key: CALCITE-6178 URL: https://issues.apache.org/jira/browse/CALCITE-6178

[jira] [Updated] (CALCITE-6178) WITH RECURSIVE query when cloned using sqlshuttle looses RECURSIVE property

2023-12-25 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-6178: - Description: Here is a test case which shows that a recursive query becomes a

[jira] [Assigned] (CALCITE-6162) Add rule(s) to remove joins with constant single tuple relations

2023-12-12 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-6162: Assignee: Hanumath Rao Maduri > Add rule(s) to remove joins with

[jira] [Assigned] (CALCITE-6032) Multilevel correlated query is failing in RelDecorrelator code path

2023-12-12 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-6032: Assignee: Hanumath Rao Maduri > Multilevel correlated query is failing

[jira] [Commented] (CALCITE-129) Support recursive WITH queries

2023-10-30 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17781029#comment-17781029 ] Hanumath Rao Maduri commented on CALCITE-129: - [~julianhyde]  Thanks for the review and

[jira] [Assigned] (CALCITE-129) Support recursive WITH queries

2023-10-10 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-129: --- Assignee: Hanumath Rao Maduri > Support recursive WITH queries >

[jira] [Commented] (CALCITE-129) Support recursive WITH queries

2023-10-09 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17773446#comment-17773446 ] Hanumath Rao Maduri commented on CALCITE-129: - [Stamatis

[jira] [Comment Edited] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-25 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726066#comment-17726066 ] Hanumath Rao Maduri edited comment on CALCITE-5683 at 5/25/23 6:31 AM:

[jira] [Commented] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-25 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726066#comment-17726066 ] Hanumath Rao Maduri commented on CALCITE-5683: -- With the fix provided for this PR, it is

[jira] [Assigned] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-5683: Assignee: Hanumath Rao Maduri > Two level nested correlated subquery

[jira] [Updated] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-5683: - Description: The following two level nested query is throwing an exception. 

[jira] [Updated] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-5683: - Affects Version/s: 1.33.0 > Two level nested correlated subquery throws an

[jira] [Updated] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-5683: - Component/s: core > Two level nested correlated subquery throws an exception

[jira] [Created] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-02 Thread Hanumath Rao Maduri (Jira)
Hanumath Rao Maduri created CALCITE-5683: Summary: Two level nested correlated subquery throws an exception during decorrelation. Key: CALCITE-5683 URL: https://issues.apache.org/jira/browse/CALCITE-5683

[jira] [Assigned] (CALCITE-5631) Optimization to merge redundant joins

2023-04-15 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-5631: Assignee: Hanumath Rao Maduri > Optimization to merge redundant joins >

[jira] [Commented] (CALCITE-5314) Prune empty parts of a query by exploiting stats/metadata

2022-10-10 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17615140#comment-17615140 ] Hanumath Rao Maduri commented on CALCITE-5314: -- [~julianhyde] Thanks, I restricted only to

[jira] [Assigned] (CALCITE-5314) Prune empty parts of a query by exploiting stats/metadata

2022-10-07 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-5314: Assignee: Hanumath Rao Maduri > Prune empty parts of a query by

[jira] [Comment Edited] (CALCITE-5314) Prune empty parts of a query by exploiting stats/metadata

2022-10-07 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17614130#comment-17614130 ] Hanumath Rao Maduri edited comment on CALCITE-5314 at 10/7/22 3:48 PM:

[jira] [Commented] (CALCITE-5314) Prune empty parts of a query by exploiting stats/metadata

2022-10-07 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17614130#comment-17614130 ] Hanumath Rao Maduri commented on CALCITE-5314: -- [~zabetak] Thanks for creating this JIRA.

[jira] [Commented] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-11 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17057138#comment-17057138 ] Hanumath Rao Maduri commented on CALCITE-3815: -- [~donnyzone] Thanks  for trying out in PG.

[jira] [Commented] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-10 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17056651#comment-17056651 ] Hanumath Rao Maduri commented on CALCITE-3815: -- Thanks [~julianhyde] for the review. * In

[jira] [Assigned] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri reassigned CALCITE-3815: Assignee: Hanumath Rao Maduri > Add missing SQL standard aggregate

[jira] [Commented] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-02 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17049687#comment-17049687 ] Hanumath Rao Maduri commented on CALCITE-3815: -- [~julianhyde] It looks like INTERSECTION

[jira] [Commented] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-01 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17048667#comment-17048667 ] Hanumath Rao Maduri commented on CALCITE-3815: -- Can I work on this JIRA? If so can someone

[jira] [Updated] (CALCITE-2813) Semijoins are not being considered in LoptOptimizeJoinRule during join ordering

2019-01-28 Thread Hanumath Rao Maduri (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-2813: - Description: During the debugging a performance issue in Apache Drill, I have

[jira] [Updated] (CALCITE-2813) Semijoins are not being considered in LoptOptimizeJoinRule during join ordering

2019-01-28 Thread Hanumath Rao Maduri (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-2813: - Summary: Semijoins are not being considered in LoptOptimizeJoinRule during

[jira] [Updated] (CALCITE-2813) Semijoins are not being considered in LoptOptimizeJoinRule for ordering the joins

2019-01-28 Thread Hanumath Rao Maduri (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanumath Rao Maduri updated CALCITE-2813: - Description: During the debugging a performance issue in Apache Drill, I have

[jira] [Created] (CALCITE-2813) Semijoins are not being considered in LoptOptimizeJoinRule for ordering the joins

2019-01-28 Thread Hanumath Rao Maduri (JIRA)
Hanumath Rao Maduri created CALCITE-2813: Summary: Semijoins are not being considered in LoptOptimizeJoinRule for ordering the joins Key: CALCITE-2813 URL:

[jira] [Commented] (CALCITE-2507) Aliasing a star in select list should throw a parsing error.

2018-08-31 Thread Hanumath Rao Maduri (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16599453#comment-16599453 ] Hanumath Rao Maduri commented on CALCITE-2507: -- I have opened a pull request for this

[jira] [Created] (CALCITE-2507) Aliasing a star in select list should throw a parsing error.

2018-08-29 Thread Hanumath Rao Maduri (JIRA)
Hanumath Rao Maduri created CALCITE-2507: Summary: Aliasing a star in select list should throw a parsing error. Key: CALCITE-2507 URL: https://issues.apache.org/jira/browse/CALCITE-2507