[jira] [Commented] (CALCITE-5616) Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707153#comment-17707153 ] Julian Hyde commented on CALCITE-5616: -- Did you consider overriding {{SqlDialect.u

[jira] [Updated] (CALCITE-5619) Support PostgreSQL's TO_CHAR function

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5619: - Fix Version/s: 1.35.0 > Support PostgreSQL's TO_CHAR function > ---

[jira] [Commented] (CALCITE-5619) Support PostgreSQL's TO_CHAR function

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707148#comment-17707148 ] Julian Hyde commented on CALCITE-5619: -- Thanks for the PR, [~tnieradzik]. In his

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707140#comment-17707140 ] Benchao Li commented on CALCITE-5590: - [~dmsysolyatin] Thanks for the quick respons

[jira] [Commented] (CALCITE-5581) Implement Basic client side load balancing in Avatica Driver

2023-03-30 Thread Vaibhav Joshi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707131#comment-17707131 ] Vaibhav Joshi commented on CALCITE-5581: *Summary of changes so far.* We have

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:36 AM:

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:36 AM:

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:29 AM:

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707123#comment-17707123 ] Dmitry Sysolyatin commented on CALCITE-5590: [~libenchao] Yes, it is relate

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707121#comment-17707121 ] Julian Hyde commented on CALCITE-5625: -- It seems to me the bug is that RelJson can

[jira] [Commented] (CALCITE-5623) calcite assert keyword usage

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707117#comment-17707117 ] Julian Hyde commented on CALCITE-5623: -- I guess this is more of a question / discu

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707113#comment-17707113 ] Benchao Li commented on CALCITE-5590: - [~jiajunbernoulli] Are you sure that this is

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707108#comment-17707108 ] Julian Hyde commented on CALCITE-5624: -- Can you give an example? > Cannot parse a

[jira] [Commented] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

2023-03-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707105#comment-17707105 ] Julian Hyde commented on CALCITE-5626: -- I agree that this is a bug. Fully-qualifie

[jira] [Resolved] (CALCITE-5605) Add BigQuery as supported library for CHR

2023-03-30 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5605. - Fix Version/s: 1.35.0 Resolution: Fixed > Add BigQuery as supported library for CHR > --

[jira] [Commented] (CALCITE-5605) Add BigQuery as supported library for CHR

2023-03-30 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707085#comment-17707085 ] Jiajun Xie commented on CALCITE-5605: - Fixed in [{{a10b858}}|https://github.com/ap

[jira] [Updated] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

2023-03-30 Thread Roman Churganov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roman Churganov updated CALCITE-5626: - Description: If query has a sub-query in EXIXST function and full column names used in

[jira] [Updated] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

2023-03-30 Thread Roman Churganov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roman Churganov updated CALCITE-5626: - Description: If query has a sub-query with EXIXST and full column names used in sub-qu

[jira] [Updated] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

2023-03-30 Thread Roman Churganov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roman Churganov updated CALCITE-5626: - Affects Version/s: 1.34.0 (was: 1.30.0) > Query with EXISTS

[jira] [Created] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

2023-03-30 Thread Roman Churganov (Jira)
Roman Churganov created CALCITE-5626: Summary: Query with EXISTS function gives Table ... not found error Key: CALCITE-5626 URL: https://issues.apache.org/jira/browse/CALCITE-5626 Project: Calcite

[jira] [Created] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-30 Thread Oliver Lee (Jira)
Oliver Lee created CALCITE-5625: --- Summary: Expand SEARCH RexNode when converting toJson Key: CALCITE-5625 URL: https://issues.apache.org/jira/browse/CALCITE-5625 Project: Calcite Issue Type: S

[jira] [Commented] (CALCITE-5614) Serialize and deserialize Sarg objects

2023-03-30 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707048#comment-17707048 ] Oliver Lee commented on CALCITE-5614: - Relevant thread: [https://github.com/google/

[jira] [Updated] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5624: Labels: pull-request-available (was: ) > Cannot parse array function for Spark Dialect >

[jira] [Updated] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-30 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5624: - Description: AtomicRowExpression should not have ArrayConstructor for Apache Spark. Arr

