[jira] [Updated] (CALCITE-6063) ARRAY subquery with OrderBy loses Sort

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6063: - Description: calcite support array query constructor. but If we run sub-query with orderby:

[jira] [Updated] (CALCITE-6063) ARRAY subquery with OrderBy loses Sort

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6063: - Description: calcite support array query constructor. but If we run sub-query with orderby:

[jira] [Commented] (CALCITE-6216) The JDBC adapter is unable to push down queries when a query involves multiple data sources

2024-01-23 Thread xjlem (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810219#comment-17810219 ] xjlem commented on CALCITE-6216: [~julianhyde] Thank you for your reply. I found that the version used

[jira] [Resolved] (CALCITE-6216) The JDBC adapter is unable to push down queries when a query involves multiple data sources

2024-01-23 Thread xjlem (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xjlem resolved CALCITE-6216. Resolution: Fixed > The JDBC adapter is unable to push down queries when a query involves > multiple

[jira] [Updated] (CALCITE-6063) ARRAY subquery with OrderBy loses Sort

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6063: - Summary: ARRAY subquery with OrderBy loses Sort (was: ARRAY subquery with OrderBy gives unexpected

[jira] [Updated] (CALCITE-6063) ARRAY subquery with OrderBy gives unexpected results

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6063: - Summary: ARRAY subquery with OrderBy gives unexpected results (was: ARRAY sub-query with OrderBy

[jira] [Comment Edited] (CALCITE-6063) ARRAY sub-query with OrderBy gives unexpected results

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17778540#comment-17778540 ] Ran Tao edited comment on CALCITE-6063 at 1/24/24 3:37 AM: --- In reference.md

[jira] [Assigned] (CALCITE-6063) ARRAY sub-query with OrderBy gives unexpected results

2024-01-23 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao reassigned CALCITE-6063: Assignee: Ran Tao > ARRAY sub-query with OrderBy gives unexpected results >

[jira] [Comment Edited] (CALCITE-6219) Support SQL Validation for Tables with columns tagged as 'filter required'

2024-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810180#comment-17810180 ] Julian Hyde edited comment on CALCITE-6219 at 1/24/24 3:04 AM: --- That

[jira] [Commented] (CALCITE-6219) Support SQL Validation for Tables with columns tagged as 'filter required'

2024-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810180#comment-17810180 ] Julian Hyde commented on CALCITE-6219: -- That sounds good. Views are also a consideration;

[jira] [Comment Edited] (CALCITE-6188) Multi-query optimization

2024-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810169#comment-17810169 ] Julian Hyde edited comment on CALCITE-6188 at 1/24/24 2:41 AM: --- Thank

[jira] [Commented] (CALCITE-6188) Multi-query optimization

2024-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810169#comment-17810169 ] Julian Hyde commented on CALCITE-6188: -- Thank you, [~zabetak]! I knew Hive had such a syntax, but

[jira] [Commented] (CALCITE-6216) The JDBC adapter is unable to push down queries when a query involves multiple data sources

2024-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810164#comment-17810164 ] Julian Hyde commented on CALCITE-6216: -- As you note, JDBC rules are unique in that they have

[jira] [Resolved] (CALCITE-6205) Add BITAND_AGG, BITOR_AGG functions (enabled in Snowflake library)

2024-01-23 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-6205. --- Resolution: Fixed Merged via