hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <>
Subject [jira] [Commented] (HIVE-7111) Extend join transitivity PPD to non-column expressions
Date Tue, 28 Oct 2014 19:28:34 GMT


Ashutosh Chauhan commented on HIVE-7111:

I took a variant of test I added in HIVE-8598 and ran with this patch applied :
select * from src s1, src s2 where 1 = 2 and s1.value = s2.value;

My hope was that filter 1 = 2 will be pushed to TS after this patch and than constant folding
will fold this to where false and than nullscan optimizer will optimize it. But seems like
filter was not pushed past Join, as a result, null scan optimizer didnt kick in. 

Is expectation here to able to push such filters as well? This is more of a question if this
patch is targeting such filter expressions. We need not to necessarily handle this within
this jira, can be taken as follow-on.

> Extend join transitivity PPD to non-column expressions
> ------------------------------------------------------
>                 Key: HIVE-7111
>                 URL:
>             Project: Hive
>          Issue Type: Task
>          Components: Query Processor
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-7111.1.patch.txt, HIVE-7111.2.patch.txt, HIVE-7111.2.patch.txt,
HIVE-7111.3.patch.txt, HIVE-7111.4.patch.txt
> Join transitive in PPD only supports column expressions, but it's possible to extend
this to generic expressions.

This message was sent by Atlassian JIRA

View raw message