[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840108#comment-16840108 ] Jiatao Tao commented on CALCITE-3065: - Hi [~danny0405] Here I briefly describe how

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839965#comment-16839965 ] Lai Zhou edited comment on CALCITE-2973 at 5/15/19 7:26 AM:

[jira] [Commented] (CALCITE-2624) Add a rule to copy a sort below a join operator

[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840126#comment-16840126 ] Ruben Quesada Lopez commented on CALCITE-2624: -- Thanks for your comment, [

[jira] [Comment Edited] (CALCITE-2624) Add a rule to copy a sort below a join operator

[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840126#comment-16840126 ] Ruben Quesada Lopez edited comment on CALCITE-2624 at 5/15/19 7:41 AM: --

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840140#comment-16840140 ] Ruben Quesada Lopez edited comment on CALCITE-2973 at 5/15/19 7:59 AM: --

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840140#comment-16840140 ] Ruben Quesada Lopez commented on CALCITE-2973: -- The problem seems to be in

[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840142#comment-16840142 ] Danny Chan commented on CALCITE-3065: - Firstly Calcite did set the numeric SqlLiter

[jira] [Commented] (CALCITE-3050) Integrate SqlDialect and SqlParser.Config

[ https://issues.apache.org/jira/browse/CALCITE-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840147#comment-16840147 ] Danny Chan commented on CALCITE-3050: - Thx [~julianhyde] and  [~Chunwei Lei], this

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840190#comment-16840190 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql],thanks , I understand it. When creat

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840194#comment-16840194 ] Ruben Quesada Lopez commented on CALCITE-2973: -- Digging into my previous c

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840194#comment-16840194 ] Ruben Quesada Lopez edited comment on CALCITE-2973 at 5/15/19 9:01 AM: --

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840194#comment-16840194 ] Ruben Quesada Lopez edited comment on CALCITE-2973 at 5/15/19 9:02 AM: --

[jira] [Updated] (CALCITE-3068) testSubprogram() does't test whether subprogram gets re-executed

[ https://issues.apache.org/jira/browse/CALCITE-3068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3068: Labels: pull-request-available (was: ) > testSubprogram() does't test whether subprogram

[jira] [Commented] (CALCITE-3068) testSubprogram() does't test whether subprogram gets re-executed

[ https://issues.apache.org/jira/browse/CALCITE-3068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840222#comment-16840222 ] Chunwei Lei commented on CALCITE-3068: -- I opened a PR: [https://github.com/apache/

[jira] [Created] (CALCITE-3068) testSubprogram() does't test whether subprogram gets re-executed

Chunwei Lei created CALCITE-3068: Summary: testSubprogram() does't test whether subprogram gets re-executed Key: CALCITE-3068 URL: https://issues.apache.org/jira/browse/CALCITE-3068 Project: Calcite

[jira] [Commented] (CALCITE-3052) Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840233#comment-16840233 ] Anton Haidai commented on CALCITE-3052: --- [~jcamachorodriguez], after this additio

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840251#comment-16840251 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql] , good analysis. I tested this soluti

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840269#comment-16840269 ] Ruben Quesada Lopez commented on CALCITE-2973: -- [~hhlai1990], I was just r

[jira] [Commented] (CALCITE-3050) Integrate SqlDialect and SqlParser.Config

[ https://issues.apache.org/jira/browse/CALCITE-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840276#comment-16840276 ] Chunwei Lei commented on CALCITE-3050: -- [~julianhyde], the PR looks good and I lef

[jira] [Comment Edited] (CALCITE-3050) Integrate SqlDialect and SqlParser.Config

[ https://issues.apache.org/jira/browse/CALCITE-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840276#comment-16840276 ] Chunwei Lei edited comment on CALCITE-3050 at 5/15/19 10:20 AM: -

[jira] [Created] (CALCITE-3069) Make the JDBC Connection more extensible like the FrameworkConfig API

Lai Zhou created CALCITE-3069: - Summary: Make the JDBC Connection more extensible like the FrameworkConfig API Key: CALCITE-3069 URL: https://issues.apache.org/jira/browse/CALCITE-3069 Project: Calcite

[jira] [Updated] (CALCITE-3069) Make the JDBC Connection more extensible like the FrameworkConfig API

[ https://issues.apache.org/jira/browse/CALCITE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3069: -- Description: More and more users are interested in building custom sql engines on top of Calcite. B

[jira] [Commented] (CALCITE-2601) Support REVERSE(str) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840285#comment-16840285 ] pingle wang commented on CALCITE-2601: -- thank, I get this. > Support REVERSE(str)

[jira] [Commented] (CALCITE-2601) Support REVERSE(str) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840289#comment-16840289 ] pingle wang commented on CALCITE-2601: -- sorry, I can't  modify JIRA case title to

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840269#comment-16840269 ] Ruben Quesada Lopez edited comment on CALCITE-2973 at 5/15/19 11:50 AM: -

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840269#comment-16840269 ] Ruben Quesada Lopez edited comment on CALCITE-2973 at 5/15/19 12:05 PM: -

[jira] [Resolved] (CALCITE-3026) Release Avatica-Go 4.0.0

[ https://issues.apache.org/jira/browse/CALCITE-3026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-3026. - Resolution: Fixed > Release Avatica-Go 4.0.0 > > >

[jira] [Commented] (CALCITE-2979) Add a block-based nested loop join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840343#comment-16840343 ] Danny Chan commented on CALCITE-2979: - It kind of have same thoughts as [~rubenql],

[jira] [Commented] (CALCITE-3069) Make the JDBC Connection more extensible like the FrameworkConfig API

[ https://issues.apache.org/jira/browse/CALCITE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840357#comment-16840357 ] Hongze Zhang commented on CALCITE-3069: --- I happened to have a ongoing work on the

[jira] [Comment Edited] (CALCITE-3069) Make the JDBC Connection more extensible like the FrameworkConfig API

[ https://issues.apache.org/jira/browse/CALCITE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840357#comment-16840357 ] Hongze Zhang edited comment on CALCITE-3069 at 5/15/19 12:51 PM:

[jira] [Updated] (CALCITE-2601) Add REVERSE function

[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2601: - Summary: Add REVERSE function (was: Support REVERSE(str) in SqlFunctions) > Add REVERSE functi

[jira] [Comment Edited] (CALCITE-3069) Make the JDBC Connection more extensible like the FrameworkConfig API

[ https://issues.apache.org/jira/browse/CALCITE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840357#comment-16840357 ] Hongze Zhang edited comment on CALCITE-3069 at 5/15/19 12:52 PM:

[jira] [Commented] (CALCITE-2601) Add REVERSE function

[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840372#comment-16840372 ] Chunwei Lei commented on CALCITE-2601: -- I have changed the title to "Add REVERSE f

[jira] [Commented] (CALCITE-2666) JoinPushThroughJoinRule can't reach an optimal plan in some 3+ joins cases

[ https://issues.apache.org/jira/browse/CALCITE-2666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840489#comment-16840489 ] Stamatis Zampetakis commented on CALCITE-2666: -- Hi [~anha], I didn't go th

[jira] [Commented] (CALCITE-2666) JoinPushThroughJoinRule can't reach an optimal plan in some 3+ joins cases

[ https://issues.apache.org/jira/browse/CALCITE-2666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840506#comment-16840506 ] Anton Haidai commented on CALCITE-2666: --- [~zabetak]: JoinProjectTransposeRule was

[jira] [Closed] (CALCITE-2666) JoinPushThroughJoinRule can't reach an optimal plan in some 3+ joins cases

[ https://issues.apache.org/jira/browse/CALCITE-2666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anton Haidai closed CALCITE-2666. - Resolution: Not A Problem > JoinPushThroughJoinRule can't reach an optimal plan in some 3+ join

[jira] [Resolved] (CALCITE-3028) Support FULL OUTER JOIN with AggregateJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3028. Resolution: Fixed Fix Version/s: 1.20.0 Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-3052) Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840610#comment-16840610 ] Jesus Camacho Rodriguez commented on CALCITE-3052: -- Thanks [~anha] for

[jira] [Resolved] (CALCITE-3066) RelToSqlConverter may incorrectly throw an AssertionError for some decimal literals

[ https://issues.apache.org/jira/browse/CALCITE-3066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-3066. -- Resolution: Fixed Fix Version/s: 1.20.0 Fixed in [d6896202c86

[jira] [Resolved] (CALCITE-3052) Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-3052. -- Resolution: Fixed Fix Version/s: 1.20.0 Fixed in [046bb81a9a4

[jira] [Created] (CALCITE-3070) Inner join between MySQL tables produce wrong results if join order changed

Zhibin Zhou created CALCITE-3070: Summary: Inner join between MySQL tables produce wrong results if join order changed Key: CALCITE-3070 URL: https://issues.apache.org/jira/browse/CALCITE-3070 Project

[jira] [Commented] (CALCITE-3070) Inner join between MySQL tables produce wrong results if join order changed

[ https://issues.apache.org/jira/browse/CALCITE-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840678#comment-16840678 ] Zhibin Zhou commented on CALCITE-3070: -- The bug seems to be related to the timesta

[jira] [Commented] (CALCITE-2624) Add a rule to copy a sort below a join operator

[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840696#comment-16840696 ] Haisheng Yuan commented on CALCITE-2624: Thanks for the explanation, [~rubenql]

[jira] [Comment Edited] (CALCITE-2624) Add a rule to copy a sort below a join operator

[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840696#comment-16840696 ] Haisheng Yuan edited comment on CALCITE-2624 at 5/15/19 7:39 PM:

[jira] [Commented] (CALCITE-2913) Adapter for Apache Kafka

[ https://issues.apache.org/jira/browse/CALCITE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840926#comment-16840926 ] Matt Wang commented on CALCITE-2913: [~mingmxu] Whether it is necessary to support

[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840933#comment-16840933 ] Jiatao Tao commented on CALCITE-3065: - [~danny0405] Thanks, it answers my doubts.

[jira] [Comment Edited] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840933#comment-16840933 ] Jiatao Tao edited comment on CALCITE-3065 at 5/16/19 2:39 AM: ---

[jira] [Resolved] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-2282. - Resolution: Fixed Fix Version/s: 1.20.0 Fixed in  [https://github.com/apache/calcite/com

[jira] [Created] (CALCITE-3071) Cache the whole sql plan to reduce the latency and improve the performance

Lai Zhou created CALCITE-3071: - Summary: Cache the whole sql plan to reduce the latency and improve the performance Key: CALCITE-3071 URL: https://issues.apache.org/jira/browse/CALCITE-3071 Project: Calci

[jira] [Updated] (CALCITE-3071) Cache the whole sql plan to reduce the latency and improve the performance

[ https://issues.apache.org/jira/browse/CALCITE-3071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3071: -- Description: In real business, when sql queries become complex,  the overhead of sql plan will incre

[jira] [Created] (CALCITE-3072) Generate right SQL for FLOOR&SUBSTRING functions in SparkSqlDialect

Feng Zhu created CALCITE-3072: - Summary: Generate right SQL for FLOOR&SUBSTRING functions in SparkSqlDialect Key: CALCITE-3072 URL: https://issues.apache.org/jira/browse/CALCITE-3072 Project: Calcite

[jira] [Updated] (CALCITE-3072) Generate right SQL for FLOOR&SUBSTRING functions in SparkSqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3072: Labels: pull-request-available (was: ) > Generate right SQL for FLOOR&SUBSTRING function

[jira] [Commented] (CALCITE-3072) Generate right SQL for FLOOR&SUBSTRING functions in SparkSqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16841007#comment-16841007 ] Feng Zhu commented on CALCITE-3072: --- I opened a PR(https://github.com/apache/calcite/