[jira] [Updated] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-30 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5624: - Summary: Cannot parse array function for Spark Dialect (was: Cannot parse array udf fo

[jira] [Commented] (CALCITE-5624) Cannot parse array udf for Spark Dialect

2023-03-30 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706994#comment-17706994 ] Guillaume Massé commented on CALCITE-5624: -- Hum it does not look like Parser.j

[jira] [Updated] (CALCITE-5624) Cannot parse array udf for Spark Dialect

2023-03-30 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5624: - Description: AtomicRowExpression should not have ArrayConstructor for Apache Spark. Arr

[jira] [Created] (CALCITE-5624) Cannot parse array udf for Spark Dialect

2023-03-30 Thread Jira
Guillaume Massé created CALCITE-5624: Summary: Cannot parse array udf for Spark Dialect Key: CALCITE-5624 URL: https://issues.apache.org/jira/browse/CALCITE-5624 Project: Calcite Issue Ty

[jira] [Updated] (CALCITE-4771) change the value of the CAST function to be nullable

2023-03-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4771: Labels: pull-request-available (was: ) > change the value of the CAST function to be nul

[jira] [Commented] (CALCITE-5622) Cast is lost from plan to postgres statement

2023-03-30 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706844#comment-17706844 ] Corvin Kuebler commented on CALCITE-5622: - Hey,  instead of  "CAST(\"brand_nam

[jira] [Commented] (CALCITE-5618) count() query is very slow in large data

2023-03-30 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706815#comment-17706815 ] Benchao Li commented on CALCITE-5618: - [~huge] Please note that Calcite Enumerable

[jira] (CALCITE-5623) calcite assert keyword usage

2023-03-30 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623 ] Ran Tao deleted comment on CALCITE-5623: -- was (Author: lemonjing): reopen > calcite assert keyword usage > > > Key: CALCITE-5623 >

[jira] (CALCITE-5618) count() query is very slow in large data

2023-03-30 Thread hufukang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5618 ] hufukang deleted comment on CALCITE-5618: --- was (Author: JIRAUSER299583): [~libenchao]   我目前在使用VolcanoPlanner优化器尝试对count()函数的执行效率进行优化,在数据量很大,并且使用left join关联其他表的条件下,优化的结果并不明显。希望能提示一下优化的方向。 > c

[jira] [Updated] (CALCITE-5623) calcite assert keyword usage

2023-03-30 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5623: - Description: The code of many calcite modules use the 'assert' keyword of java to do checking, which a

[jira] [Updated] (CALCITE-5623) calcite assert keyword usage

2023-03-30 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5623: - Component/s: core Affects Version/s: 1.34.0 Description: The code of many calcite m

[jira] [Commented] (CALCITE-5622) Cast is lost from plan to postgres statement

2023-03-30 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706812#comment-17706812 ] Benchao Li commented on CALCITE-5622: - You mean {{DATE '2023-03-27'}} should be {{C

[jira] [Reopened] (CALCITE-5623) assert

2023-03-30 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao reopened CALCITE-5623: -- reopen > assert > -- > > Key: CALCITE-5623 > URL: https://issues.apa

[jira] [Closed] (CALCITE-5623) assert

2023-03-30 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao closed CALCITE-5623. Resolution: Invalid > assert > -- > > Key: CALCITE-5623 > URL: https:

[jira] [Created] (CALCITE-5623) assert

2023-03-30 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5623: Summary: assert Key: CALCITE-5623 URL: https://issues.apache.org/jira/browse/CALCITE-5623 Project: Calcite Issue Type: Bug Reporter: Ran Tao

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-03-30 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706799#comment-17706799 ] Stamatis Zampetakis commented on CALCITE-5615: -- Agree with Benchao! Anythi

[jira] [Updated] (CALCITE-5622) Cast is lost from plan to postgres statement

2023-03-30 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-5622: Summary: Cast is lost from plan to postgres statement (was: Cast is lost from Plan to Po

[jira] [Created] (CALCITE-5622) Cast is lost from Plan to Postgres Statement

2023-03-30 Thread Corvin Kuebler (Jira)
Corvin Kuebler created CALCITE-5622: --- Summary: Cast is lost from Plan to Postgres Statement Key: CALCITE-5622 URL: https://issues.apache.org/jira/browse/CALCITE-5622 Project: Calcite Issue