Re: Will hive support PL/SQL?

2010-02-08 Thread Mafish Liu
Hive supports SQL-like language named HSQL. Refer http://wiki.apache.org/hadoop/Hive/LanguageManual for more details. 2010/2/8 jian yi eyj...@gmail.com: Hi all,    PL/SQL is very convenient, will hive support it? Regards Jian Yi -- maf...@gmail.com

Re: Will hive support PL/SQL?

2010-02-08 Thread Jeff Zhang
I think PL/SQL is one kind of DSL upon SQL, so it is possible to build similar things upon HSQL. Ruby DSL may be one option On Mon, Feb 8, 2010 at 4:20 PM, Mafish Liu maf...@gmail.com wrote: Hive supports SQL-like language named HSQL. Refer http://wiki.apache.org/hadoop/Hive/LanguageManual

Re: Will hive support PL/SQL?

2010-02-08 Thread jian yi
Many people want to migrate oracle PL/SQL to Hive, it's difficult that if PL is not supported. 2010/2/8 Jeff Zhang zjf...@gmail.com I think PL/SQL is one kind of DSL upon SQL, so it is possible to build similar things upon HSQL. Ruby DSL may be one option On Mon, Feb 8, 2010 at 4:20 PM,

[jira] Updated: (HIVE-1019) java.io.FileNotFoundException: HIVE_PLAN (No such file or directory)

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bennie Schut updated HIVE-1019: --- Attachment: HIVE-1019-4.patch On Context I've looked at making the id generation more generic so like

[jira] Commented: (HIVE-1019) java.io.FileNotFoundException: HIVE_PLAN (No such file or directory)

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12830891#action_12830891 ] Bennie Schut commented on HIVE-1019: I've also made some minor changes to get the check

[jira] Created: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
Hive using lzo comporession returns unexpected results. --- Key: HIVE-1138 URL: https://issues.apache.org/jira/browse/HIVE-1138 Project: Hadoop Hive Issue Type: Bug Components:

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12830908#action_12830908 ] Bennie Schut commented on HIVE-1138: Doesn't seem to happen when I set compression to

Build failed in Hudson: Hive-trunk-h0.17 #356

2010-02-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.17/356/ -- Started by timer Building remotely on minerva.apache.org (Ubuntu) Updating http://svn.apache.org/repos/asf/hadoop/hive/trunk At revision 907649 no change for

[jira] Updated: (HIVE-1019) java.io.FileNotFoundException: HIVE_PLAN (No such file or directory)

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bennie Schut updated HIVE-1019: --- Status: Patch Available (was: In Progress) Let me know if this is good enough or some more

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12830944#action_12830944 ] Bennie Schut commented on HIVE-1138: on the filesystem I do find a jobfile like this:

Build failed in Hudson: Hive-trunk-h0.18 #360

2010-02-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.18/360/ -- [...truncated 2971 lines...] AUql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPEqualOrGreaterThan.java A ql/src/java/org/apache/hadoop/hive/ql/udf/UDFBaseNumericOp.java AU

Build failed in Hudson: Hive-trunk-h0.19 #360

2010-02-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.19/360/ -- [...truncated 2971 lines...] AUql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPEqualOrGreaterThan.java A ql/src/java/org/apache/hadoop/hive/ql/udf/UDFBaseNumericOp.java AU

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

2010-02-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.20/182/ -- [...truncated 2971 lines...] AUql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPEqualOrGreaterThan.java A ql/src/java/org/apache/hadoop/hive/ql/udf/UDFBaseNumericOp.java AU

Hudson builds are broken due to ivy upgrade

