[
https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13082481#comment-13082481
]
[email protected] commented on HIVE-2344:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1404/
-----------------------------------------------------------
(Updated 2011-08-10 17:06:46.444966)
Review request for hive, John Sichi and Yongqiang He.
Changes
-------
The filter on 'udf selected as column alias in select' is no more pushed beyond
the select.
Summary (updated)
-------
Any filter on 'udf selected as column alias in select' will be pushed down
through the select operator, which it should not.
This addresses bug HIVE-2344.
https://issues.apache.org/jira/browse/HIVE-2344
Diffs (updated)
-----
trunk/ql/src/java/org/apache/hadoop/hive/ql/ppd/ExprWalkerProcFactory.java
1156069
trunk/ql/src/java/org/apache/hadoop/hive/ql/ppd/OpProcFactory.java 1156069
trunk/ql/src/test/queries/clientpositive/ppd_udf_col.q PRE-CREATION
trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out PRE-CREATION
Diff: https://reviews.apache.org/r/1404/diff
Testing (updated)
-------
All tests pass with the patch.
Thanks,
Amareshwari
> filter is removed due to regression of HIVE-1538
> ------------------------------------------------
>
> Key: HIVE-2344
> URL: https://issues.apache.org/jira/browse/HIVE-2344
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.8.0
> Reporter: He Yongqiang
> Assignee: Amareshwari Sriramadasu
> Fix For: 0.8.0
>
> Attachments: hive-patch-2344-2.txt, hive-patch-2344.txt,
> ppd_udf_col.q.out.txt
>
>
> select * from
> (
> select type_bucket,randum123
> from (SELECT *, cast(rand() as double) AS randum123 FROM tbl where ds = ...)
> a
> where randum123 <=0.1)s where s.randum123>0.1 limit 20;
> This is returning results...
> and
> explain
> select type_bucket,randum123
> from (SELECT *, cast(rand() as double) AS randum123 FROM tbl where ds = ...)
> a
> where randum123 <=0.1
> shows that there is no filter.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
