[jira] Updated: (HIVE-1790) Patch to support HAVING clause in Hive
[ https://issues.apache.org/jira/browse/HIVE-1790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1790: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) Committed. Thanks Vaibhav! Patch to support HAVING clause in Hive -- Key: HIVE-1790 URL: https://issues.apache.org/jira/browse/HIVE-1790 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vaibhav Aggarwal Assignee: Vaibhav Aggarwal Fix For: 0.7.0 Attachments: HIVE-1790-1.patch, HIVE-1790.2.patch.txt, HIVE-1790.3.patch.txt, HIVE-1790.4.patch.txt, HIVE-1790.patch Currently Hive users have to do nested queries in order to apply filter on group by expressions. This patch allows users to directly apply filter on group by expressions by using HAVING clause. This patch also helps us integrate Hive with other data analysis tools which rely on HAVING expression. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
Re: (HIVE-1642) Convert join queries to map-join based on size of table/row
Thanks for the reply. I want to get clarification on this feature. If one of the two joining tables table t1 is smaller than 25M and is sharded, how does this feature work? Suppose there are joins on multiple tables such as t1, t2 and t3. If t1 and t2 are smaller than 25M and co-located with joining key, you can stream t3 and map join them. What if t1 and t2 are not co-located with join keys? What if t1 and t2 together are bigger than 25M? Thanks in advance! On Thu, Dec 23, 2010 at 7:16 PM, Liyin Tang liyint...@gmail.com wrote: Hi, How large is t1 and t2 ? if both of t1 and t2 is larger than 25M (a default threshold), the query processor will do the common join. Thanks Liyin On 23 December 2010 18:50, ash...@gmail.com wrote: Hi, I set hive.auto.convert.join=true and run the following query: select t1.foo, count(t2.bar) from invites t1 join invites t2 on (t1.foo=t2.foo) group by t1.foo; I did not see it ran as map side join. Did I miss something? Is there any precondition for this feature to work? Thanks. -- Best Regards -Liyin