[jira] [Commented] (CALCITE-4786) Facilitate use of graalvm native-image compilation

[ https://issues.apache.org/jira/browse/CALCITE-4786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452786#comment-17452786 ] Lai Zhou commented on CALCITE-4786: --- Sounds like an exciting project. (y)     > Facilitate use of

[jira] [Closed] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou closed CALCITE-2741. - Resolution: Not A Problem > Add operator table with Hive-specific built-in functions >

[jira] [Closed] (CALCITE-2992) Enhance implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou closed CALCITE-2992. - Resolution: Fixed > Enhance implicit conversions when generating hash join keys for an >

[jira] [Created] (CALCITE-4161) MergeJoin algorithm should not assume inputs sorted in ascending order

Lai Zhou created CALCITE-4161: - Summary: MergeJoin algorithm should not assume inputs sorted in ascending order Key: CALCITE-4161 URL: https://issues.apache.org/jira/browse/CALCITE-4161 Project: Calcite

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915562#comment-16915562 ] Lai Zhou commented on CALCITE-3284: --- yes, you're right. I have pushed a new commit, which resolved

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915531#comment-16915531 ] Lai Zhou commented on CALCITE-3284: --- [~rubenql], Since Calcite can't support `semi join` or `anti

[jira] [Issue Comment Deleted] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3284: -- Comment: was deleted (was: [~rubenql]， Did Calcite already support semi join/anti join keywords? I

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915526#comment-16915526 ] Lai Zhou commented on CALCITE-3284: --- [~rubenql]， Did Calcite already support semi join/anti join

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16914082#comment-16914082 ] Lai Zhou commented on CALCITE-3284: --- I'll resolve this issue in this PR.

[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=16913882#comment-16913882 ] Lai Zhou commented on CALCITE-2973: --- I noticed this performance issue before. I'll try to find a

[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=16912868#comment-16912868 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql]， [~hyuan] ,[~julianhyde], [~danny0405], the pr is

[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=16852674#comment-16852674 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql],[~michaelmior], now the patch is good enough to be

[jira] [Commented] (CALCITE-2992) Enhance implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16852603#comment-16852603 ] Lai Zhou commented on CALCITE-2992: --- May be we can make the CAST translation to include this

[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

[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:

[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.

[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] [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=16840251#comment-16840251 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql] , good analysis. I tested this solution, but there're

[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=16840190#comment-16840190 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql],thanks , I understand it. When creating a SemiJoin

[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=16839965#comment-16839965 ] Lai Zhou edited comment on CALCITE-2973 at 5/15/19 7:26 AM: [~rubenql], now 

[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=16839965#comment-16839965 ] Lai Zhou edited comment on CALCITE-2973 at 5/15/19 3:35 AM: [~rubenql], now 

[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=16839965#comment-16839965 ] Lai Zhou edited comment on CALCITE-2973 at 5/15/19 3:13 AM: [~rubenql], now 

[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=16839965#comment-16839965 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql], now the inner join with a remainCondtion won't be

[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=16838611#comment-16838611 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql], I agree with you. It's a good idea to using

[jira] [Commented] (CALCITE-2173) Sample implementation of ArrowAdapter

[ https://issues.apache.org/jira/browse/CALCITE-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16838403#comment-16838403 ] Lai Zhou commented on CALCITE-2173: --- [~masayuki038], I'll take some time to review your code, I'm 

[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=16838246#comment-16838246 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak], the query as you said, {code:java} SELECT e.name

[jira] [Commented] (CALCITE-2173) Sample implementation of ArrowAdapter

[ https://issues.apache.org/jira/browse/CALCITE-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836862#comment-16836862 ] Lai Zhou commented on CALCITE-2173: --- [~masayuki038], I know what you mean. This Arrow adapter is just

[jira] [Commented] (CALCITE-2173) Sample implementation of ArrowAdapter

[ https://issues.apache.org/jira/browse/CALCITE-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836434#comment-16836434 ] Lai Zhou commented on CALCITE-2173: --- [~masayuki038] ,are you still work on this? What's your recent

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

[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836422#comment-16836422 ] Lai Zhou commented on CALCITE-2040: --- [~masayuki038] Great job. I add a relation link to 

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

[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836162#comment-16836162 ] Lai Zhou edited comment on CALCITE-2040 at 5/9/19 7:40 AM: --- I think it may

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

[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836162#comment-16836162 ] Lai Zhou edited comment on CALCITE-2040 at 5/9/19 7:35 AM: --- I think it may

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

[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836162#comment-16836162 ] Lai Zhou commented on CALCITE-2040: --- I think it may improve a lot of performance  if we have Arrow as

[jira] [Comment Edited] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16833649#comment-16833649 ] Lai Zhou edited comment on CALCITE-2741 at 5/6/19 9:49 AM: --- [~zabetak]，I also

[jira] [Comment Edited] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16833649#comment-16833649 ] Lai Zhou edited comment on CALCITE-2741 at 5/6/19 9:36 AM: --- [~zabetak]，I also

[jira] [Commented] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16833649#comment-16833649 ] Lai Zhou commented on CALCITE-2741: --- [~zabetak]，I also think it was not exactly an adapter. My

[jira] [Updated] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Affects Version/s: 1.19.0 Description: I write a hive adapter for calcite to support Hive

[jira] [Comment Edited] (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:comment-tabpanel=16830001#comment-16830001 ] Lai Zhou edited comment on CALCITE-2282 at 5/1/19 2:01 AM: --- [~zhztheplayer]

[jira] [Comment Edited] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16830061#comment-16830061 ] Lai Zhou edited comment on CALCITE-2741 at 4/30/19 9:40 AM:

[jira] [Commented] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16830061#comment-16830061 ] Lai Zhou commented on CALCITE-2741: --- hi,[~julianhyde] , [~zabetak],[~zhztheplayer],

[jira] [Comment Edited] (CALCITE-2741) Add operator table with Hive-specific built-in functions

[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16830061#comment-16830061 ] Lai Zhou edited comment on CALCITE-2741 at 4/30/19 8:30 AM:

[jira] [Comment Edited] (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:comment-tabpanel=16830001#comment-16830001 ] Lai Zhou edited comment on CALCITE-2282 at 4/30/19 6:52 AM: [~zhztheplayer]

[jira] [Commented] (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:comment-tabpanel=16830001#comment-16830001 ] Lai Zhou commented on CALCITE-2282: --- [~zhztheplayer] ,thanks, you're right. " That said, you can put

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:30 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:31 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:30 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:21 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:18 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:01 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:00 AM:

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 7:00 AM:

[jira] [Commented] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou commented on CALCITE-3014: --- [~zabetak],[~julianhyde] Is there already an example query that

[jira] [Comment Edited] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827840#comment-16827840 ] Lai Zhou edited comment on CALCITE-3014 at 4/28/19 6:42 AM:

[jira] [Updated] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3014: -- Description: I found SqlConformanceEnum is hard coded in a few places.

[jira] [Commented] (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:comment-tabpanel=16825923#comment-16825923 ] Lai Zhou commented on CALCITE-2282: --- [~zhztheplayer], It likes what I commented before, {code:java}

[jira] [Comment Edited] (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:comment-tabpanel=16825653#comment-16825653 ] Lai Zhou edited comment on CALCITE-2282 at 4/25/19 2:35 AM: [~danny0405]，

[jira] [Comment Edited] (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:comment-tabpanel=16825653#comment-16825653 ] Lai Zhou edited comment on CALCITE-2282 at 4/25/19 2:35 AM: [~danny0405]，

[jira] [Comment Edited] (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:comment-tabpanel=16825653#comment-16825653 ] Lai Zhou edited comment on CALCITE-2282 at 4/25/19 2:33 AM: [~danny0405]，

[jira] [Commented] (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:comment-tabpanel=16825653#comment-16825653 ] Lai Zhou commented on CALCITE-2282: --- [~danny0405]， it's the way how I override the built-in

[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=16823659#comment-16823659 ] Lai Zhou commented on CALCITE-2973: --- I modified EnumerableJoin to be able to deal with non-equi join

[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=16823090#comment-16823090 ] Lai Zhou edited comment on CALCITE-2973 at 4/23/19 2:16 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=16823090#comment-16823090 ] Lai Zhou edited comment on CALCITE-2973 at 4/22/19 2:18 PM:

[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=16823090#comment-16823090 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak],[~hyuan], should we keep EnumerableJoin  as an

[jira] [Updated] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3014: -- Description: [~julianhyde]  I found SqlConformanceEnum is hard coded in a few places.

[jira] [Created] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

Lai Zhou created CALCITE-3014: - Summary: SqlConformanceEnum is hard coded in a few places Key: CALCITE-3014 URL: https://issues.apache.org/jira/browse/CALCITE-3014 Project: Calcite Issue Type:

[jira] [Comment Edited] (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:comment-tabpanel=16820939#comment-16820939 ] Lai Zhou edited comment on CALCITE-2282 at 4/18/19 10:23 AM: -

[jira] [Comment Edited] (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:comment-tabpanel=16820939#comment-16820939 ] Lai Zhou edited comment on CALCITE-2282 at 4/18/19 10:22 AM: -

[jira] [Comment Edited] (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:comment-tabpanel=16820939#comment-16820939 ] Lai Zhou edited comment on CALCITE-2282 at 4/18/19 10:19 AM: -

[jira] [Commented] (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:comment-tabpanel=16820939#comment-16820939 ] Lai Zhou commented on CALCITE-2282: --- [~julianhyde], I think we should let the validator to resolve

[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=16820902#comment-16820902 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 9:33 AM: [~zabetak], I

[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=16820902#comment-16820902 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak], I can't find a good way to break a theta join into

[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=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:04 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=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:02 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=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:01 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=16819701#comment-16819701 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak], great thanks to your suggestion. I'll  take it into

[jira] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

[ https://issues.apache.org/jira/browse/CALCITE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819698#comment-16819698 ] Lai Zhou commented on CALCITE-1531: --- [~julianhyde], could you reopen this issue , and change the

[jira] [Commented] (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:comment-tabpanel=16818921#comment-16818921 ] Lai Zhou commented on CALCITE-2282: --- +1.[~julianhyde] , is there a good way to solve this ? I use a

[jira] [Updated] (CALCITE-2992) Enhance implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2992: -- Summary: Enhance implicit conversions when generating hash join keys for an equiCondition (was:

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:24 AM: [~julianhyde],

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:24 AM: [~julianhyde],

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM: [~julianhyde],

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM: [~julianhyde],

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM: [~julianhyde],

[jira] [Commented] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818765#comment-16818765 ] Lai Zhou commented on CALCITE-2992: --- [~julianhyde], you're right. I add a test case:

[jira] [Updated] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2992: -- Description: Considering follow sql join:   {code:java} select t1.*,t2.*  from t1 join t2 on

[jira] [Updated] (CALCITE-2992) Enhance implicit conversions for different sql type family

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2992: -- Summary: Enhance implicit conversions for different sql type family (was: Make implicit conversions

[jira] [Created] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

Lai Zhou created CALCITE-2992: - Summary: Make implicit conversions when generating hash join keys for an equiCondition Key: CALCITE-2992 URL: https://issues.apache.org/jira/browse/CALCITE-2992 Project:

[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=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/12/19 4:04 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=16815943#comment-16815943 ] Lai Zhou commented on CALCITE-2973: --- [~julianhyde],[~zabetak],[~hyuan] I make a PR to improve the 

[jira] [Updated] (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:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Summary: Allow theta joins that have equi conditions to be executed using a hash join algorithm

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

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/11/19 10:04 AM: -

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

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/11/19 10:04 AM: -

[jira] [Updated] (CALCITE-2973) Allow theta joins that has equi keys to be executed using a merge join or hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Summary: Allow theta joins that has equi keys to be executed using a merge join or hash join

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:51 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:51 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:46 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:45 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:45 AM: ---

[jira] [Commented] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou commented on CALCITE-2973: --- [~julianhyde],[~zabetak] , good idea. I just create a new rule

[jira] [Updated] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Summary: Allow theta joins to be executed using a merge join algorithm (was: Make

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:28 AM: --- [~julianhyde] ,

  1   2   >