[jira] [Commented] (CALCITE-2703) Reduce code generation and class loading overhead when executing queries in the EnumerableConvention

2018-12-13 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16720050#comment-16720050 ] Lai Zhou commented on CALCITE-2703: --- [~zabetak], in fact, we use calcite to execute a lot of  'hive

[jira] [Commented] (CALCITE-2703) Reduce code generation and class loading overhead when executing queries in the EnumerableConvention

2018-12-13 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16719993#comment-16719993 ] Lai Zhou commented on CALCITE-2703: --- [~julianhyde] [~zabetak] I use calcite(1.17.0) for real-time

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

2018-12-20 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16726393#comment-16726393 ] Lai Zhou edited comment on CALCITE-2741 at 12/21/18 4:07 AM: - It will take

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

2018-12-20 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16726393#comment-16726393 ] Lai Zhou commented on CALCITE-2741: --- It will take some time to merge my modifications based on

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

2018-12-16 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16722744#comment-16722744 ] Lai Zhou edited comment on CALCITE-2741 at 12/17/18 7:31 AM: -

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

2018-12-16 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16722744#comment-16722744 ] Lai Zhou commented on CALCITE-2741: --- [~julianhyde], I have seen what you did for Oracle functions .

[jira] [Updated] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Description: [~julianhyde], I extended the native enummerable implemention of calcite to support

[jira] [Created] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2741: - Summary: extend the native enummerable implemention of calcite to support Hive SQL Key: CALCITE-2741 URL: https://issues.apache.org/jira/browse/CALCITE-2741 Project:

[jira] [Updated] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Description: [~julianhyde], I extended the native enummerable implemention of calcite to support

[jira] [Commented] (CALCITE-1581) UDTF like in hive

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16721037#comment-16721037 ] Lai Zhou commented on CALCITE-1581: --- [~julianhyde] , I extended the native  enummerable implemention

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

2018-12-16 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Summary: Add operator table with Hive-specific built-in functions (was: extend the native

[jira] [Commented] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16722016#comment-16722016 ] Lai Zhou commented on CALCITE-2741: --- [~zabetak] , considering that: someone wants to implement his

[jira] [Comment Edited] (CALCITE-2741) extend the native enumerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16722016#comment-16722016 ] Lai Zhou edited comment on CALCITE-2741 at 12/15/18 5:13 AM: - [~zabetak] ,

[jira] [Updated] (CALCITE-2741) extend the native enumerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Summary: extend the native enumerable implemention of calcite to support Hive SQL (was: extend

[jira] [Commented] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16721564#comment-16721564 ] Lai Zhou commented on CALCITE-2741: --- we make some  extension of the cacite-core,include: 1.add a new

[jira] [Comment Edited] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16721564#comment-16721564 ] Lai Zhou edited comment on CALCITE-2741 at 12/14/18 4:12 PM: - we make some 

[jira] [Updated] (CALCITE-2741) extend the native enummerable implemention of calcite to support Hive SQL

2018-12-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Attachment: 屏幕快照 2018-12-14 23.10.17.png > extend the native enummerable implemention of calcite to

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

2019-01-07 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16736820#comment-16736820 ] Lai Zhou edited comment on CALCITE-2741 at 1/8/19 7:17 AM: --- [~julianhyde], I

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

2019-01-07 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16736820#comment-16736820 ] Lai Zhou edited comment on CALCITE-2741 at 1/8/19 7:20 AM: --- [~julianhyde], I

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

2019-01-07 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16736820#comment-16736820 ] Lai Zhou commented on CALCITE-2741: --- [~julianhyde], I there a right way to add local fileld

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

2019-01-09 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16738061#comment-16738061 ] Lai Zhou edited comment on CALCITE-2741 at 1/9/19 10:10 AM:

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

2019-01-09 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16738061#comment-16738061 ] Lai Zhou commented on CALCITE-2741: --- hi,[~zabetak],can you please give a right intellij-code-style

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

2019-01-09 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Attachment: 屏幕快照 2019-01-09 16.49.34.png > Add operator table with Hive-specific built-in functions

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

2019-01-14 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Comment: was deleted (was: [~zabetak], after  applying the right settings and reformatting the code

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

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Description: Now the EnumerableMergeJoinRule only supports an inner and equi join. If users make a

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

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou commented on CALCITE-2973: --- [~julianhyde] , consider another query that the join conditions

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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:24 AM: --- [~julianhyde] ,

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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:24 AM: --- [~julianhyde] ,

[jira] [Commented] (CALCITE-2592) EnumerableMergeJoin is never taken

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807371#comment-16807371 ] Lai Zhou commented on CALCITE-2592: --- [~hyuan] , I create a new issue about join rules for a  theta

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

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Priority: Minor (was: Major) > Make EnumerableMergeJoinRule to support a theta join >

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] ,

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] ,

[jira] [Updated] (CALCITE-2973) make EnumerableMergeJoinRule to support a theta join

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Description: Now the EnumerableMergeJoinRule only supports an inner and equi join. If users make a

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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:22 AM: --- [~julianhyde] ,

[jira] [Created] (CALCITE-2973) make EnumerableMergeJoinRule to support a theta join

2019-04-01 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2973: - Summary: make EnumerableMergeJoinRule to support a theta join Key: CALCITE-2973 URL: https://issues.apache.org/jira/browse/CALCITE-2973 Project: Calcite Issue

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

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Description: Now the EnumerableMergeJoinRule only supports an inner and equi join. If users make a

[jira] [Comment Edited] (CALCITE-2592) EnumerableMergeJoin is never taken

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807371#comment-16807371 ] Lai Zhou edited comment on CALCITE-2592 at 4/2/19 2:45 AM: --- [~hyuan] , I

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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] [Updated] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