2010-02-08 Thread John Sichi
We need to delete the .ant directory containing the old ivy version in order to fix it (and if we're using the same environment for both trunk and branches, either segregate them or script an rm to clean in between). Who can I contact to deal with the Hudson build environment? JVS

Re: Hudson builds are broken due to ivy upgrade

2010-02-08 Thread Carl Steinbach
I'm in favor of ditching the dynamic resolution of the ivy jar and just checking it into ivy/ or lib/. In general I don't think this is appropriate (that's what Ivy is for, right?), but I think this counts as a special case. Carl On Mon, Feb 8, 2010 at 10:42 AM, John Sichi jsi...@facebook.com

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831043#action_12831043 ] He Yongqiang commented on HIVE-1138: Hi Bennie Are you seeing this on rcfile table or

Re: Hudson builds are broken due to ivy upgrade

2010-02-08 Thread John Sichi
I'm fine with that too if someone wants to go ahead with that, but regardless, I think we'll still need to do something to unwedge Hudson since ivy seems to always find the old version in the .ant/lib directory if it's there. JVS On Feb 8, 2010, at 10:54 AM, Carl Steinbach wrote: I'm in

[jira] Commented: (HIVE-1133) Refactor InputFormat and OutputFormat for Hive

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831054#action_12831054 ] He Yongqiang commented on HIVE-1133: Add another possible requirement: add support for

[jira] Created: (HIVE-1139) GroupByOperator sometimes throws OutOfMemory error when there are too many distinct keys

2010-02-08 Thread Ning Zhang (JIRA)
GroupByOperator sometimes throws OutOfMemory error when there are too many distinct keys Key: HIVE-1139 URL: https://issues.apache.org/jira/browse/HIVE-1139

[jira] Commented: (HIVE-1139) GroupByOperator sometimes throws OutOfMemory error when there are too many distinct keys

2010-02-08 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831101#action_12831101 ] Ning Zhang commented on HIVE-1139: -- GroupByOperator uses HashMap's size() and iterator()

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831106#action_12831106 ] Bennie Schut commented on HIVE-1138: This example is on a text table: ROW FORMAT

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831112#action_12831112 ] He Yongqiang commented on HIVE-1138: 1) Can you check if LzoCodec is loaded/installed

[jira] Created: (HIVE-1140) Incorrect mbiguous column reference error message

2010-02-08 Thread Paul Yang (JIRA)
Incorrect mbiguous column reference error message - Key: HIVE-1140 URL: https://issues.apache.org/jira/browse/HIVE-1140 Project: Hadoop Hive Issue Type: Bug Affects Versions: 0.5.0, 0.6.0

[jira] Updated: (HIVE-1140) Incorrect ambiguous column reference error message

2010-02-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1140: Summary: Incorrect ambiguous column reference error message (was: Incorrect mbiguous column reference

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831120#action_12831120 ] Bennie Schut commented on HIVE-1138: on 0.20.1 lzo is removed. I installed the

[jira] Created: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread Zheng Shao (JIRA)
Remove recursive call in FetchOperator.getNextRow - Key: HIVE-1141 URL: https://issues.apache.org/jira/browse/HIVE-1141 Project: Hadoop Hive Issue Type: Bug Affects Versions: 0.5.0, 0.6.0

[jira] Created: (HIVE-1142) datanucleus typos in conf/hive-default.xml

2010-02-08 Thread John Sichi (JIRA)
datanucleus typos in conf/hive-default.xml Key: HIVE-1142 URL: https://issues.apache.org/jira/browse/HIVE-1142 Project: Hadoop Hive Issue Type: Bug Components: Configuration Affects

[jira] Updated: (HIVE-1142) datanucleus typos in conf/hive-default.xml

2010-02-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1142: - Status: Patch Available (was: Open) datanucleus typos in conf/hive-default.xml

[jira] Updated: (HIVE-1142) datanucleus typos in conf/hive-default.xml

2010-02-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1142: - Attachment: HIVE-1142.1.patch Patch for the conf file. datanucleus typos in conf/hive-default.xml

[jira] Updated: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-1141: - Status: Patch Available (was: Open) Remove recursive call in FetchOperator.getNextRow

[jira] Updated: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-1141: - Attachment: HIVE-1141.1.patch HIVE-1141.1.branch-0.5.patch Remove recursive call in

[jira] Commented: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831173#action_12831173 ] He Yongqiang commented on HIVE-1141: Zheng, does your change work with

[jira] Commented: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831182#action_12831182 ] He Yongqiang commented on HIVE-1141: Discussed with Zheng, this kind of recursive call

[jira] Updated: (HIVE-1141) Remove recursive call in FetchOperator.getNextRow

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1141: --- Resolution: Fixed Release Note: Remove recursive call in FetchOperator.getNextRow Hadoop

[jira] Updated: (HIVE-917) Bucketed Map Join

2010-02-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-917: -- Attachment: hive-917-2010-2-8.patch A new patch integrated with Namit's comments. Thanks Namit.

[jira] Updated: (HIVE-1140) Incorrect ambiguous column reference error message

2010-02-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1140: Status: Patch Available (was: Open) Incorrect ambiguous column reference error message

[jira] Updated: (HIVE-1140) Incorrect ambiguous column reference error message

2010-02-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1140: Attachment: HIVE-1140.branch-0.5.1.patch HIVE-1140.1.patch Incorrect ambiguous column

[jira] Commented: (HIVE-1142) datanucleus typos in conf/hive-default.xml

2010-02-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831257#action_12831257 ] Paul Yang commented on HIVE-1142: - So even though these settings didn't have an effect, it

[jira] Assigned: (HIVE-1142) datanucleus typos in conf/hive-default.xml

2010-02-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-1142: Assignee: Paul Yang (was: John Sichi) Paul, can you take over on this one and update the

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831301#action_12831301 ] Zheng Shao commented on HIVE-1138: -- Bennie, I think the problem is that when Hive is

Re: error

2010-02-08 Thread Carl Steinbach
Hi Sarita, The command you quoted looks good and should work. I just tried checking out the source using the same command and had no problems, so it's possible that there was some kind of temporary issue with the Apache subversion server. Another option you may want to consider is using git

[jira] Commented: (HIVE-1138) Hive using lzo comporession returns unexpected results.

2010-02-08 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12831339#action_12831339 ] Bennie Schut commented on HIVE-1138: I was looking a little bit into that direction but

[jira] Resolved: (HIVE-1123) Checkstyle fixes

2010-02-08 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao resolved HIVE-1123. -- Resolution: Fixed Fix Version/s: 0.6.0 Release Note: HIVE-1123. Checkstyle fixes. (Carl