hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amareshwari Sriramadasu (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-1534) Join filters do not work correctly with outer joins
Date Fri, 17 Sep 2010 08:12:33 GMT

     [ https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Amareshwari Sriramadasu updated HIVE-1534:
------------------------------------------

    Attachment: patch-1534-2.txt

bq. What about semi joins ? 
I did not find anything wrong with semijoin queries and filters. They can be pushed as they
are now. I don't think any change is required for semi joins. What do you think?

Uploading patch with following changes from earlier one:
* I think it makes sense to push the filters on partitioned columns and not output all the
table for outer join. Patch pushes filters on partitioned columns, even for outer joins. Thoughts?
* Removed duplicate code in genExprNode() in SemanticAnalyzer.
* Fixed some minor bugs in SemanticAnalyzer and CommonJoinOperator, found in the test failures.
* Updated the test results for clientpositive queries in join20.q.out, join21.q.out and join40.q.out,
which involve filters on outer joins. Also, updated test results for TestParse join queries.

All the tests passed with the uploaded patch.


> Join filters do not work correctly with outer joins
> ---------------------------------------------------
>
>                 Key: HIVE-1534
>                 URL: https://issues.apache.org/jira/browse/HIVE-1534
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Amareshwari Sriramadasu
>         Attachments: patch-1534-1.txt, patch-1534-2.txt, patch-1534.txt
>
>
>  SELECT * FROM T1 LEFT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T1.c1 < 10)
> and  SELECT * FROM T1 RIGHT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T2.c1 < 10)
> do not give correct results.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message