2019-04-02 Thread Lai Zhou (JIRA)
[ 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) Allow theta joins to be executed using a merge join algorithm

2019-04-02 Thread Lai Zhou (JIRA)
[ 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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] [Updated] (CALCITE-2973) Allow theta joins that has equi keys to be executed using a merge join or hash join algorithm

2019-04-02 Thread Lai Zhou (JIRA)
[ 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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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

2019-04-02 Thread Lai Zhou (JIRA)
[ 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] [Updated] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

2019-03-21 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2940: -- Description: CalcitePrepareImpl 's method {code:java} private ParseResult parse_(Context context,

[jira] [Created] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

2019-03-21 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2940: - Summary: CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig Key: CALCITE-2940 URL: https://issues.apache.org/jira/browse/CALCITE-2940

[jira] [Closed] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

2019-03-21 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou closed CALCITE-2940. - Resolution: Duplicate > CalcitePrepareImpl always creates a default SqlParser without user's >

[jira] [Commented] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

2019-03-24 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800095#comment-16800095 ] Lai Zhou commented on CALCITE-2940: --- Duplicate of [

[jira] [Commented] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

2019-03-21 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798023#comment-16798023 ] Lai Zhou commented on CALCITE-2208: --- [~julianhyde], I make a pr for this issue,the changes: 1.

[jira] [Comment Edited] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

2019-03-21 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798023#comment-16798023 ] Lai Zhou edited comment on CALCITE-2208 at 3/21/19 11:59 AM: -  I make a pr

[jira] [Commented] (CALCITE-2592) EnumerableMergeJoin is never taken

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807343#comment-16807343 ] Lai Zhou commented on CALCITE-2592: --- [~hyuan] , I enable the  useAbstractConvertersForConversion  of

[jira] [Commented] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-28 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804563#comment-16804563 ] Lai Zhou commented on CALCITE-2960: --- It's my code. {code:java} protected FrameworkConfig

[jira] [Comment Edited] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-28 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804563#comment-16804563 ] Lai Zhou edited comment on CALCITE-2960 at 3/29/19 3:53 AM: It's my code.

[jira] [Comment Edited] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-28 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804519#comment-16804519 ] Lai Zhou edited comment on CALCITE-2960 at 3/29/19 1:57 AM: [~danny0405],

[jira] [Commented] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-28 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804519#comment-16804519 ] Lai Zhou commented on CALCITE-2960: --- [~danny0405], it is really a part of issue 2928.  In my case ,I

[jira] [Comment Edited] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-28 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804519#comment-16804519 ] Lai Zhou edited comment on CALCITE-2960 at 3/29/19 1:59 AM: [~danny0405],

[jira] [Created] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-27 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2960: - Summary: CalciteCatalogReader use a hard-coding config to get functions Key: CALCITE-2960 URL: https://issues.apache.org/jira/browse/CALCITE-2960 Project: Calcite

[jira] [Updated] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

2019-03-27 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2960: -- Labels: pull-request-available (was: ) > CalciteCatalogReader use a hard-coding config to get

[jira] [Commented] (CALCITE-2592) EnumerableMergeJoin is never taken

2019-04-01 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806523#comment-16806523 ] Lai Zhou commented on CALCITE-2592: ---   [~vladimirsitnikov],[~zhztheplayer],[~hyuan] It produces a

[jira] [Comment Edited] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-26 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16776491#comment-16776491 ] Lai Zhou edited comment on CALCITE-2854 at 2/27/19 2:23 AM: I think Unary

[jira] [Comment Edited] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-26 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16778798#comment-16778798 ] Lai Zhou edited comment on CALCITE-2854 at 2/27/19 2:24 AM: [~zhztheplayer]

[jira] [Commented] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-26 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16778851#comment-16778851 ] Lai Zhou commented on CALCITE-2854: --- yes,We can still keep the UNARY_PLUS call in RelNode ,  let the

[jira] [Commented] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-24 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16776491#comment-16776491 ] Lai Zhou commented on CALCITE-2854: --- I think Unary "+" has no effect on Decimal type.  This patch is

[jira] [Comment Edited] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-24 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16776491#comment-16776491 ] Lai Zhou edited comment on CALCITE-2854 at 2/25/19 2:38 AM: I think Unary

[jira] [Created] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2907: - Summary: AggregateExpandDistinctAggregatesRule produces a wrong relational algebra Key: CALCITE-2907 URL: https://issues.apache.org/jira/browse/CALCITE-2907 Project:

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggegate which contains distinct call was converted improperly to an

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to 

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to 

[jira] [Commented] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789363#comment-16789363 ] Lai Zhou commented on CALCITE-2907: --- [~danny0405] but this sql query would work, and the final

[jira] [Updated] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2907: -- Description: In my usecase: an Aggregate which contains distinct call was converted improperly to

[jira] [Closed] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou closed CALCITE-2907. - Resolution: Invalid > AggregateExpandDistinctAggregatesRule produces a wrong relational algebra >

[jira] [Comment Edited] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789449#comment-16789449 ] Lai Zhou edited comment on CALCITE-2907 at 3/11/19 11:43 AM: - [~danny0405]

[jira] [Commented] (CALCITE-2907) AggregateExpandDistinctAggregatesRule produces a wrong relational algebra

2019-03-11 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789449#comment-16789449 ] Lai Zhou commented on CALCITE-2907: --- [~danny0405] I found this issure was caused by my customed 

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

2019-03-22 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Attachment: (was: 屏幕快照 2019-01-09 16.49.34.png) > Add operator table with Hive-specific built-in

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

2019-03-22 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2741: -- Description: [~julianhyde], I write a hive adapter for calcite to support Hive sql ,includes

[jira] [Updated] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-18 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2854: -- Description: case: {code:java} @Test public void test() throws Exception { final String cr =

[jira] [Created] (CALCITE-2854) code gen error for UNARY_MINUS operator call with decimal type operands

2019-02-18 Thread Lai Zhou (JIRA)
Lai Zhou created CALCITE-2854: - Summary: code gen error for UNARY_MINUS operator call with decimal type operands Key: CALCITE-2854 URL: https://issues.apache.org/jira/browse/CALCITE-2854 Project: Calcite

[jira] [Commented] (CALCITE-2703) Reduce code generation and class loading overhead when executing queries in the EnumerableConvention

2019-02-12 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16766897#comment-16766897 ] Lai Zhou commented on CALCITE-2703: --- [~julianhyde], I think this cache will be shared by different

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

2019-04-11 Thread Lai Zhou (JIRA)
[ 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

2019-04-11 Thread Lai Zhou (JIRA)
[ 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 have equi conditions to be executed using a hash join algorithm

2019-04-11 Thread Lai Zhou (JIRA)
[ 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] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-04-11 Thread Lai Zhou (JIRA)
[ 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] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-04-11 Thread Lai Zhou (JIRA)
[ 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] [Created] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

2019-04-12 Thread Lai Zhou (JIRA)
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] [Updated] (CALCITE-2992) Enhance implicit conversions for different sql type family

2019-04-15 Thread Lai Zhou (JIRA)
[ 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] [Commented] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

2019-04-16 Thread Lai Zhou (JIRA)
[ 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] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-04-17 Thread Lai Zhou (JIRA)
[ 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

2019-04-17 Thread Lai Zhou (JIRA)
[ 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] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-04-17 Thread Lai Zhou (JIRA)
[ 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-2282) Allow OperatorTable to be pluggable in the parser

2019-04-18 Thread Lai Zhou (JIRA)
[ 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] [Comment Edited] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

2019-04-18 Thread Lai Zhou (JIRA)
[ 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

2019-04-18 Thread Lai Zhou (JIRA)
[ 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] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-04-18 Thread Lai Zhou (JIRA)
[ 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

2019-04-18 Thread Lai Zhou (JIRA)
[ 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-2282) Allow OperatorTable to be pluggable in the parser

2019-04-18 Thread Lai Zhou (JIRA)
[ 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] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

2019-04-16 Thread Lai Zhou (JIRA)
[ 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

  1   2   >