Wail Alkowaileet created ASTERIXDB-2253:
-------------------------------------------
Summary: Disjunctive predicts on the same fields introduces join
Key: ASTERIXDB-2253
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2253
Project: Apache AsterixDB
Issue Type: Bug
Reporter: Wail Alkowaileet
I'm not sure if I'm missing something ... It looks more expensive than
StreamSelect
Query:
{noformat}
SELECT value t.text
FROM Tweets as t
WHERE t.retweet_count = 10 or t.retweet_count = 20{noformat}
Plan:
{noformat}
distribute result [$$16]
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$16])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
join (eq($$19, $$17))
-- HYBRID_HASH_JOIN [$$17][$$19] |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$16, $$17])
-- STREAM_PROJECT |PARTITIONED|
assign [$$16, $$17] <- [$$t.getField("text"),
$$t.getField("retweet_count")]
-- ASSIGN |PARTITIONED|
project ([$$t])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$18, $$t] <- TwitterDataverse.Tweets
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
empty-tuple-source
-- EMPTY_TUPLE_SOURCE |PARTITIONED|
exchange
-- BROADCAST_EXCHANGE |PARTITIONED|
unnest $$19 <- scan-collection(array: [ 20, 10 ])
-- UNNEST |UNPARTITIONED|
empty-tuple-source
-- EMPTY_TUPLE_SOURCE |UNPARTITIONED|
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
