Wail Alkowaileet created ASTERIXDB-2254:
-------------------------------------------
Summary: Recognize common commutative expressions
Key: ASTERIXDB-2254
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2254
Project: Apache AsterixDB
Issue Type: Improvement
Components: COMP - Compiler
Reporter: Wail Alkowaileet
Currently, Algebricks does not recognize common commutative expressions.
Query:
{noformat}
SELECT t.retweet_count + 10, 10 + t.retweet_count
FROM Tweets as t{noformat}
Plan:
{noformat}
distribute result [$$15]
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$15])
-- STREAM_PROJECT |PARTITIONED|
assign [$$15] <- [{"$1": numeric-add($$16, 10), "$2": numeric-add(10,
$$16)}]
-- ASSIGN |PARTITIONED|
project ([$$16])
-- STREAM_PROJECT |PARTITIONED|
assign [$$16] <- [$$t.getField("retweet_count")]
-- ASSIGN |PARTITIONED|
project ([$$t])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$17, $$t] <- TwitterDataverse.Tweets
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
empty-tuple-source
-- EMPTY_TUPLE_SOURCE |PARTITIONED|
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
