[ https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13082481#comment-13082481 ]
jirapos...@reviews.apache.org 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