[jira] [Updated] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu updated CALCITE-1824: -- Component/s: core > GROUP_ID returns wrong result > - > >

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010425#comment-17010425 ] Feng Zhu commented on CALCITE-1824: --- Yes, your are right. In calcite, we can use lateral and unnest.

[jira] [Assigned] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu reassigned CALCITE-1824: - Assignee: Feng Zhu > GROUP_ID returns wrong result > - > >

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010398#comment-17010398 ] Vladimir Sitnikov commented on CALCITE-1824: What do you mean by "we do not support lateral

[jira] [Resolved] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3531. - Resolution: Not A Problem > AggregateProjectPullUpConstantsRule should not remove

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010393#comment-17010393 ] Danny Chen commented on CALCITE-3531: - Fixed in

[jira] [Comment Edited] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010352#comment-17010352 ] Danny Chen edited comment on CALCITE-3531 at 1/8/20 5:29 AM: - Here is the

[jira] [Resolved] (CALCITE-3714) BitString.createFromBytes reverses order of the bits in each byte

2020-01-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3714. -- Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010352#comment-17010352 ] Danny Chen commented on CALCITE-3531: - Here is the definition of PostgreSQL "now":

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010349#comment-17010349 ] Danny Chen commented on CALCITE-3531: - Okey, let's make the "CURRENT_XXX" simple/deterministic in

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010324#comment-17010324 ] Feng Zhu commented on CALCITE-1824: --- Thanks [~vladimirsitnikov], rewriting to UNION-ALL is more

[jira] [Resolved] (CALCITE-3715) Add an interface to pass the table hints to RelOptTable

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3715. - Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010316#comment-17010316 ] Feng Zhu edited comment on CALCITE-1824 at 1/8/20 3:31 AM: --- {quote}The

[jira] [Comment Edited] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010316#comment-17010316 ] Feng Zhu edited comment on CALCITE-1824 at 1/8/20 3:30 AM: ---   {quote}The

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010316#comment-17010316 ] Feng Zhu commented on CALCITE-1824: ---   {quote}The problem with UNION ALL is that it duplicates the

[jira] [Commented] (CALCITE-3667) EnumerableMergeJoin should not use take-while enumerator

2020-01-07 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010288#comment-17010288 ] Jin Xing commented on CALCITE-3667: --- Hi, Julian ~ I think I didn't make myself clear ~ What I want

[jira] [Updated] (CALCITE-3679) Allow lambda expressions in SQL queries

2020-01-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3679: Labels: pull-request-available (was: ) > Allow lambda expressions in SQL queries >

[jira] [Resolved] (CALCITE-3663) Support for TRIM function in Bigquery dialect

2020-01-07 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-3663. -- Fix Version/s: 1.22.0 Resolution: Fixed Fixed in 

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010014#comment-17010014 ] Julian Hyde commented on CALCITE-1824: -- I'm not arguing. Both our approaches work. > GROUP_ID

[jira] [Comment Edited] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010007#comment-17010007 ] Vladimir Sitnikov edited comment on CALCITE-1824 at 1/7/20 7:14 PM:

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010007#comment-17010007 ] Vladimir Sitnikov commented on CALCITE-1824: {quote}The problem with UNION ALL is that it

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010004#comment-17010004 ] Julian Hyde commented on CALCITE-3285: -- {quote}The sad thing is there's no clear way to prevent

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010002#comment-17010002 ] Julian Hyde commented on CALCITE-1824: -- By the way, GROUP BY ... GROUPING SETS (i.e. Aggregate

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009995#comment-17009995 ] Julian Hyde commented on CALCITE-1824: -- The problem with UNION ALL is that it duplicates the input

[jira] [Created] (CALCITE-3716) ResultSetMetaData.getTableName should return empty string, not null, when column does not map to a table

2020-01-07 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3716: Summary: ResultSetMetaData.getTableName should return empty string, not null, when column does not map to a table Key: CALCITE-3716 URL:

[jira] [Updated] (CALCITE-3707) Implement COSH function

2020-01-07 Thread Forward Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-3707: Description: Implement COSH function. select cosh(1); |EXPR$0| |1.543080634815244| (1 row)

[jira] [Updated] (CALCITE-3707) Implement COSH function

2020-01-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3707: Labels: pull-request-available (was: ) > Implement COSH function >

[jira] [Updated] (CALCITE-3707) Implement COSH function

2020-01-07 Thread Forward Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-3707: Description: Implement COSH function. # COSH select cosh(1); +---+ | EXPR$0 |

[jira] [Resolved] (CALCITE-3712) Optimize lossless casts in RexSimplify: CAST(CAST(intExpr as BIGINT) as INT) => intExpr

2020-01-07 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov resolved CALCITE-3712. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3712) Optimize lossless casts in RexSimplify: CAST(CAST(intExpr as BIGINT) as INT) => intExpr

2020-01-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3712: Labels: pull-request-available (was: ) > Optimize lossless casts in RexSimplify:

[jira] [Updated] (CALCITE-3678) Add Presto map_filter function

2020-01-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3678: - Summary: Add Presto map_filter function (was: Calcite to support map_filter

[jira] [Updated] (CALCITE-3679) Allow lambda expressions in SQL queries

2020-01-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3679: - Summary: Allow lambda expressions in SQL queries (was: Calcite to support

[jira] [Updated] (CALCITE-3715) Add an interface to pass the table hints to RelOptTable

2020-01-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3715: Labels: pull-request-available (was: ) > Add an interface to pass the table hints to

[jira] [Updated] (CALCITE-3715) Add an interface to pass the table hints to RelOptTable

2020-01-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3715: Summary: Add an interface to pass the table hints to RelOptTable (was: Add a interface to pass

[jira] [Created] (CALCITE-3715) Add a interface to pass the table hints to RelOptTable

2020-01-07 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3715: --- Summary: Add a interface to pass the table hints to RelOptTable Key: CALCITE-3715 URL: https://issues.apache.org/jira/browse/CALCITE-3715 Project: Calcite

[jira] [Commented] (CALCITE-3627) Incorrect null semantic for ROW function

2020-01-07 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009655#comment-17009655 ] Feng Zhu commented on CALCITE-3627: --- Thanks for your insightful feedback, [~zabetak]! I will make

[jira] [Commented] (CALCITE-3627) Incorrect null semantic for ROW function

2020-01-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009638#comment-17009638 ] Stamatis Zampetakis commented on CALCITE-3627: -- Thanks for the clarification [~donnyzone]!

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-07 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009530#comment-17009530 ] Vladimir Sitnikov commented on CALCITE-3285: {quote} What if we return infinite cost in

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009487#comment-17009487 ] Ruben Q L commented on CALCITE-3285: What if we return infinite cost in

[jira] [Commented] (CALCITE-3711) Correlate should override estimateRowCount

2020-01-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009448#comment-17009448 ] Ruben Q L commented on CALCITE-3711: Thanks for taking care of this [~vladimirsitnikov]! >