[CALCITE-2658] Introducing more ReduceExpressionRules - ASF JIRA

XML

Word

Printable

JSON

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.

is related to

CALCITE-2729 Introducing WindowReduceExpressionRule

links to

GitHub Pull Request #912

Estimated:

Not Specified

Remaining:

Logged:

2h 20m