Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-27 Thread Liyin Tang
Hi, If multiple tables join on different join keys, it will be separated into multiple MapRed Tasks. Also the threshold of the small table file size means the sum of all the small table. There is a documentation and a slide about this feature:

[jira] Commented: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975308#action_12975308 ] John Sichi commented on HIVE-1858: -- +1. Will commit if tests pass. The wiki is going to

Re: Review Request: HIVE-1262

2010-12-27 Thread John Sichi
On 2010-12-23 16:04:03, John Sichi wrote: http://svn.apache.org/repos/asf/hive/trunk/common/src/java/org/apache/hadoop/hive/common/AesUtils.java, line 16 https://reviews.apache.org/r/192/diff/1/?file=9229#file9229line16 Here we may be chopping off a UTF-8 multibyte sequence in

[jira] Commented: (HIVE-1734) Implement map_keys() and map_values() UDFs

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975330#action_12975330 ] Carl Steinbach commented on HIVE-1734: -- @Eldon: Are you still working on this?

[jira] Updated: (HIVE-901) Build Hive C++ Client library with Autoconf/Automake

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-901: Description: In order to avoid more bugs like HIVE-898 it would be a good idea to build the C++

[jira] Updated: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1858: - Resolution: Fixed Fix Version/s: 0.7.0 Hadoop Flags: [Reviewed] Status: Resolved

Build failed in Hudson: Hive-trunk-h0.20 #455

2010-12-27 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/455/changes Changes: [cws] HIVE-1790 Support HAVING clause in Hive (Vaibhav Aggarwal via cws) -- [...truncated 14714 lines...] [junit] POSTHOOK: Output: defa...@srcbucket2 [junit] OK

[jira] Commented: (HIVE-7) Partition keys are still treated as strings irrespective of their defined type in runtime.

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975409#action_12975409 ] Carl Steinbach commented on HIVE-7: --- Is this ticket stil valid? Partition keys are still

[jira] Resolved: (HIVE-985) Add Eclipse Launch Configuration for CliDriver

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-985. - Resolution: Duplicate Add Eclipse Launch Configuration for CliDriver

[jira] Created: (HIVE-1869) TestMTQueries intermittently failing on Hudson

2010-12-27 Thread Carl Steinbach (JIRA)
TestMTQueries intermittently failing on Hudson -- Key: HIVE-1869 URL: https://issues.apache.org/jira/browse/HIVE-1869 Project: Hive Issue Type: Bug Components: Query Processor, Testing

[jira] Updated: (HIVE-1869) TestMTQueries intermittently failing on Hudson

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1869: - Attachment: TestMTQueries.log TestMTQueries intermittently failing on Hudson

[jira] Created: (HIVE-1870) TestRemoteHiveMetaStore.java accidentally deleted during commit of HIVE-1845

2010-12-27 Thread Carl Steinbach (JIRA)
TestRemoteHiveMetaStore.java accidentally deleted during commit of HIVE-1845 Key: HIVE-1870 URL: https://issues.apache.org/jira/browse/HIVE-1870 Project: Hive

[jira] Updated: (HIVE-1870) TestRemoteHiveMetaStore.java accidentally deleted during commit of HIVE-1845

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1870: - Status: Patch Available (was: Open) TestRemoteHiveMetaStore.java accidentally deleted during

[jira] Updated: (HIVE-1870) TestRemoteHiveMetaStore.java accidentally deleted during commit of HIVE-1845

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1870: - Attachment: HIVE-1870.1.patch.txt TestRemoteHiveMetaStore.java accidentally deleted during

Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-27 Thread ashu99
A question about the design doc: If one of the tables is large and others are small enough to run Map Join, then the Conditional Task will pick the corresponding Map Join Local Task to run. Here you pick one table as big, hash all other tables into memory by join key individually. If it works, it

Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-27 Thread Liyin Tang
Yes. Only execute one of the them. On 27 December 2010 23:43, ash...@gmail.com wrote: A question about the design doc: If one of the tables is large and others are small enough to run Map Join, then the Conditional Task will pick the corresponding Map Join Local Task to run. Here you pick