Hudson build is back to normal : Hive-trunk-h0.18 #369

2010-02-18 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.18/369/changes

[jira] Created: (HIVE-1179) Add UDF array_contains

2010-02-18 Thread Zheng Shao (JIRA)
Add UDF array_contains -- Key: HIVE-1179 URL: https://issues.apache.org/jira/browse/HIVE-1179 Project: Hadoop Hive Issue Type: New Feature Reporter: Zheng Shao Returns true or false, depending on whether an

[jira] Updated: (HIVE-1178) enforce bucketing for a table

2010-02-18 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1178: - Attachment: hive.1178.2.patch Incorporated Yongqiang's comments enforce bucketing for a table

ivy/hadoop downloads status update

2010-02-18 Thread John Sichi
Hi all, We're working on the problem in HIVE-984 which a number of people have been hitting, and with luck we'll have a resolution within the next week or so. To address it, we're setting up mirror.facebook.nethttp://mirror.facebook.net to serve the Hadoop versions needed by Hive, with better

[jira] Created: (HIVE-1180) Support Common Table Expressions (CTEs) in Hive

2010-02-18 Thread Jeff Hammerbacher (JIRA)
Support Common Table Expressions (CTEs) in Hive --- Key: HIVE-1180 URL: https://issues.apache.org/jira/browse/HIVE-1180 Project: Hadoop Hive Issue Type: Improvement Components: Query

[jira] Commented: (HIVE-1178) enforce bucketing for a table

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835374#action_12835374 ] He Yongqiang commented on HIVE-1178: Sorry. Reviewed it with Namit this morning offline.

[jira] Commented: (HIVE-1178) enforce bucketing for a table

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835397#action_12835397 ] He Yongqiang commented on HIVE-1178: bucket1, bucket2, bucket3, and input2 tests failed.

[jira] Commented: (HIVE-1180) Support Common Table Expressions (CTEs) in Hive

2010-02-18 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835456#action_12835456 ] Ning Zhang commented on HIVE-1180: -- It seems that he benefits of CTE are 1) its support of

[jira] Commented: (HIVE-1180) Support Common Table Expressions (CTEs) in Hive

2010-02-18 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835466#action_12835466 ] Edward Capriolo commented on HIVE-1180: --- (2) is a good addition to Hive, given that we

[jira] Updated: (HIVE-1032) Better Error Messages for Execution Errors

2010-02-18 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1032: Affects Version/s: 0.6.0 Status: Patch Available (was: Open) Better Error Messages for

[jira] Commented: (HIVE-1131) Add column lineage information to the pre execution hooks

2010-02-18 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835487#action_12835487 ] Raghotham Murthy commented on HIVE-1131: Went over code with Ashish. A few things:

[jira] Commented: (HIVE-1180) Support Common Table Expressions (CTEs) in Hive

2010-02-18 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835492#action_12835492 ] Ning Zhang commented on HIVE-1180: -- The session-level temp table has not been implemented

[jira] Created: (HIVE-1181) Make it optional to check file format

2010-02-18 Thread Zheng Shao (JIRA)
Make it optional to check file format - Key: HIVE-1181 URL: https://issues.apache.org/jira/browse/HIVE-1181 Project: Hadoop Hive Issue Type: Improvement Reporter: Zheng Shao

[jira] Updated: (HIVE-1178) enforce bucketing for a table

2010-02-18 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1178: - Attachment: hive.1178.3.patch There was a problem with running unit tests with hadoop 17 - fixed that.

[jira] Commented: (HIVE-1096) Hive Variables

2010-02-18 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835504#action_12835504 ] Carl Steinbach commented on HIVE-1096: -- bq. Philosophically I agree. In actuality have

[jira] Updated: (HIVE-1033) change default value of hive.exec.parallel to true

2010-02-18 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-1033: - Fix Version/s: (was: 0.5.0) 0.6.0 change default value of hive.exec.parallel to

[jira] Updated: (HIVE-1029) typedbytes does not support nulls

2010-02-18 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-1029: - Fix Version/s: (was: 0.5.0) 0.6.0 typedbytes does not support nulls

[jira] Commented: (HIVE-1181) Make it optional to check file format

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835515#action_12835515 ] He Yongqiang commented on HIVE-1181: This is 0.5 specific issue, or we also need to

[jira] Updated: (HIVE-1181) Make it optional to check file format

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1181: --- Attachment: hive-1181-branch0.5-1.patch Make it optional to check file format

[jira] Commented: (HIVE-1181) Make it optional to check file format

2010-02-18 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835533#action_12835533 ] Zheng Shao commented on HIVE-1181: -- We want to make it available for trunk also. Let's

[jira] Updated: (HIVE-1178) enforce bucketing for a table

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1178: --- Resolution: Fixed Release Note: HIVE-1178. enforce bucketing for a table. Hadoop Flags:

[jira] Commented: (HIVE-1096) Hive Variables

2010-02-18 Thread Jeff Hammerbacher (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835560#action_12835560 ] Jeff Hammerbacher commented on HIVE-1096: - Where does the ${VARNAME} syntax come

[jira] Commented: (HIVE-1096) Hive Variables

2010-02-18 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835566#action_12835566 ] Carl Steinbach commented on HIVE-1096: -- bq. Where does the ${VARNAME} syntax come from?

[jira] Updated: (HIVE-1134) bucketing mapjoin where the big table contains more than 1 big partition

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1134: --- Attachment: hive-1134-2010-02-18.patch Fixed some diff. Thanks Namit. bucketing mapjoin where the

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2010-02-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12835569#action_12835569 ] He Yongqiang commented on HIVE-417: --- Got talked with Prasad about this issue today. I may

Re: Putting the big table rightmost in the join

2010-02-18 Thread Yongqiang He
Hi Edward, You can do it with streamtable hint. Hive will put the table in that hint in the rightmost. -yongqiang On 2/18/10 3:21 PM, Edward Capriolo edlinuxg...@gmail.com wrote: I have worked through this issue. * When doing Join, please put the table with big number of rows containing