[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

["Chunwei Lei (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16745741#comment-16745741 ] 

Chunwei Lei commented on CALCITE-2658:
--------------------------------------

Hi [~julianhyde]

Do you or someone else have any plan on reviewing [PR#921 |https://github.com/apache/calcite/pull/921/] and [PR#912 |https://github.com/apache/calcite/pull/912/]? Thank you very much.

> Introducing more ReduceExpressionRules
> --------------------------------------
>
>                 Key: CALCITE-2658
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2658
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.17.0
>            Reporter: Chunwei Lei
>            Assignee: Julian Hyde
>            Priority: Major
>              Labels: pull-request-available
>
> It is useful to have rules reducing Exchange/Sort/SortExchange keys, e.g.,
> SELECT key,value FROM (SELECT 1 AS key, value FROM src) r DISTRIBUTE BY key;
> can be reduced to 
> SELECT 1 AS key, value FROM src;    # Since singleton requirement may already required by SELECT.
> SELECT key,value FROM (SELECT 1 AS key, value FROM src) r ORDER BY key;
> can be reduced to
> SELECT 1 AS key, value FROM src;    # Since ordering on constant is useless.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)