[jira] [Commented] (CALCITE-5089) Allow GROUP BY ALL or DISTINCT set quantifier on GROUPING SETS

2022-05-18 Thread yanjing.wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539191#comment-17539191 ] yanjing.wang commented on CALCITE-5089: --- Thanks [~julianhyde]  , I made some chan

[jira] [Commented] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539190#comment-17539190 ] Chunwei Lei commented on CALCITE-5073: -- I am +1 for this positive change. I will f

[jira] [Updated] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5157: Labels: pull-request-available (was: ) > ClassCastException in checkRollUp with DOT oper

[jira] [Comment Edited] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539174#comment-17539174 ] Chunwei Lei edited comment on CALCITE-5157 at 5/19/22 2:51 AM: --

[jira] [Comment Edited] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539174#comment-17539174 ] Chunwei Lei edited comment on CALCITE-5157 at 5/19/22 2:49 AM: --

[jira] [Comment Edited] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539174#comment-17539174 ] Chunwei Lei edited comment on CALCITE-5157 at 5/19/22 2:49 AM: --

[jira] [Commented] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539174#comment-17539174 ] Chunwei Lei commented on CALCITE-5157: -- I did some investigation on this. It seems

[jira] [Comment Edited] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539168#comment-17539168 ] Chunwei Lei edited comment on CALCITE-5157 at 5/19/22 2:34 AM: --

[jira] [Commented] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539168#comment-17539168 ] Chunwei Lei commented on CALCITE-5157: -- FYI: I tried the following SQL in PostgreS

[jira] [Commented] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-18 Thread Mitsunori Komatsu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539162#comment-17539162 ] Mitsunori Komatsu commented on CALCITE-5135: Just noticed I can parse `day`

[jira] [Commented] (CALCITE-1739) backend jdbc connection does not returned to connection pool after execute a query.

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539161#comment-17539161 ] itxiangkui commented on CALCITE-1739: - [~jingwuli]   Let's take a look at the CALCI

[jira] [Updated] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-3890: - Fix Version/s: 1.31.0 > Derive IS NOT NULL filter for the inputs of inner join > -

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539117#comment-17539117 ] Jonathan Swenson commented on CALCITE-2040: --- It appears as though the first i

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539074#comment-17539074 ] Jonathan Swenson commented on CALCITE-2040: --- Building arrow-gandiva from sour

[jira] [Comment Edited] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538980#comment-17538980 ] Yingyu Wang edited comment on CALCITE-5145 at 5/18/22 6:02 PM: --

[jira] [Comment Edited] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538980#comment-17538980 ] Yingyu Wang edited comment on CALCITE-5145 at 5/18/22 6:00 PM: --

[jira] [Comment Edited] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538980#comment-17538980 ] Yingyu Wang edited comment on CALCITE-5145 at 5/18/22 6:00 PM: --

[jira] [Comment Edited] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538626#comment-17538626 ] Jonathan Swenson edited comment on CALCITE-2040 at 5/18/22 5:46 PM: -

[jira] [Commented] (CALCITE-5145) Alias of CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538980#comment-17538980 ] Yingyu Wang commented on CALCITE-5145: -- Actually the type mismatch exception occur

[jira] [Updated] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Summary: CASE statement within GROUPING SETS throws type mis-match exception (was: Alias of CA

[jira] [Updated] (CALCITE-5145) Alias of CASE statement within GROUPING SETS throws type mis-match exception

2022-05-18 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Summary: Alias of CASE statement within GROUPING SETS throws type mis-match exception (was: As

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-05-18 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538840#comment-17538840 ] Benchao Li commented on CALCITE-5118: - Hi guys, do you have any suggestions about m

[jira] [Updated] (CALCITE-5099) ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Description: We have extended JdbcSchema and JdbcCatalogSchema in order to connect to the back-e

[jira] [Updated] (CALCITE-5099) ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Component/s: avatica > ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connecti

[jira] [Commented] (CALCITE-5099) ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538759#comment-17538759 ] itxiangkui commented on CALCITE-5099: - Hi, [~julianhyde]    > ResultSetEnumerable.

[jira] [Commented] (CALCITE-5099) ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538758#comment-17538758 ] itxiangkui commented on CALCITE-5099: - I think I have sorted out the conditions and

[jira] [Comment Edited] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538687#comment-17538687 ] Ruben Q L edited comment on CALCITE-5073 at 5/18/22 9:34 AM:

[jira] [Comment Edited] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538687#comment-17538687 ] Ruben Q L edited comment on CALCITE-5073 at 5/18/22 9:34 AM:

[jira] [Commented] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538687#comment-17538687 ] Ruben Q L commented on CALCITE-5073: Sorry, I will be a bit busy this and next week

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538682#comment-17538682 ] Ruben Q L commented on CALCITE-5051: [~gramana], I have just merged CALCITE-5061 in

[jira] [Resolved] (CALCITE-5061) Improve recursive application of the field trimming

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5061. Resolution: Fixed Fixed via https://github.com/apache/calcite/commit/dc2e1af5c168f01a045edc3fb3f

[jira] [Resolved] (CALCITE-5158) count(1) with subquery count(distinct) gives wrong results with hive.optimize.distinct.rewrite=true and cbo on

2022-05-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5158. --- Resolution: Invalid > count(1) with subquery count(distinct) gives wrong re

[jira] [Commented] (CALCITE-5158) count(1) with subquery count(distinct) gives wrong results with hive.optimize.distinct.rewrite=true and cbo on

2022-05-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538660#comment-17538660 ] Alessandro Solimando commented on CALCITE-5158: --- [~honghui], this seems a

[jira] [Comment Edited] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538626#comment-17538626 ] Jonathan Swenson edited comment on CALCITE-2040 at 5/18/22 7:28 AM: -

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538626#comment-17538626 ] Jonathan Swenson commented on CALCITE-2040: --- For reference the linker error I

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2022-05-18 Thread Jonathan Swenson (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538624#comment-17538624 ] Jonathan Swenson commented on CALCITE-2040: --- [~julianhyde] it appears as thou