[jira] [Commented] (CALCITE-3537) Can't apply materialized view with a simple filter

2019-11-28 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984751#comment-16984751 ] xzh_dz commented on CALCITE-3537: - ok > Can't apply materialized view with a simple filter >

[jira] [Commented] (CALCITE-3537) Can't apply materialized view with a simple filter

2019-11-28 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984709#comment-16984709 ] Jin Xing commented on CALCITE-3537: --- [~xzh_dz] FYI ~ do you want to take a look at CASE-3 ? > Can't

[jira] [Commented] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-11-28 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984698#comment-16984698 ] Rui Wang commented on CALCITE-3543: --- Thanks for creating this JIRA. [~wangweidong] do you plan to

[jira] [Commented] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier, and for Sybase ASE

2019-11-28 Thread Erin Drummond (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984656#comment-16984656 ] Erin Drummond commented on CALCITE-3344: Apologies if this is the wrong place to post this -

[jira] [Updated] (CALCITE-3546) Improve EnumerableDefaults nested loop join

2019-11-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3546: Labels: pull-request-available (was: ) > Improve EnumerableDefaults nested loop join >

[jira] [Created] (CALCITE-3546) Improve EnumerableDefaults nested loop join

2019-11-28 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-3546: -- Summary: Improve EnumerableDefaults nested loop join Key: CALCITE-3546 URL: https://issues.apache.org/jira/browse/CALCITE-3546 Project: Calcite Issue Type:

[jira] [Resolved] (CALCITE-3539) EnumerableDefaults#nestedLoopJoin returns duplicates for JoinType.SEMI

2019-11-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-3539. Resolution: Fixed > EnumerableDefaults#nestedLoopJoin returns duplicates for JoinType.SEMI >

[jira] [Commented] (CALCITE-3539) EnumerableDefaults#nestedLoopJoin returns duplicates for JoinType.SEMI

2019-11-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984505#comment-16984505 ] Ruben Q L commented on CALCITE-3539: Fixed in

[jira] [Updated] (CALCITE-3539) EnumerableDefaults#nestedLoopJoin returns duplicates for JoinType.SEMI

2019-11-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3539: --- Description: The issue can be reproduced by adding the following test to EnumerablesTest.java:

[jira] [Closed] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing closed CALCITE-3545. - Resolution: Not A Problem > How to change calcite syntax > > >

[jira] [Commented] (CALCITE-3355) Deduce whether CASE and COALESCE may produce NULL values

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984431#comment-16984431 ] Chunwei Lei commented on CALCITE-3355: -- I open a pr for this(sorry for the delay~). 

[jira] [Commented] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984399#comment-16984399 ] Stamatis Zampetakis commented on CALCITE-3545: -- Yes you will have to modify the parser.jj

[jira] [Comment Edited] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread groobyming (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984357#comment-16984357 ] groobyming edited comment on CALCITE-3545 at 11/28/19 11:57 AM: Thanks

[jira] [Commented] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread groobyming (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984357#comment-16984357 ] groobyming commented on CALCITE-3545: - Thanks for your reply [~zabetak] It works by using

[jira] [Updated] (CALCITE-3542) Implement RepeatUnion All=false

2019-11-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3542: Labels: pull-request-available (was: ) > Implement RepeatUnion All=false >

[jira] [Updated] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-3544: - Description: When there are multiple predicates in RexSimplify, only the first predicates

[jira] [Commented] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984306#comment-16984306 ] Vladimir Sitnikov commented on CALCITE-3544: createSqlType...  -> tInt(), ArrayList ->

[jira] [Updated] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3544: Labels: pull-request-available (was: ) > RexSimplify does not exploit all known

[jira] [Updated] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-3544: - Description: When there are multiple predicates in RexSimplify, only the first predicates

[jira] [Commented] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984301#comment-16984301 ] Stamatis Zampetakis commented on CALCITE-3545: -- Hi [~groobyming], depending on the

[jira] [Commented] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984297#comment-16984297 ] Chunwei Lei commented on CALCITE-3544: -- Thanks [~vladimirsitnikov]. Will do. > RexSimplify does

[jira] [Updated] (CALCITE-3544) RexSimplify does not exploit all known predicates

2019-11-28 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3544: - Summary: RexSimplify does not exploit all known predicates (was: RexSimplify

[jira] [Commented] (CALCITE-3544) RexSimplify does not simpilfy RexNode completely

2019-11-28 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984296#comment-16984296 ] Vladimir Sitnikov commented on CALCITE-3544: Please prefer RexProgramBuilderBase APIs to

[jira] [Created] (CALCITE-3545) How to change calcite syntax

2019-11-28 Thread groobyming (Jira)
groobyming created CALCITE-3545: --- Summary: How to change calcite syntax Key: CALCITE-3545 URL: https://issues.apache.org/jira/browse/CALCITE-3545 Project: Calcite Issue Type: Test

[jira] [Created] (CALCITE-3544) RexSimplify does not simpilfy RexNode completely

2019-11-28 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-3544: Summary: RexSimplify does not simpilfy RexNode completely Key: CALCITE-3544 URL: https://issues.apache.org/jira/browse/CALCITE-3544 Project: Calcite Issue

[jira] [Commented] (CALCITE-3543) JDBC adapter converts count with single column to count star

2019-11-28 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984233#comment-16984233 ] Feng Zhu commented on CALCITE-3543: --- Good catch! In general sense, count(*) includes null. Maybe we

[jira] [Commented] (CALCITE-3538) Materialized view with AggregateFilterTransposeRule and a simple filter may corrupt a physical plan.

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984224#comment-16984224 ] Chunwei Lei commented on CALCITE-3538: -- Thanks for reporting this, [~anha]. I would like to take a

[jira] [Commented] (CALCITE-3246) RelJsonReader throws NullPointerException while deserializing from JSON a call to a user-defined function (UDF)

2019-11-28 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984221#comment-16984221 ] Chunwei Lei commented on CALCITE-3246: -- It seems using the class name to instantiate a class is