Is hive-0.9.0 is compatible with hadoo-2.0.0..?

Hi All, Can I run Hive-0.9.0 with hadoop-2.0.0..? Regards Rohith Sharma K S

How to pass hadoop_opts( hadoop-0.23.0) from hive ?

Hi All I have deployed Hive-0.9.1 + Hadoop-0.23.0. I want to pass HADOOP_OPTS from Hive like GC_OPTS. Problem I am facing in passing HADOOP_OPTS IS à In $HADOOP_HOME/bin/hadoop script, HADOOP_OPTS is nullified. Because of this , any HADOOP_OPTS passed from Hive is taking aff

What is the use case of ASSERT_TRUE()..?

Hi Users, What is the use case of ASSERT_TRUE()..? When ASSERT_TRUE() is executed from JDBC client , it is not able to retrieve the result throwing Exception. Which is the correct use of ASSERT_TRUE() true function. 1. SELECT assert_true(key > 0) FROM src 2. SELECT 1 + assert_

Please help : Hive + postgres integration. Drop table query is hanging.

Hi I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated postgres with hive. Few queries are working fine. I am using postgresql-9.0-802.jdbc3.jar for connecting to JDBC. But "drop table query" is hanging. Following is Hive DEBUG log . 08/12/28 06:02:09 DEBUG lazy

Please help : Hive + postgres integration. Drop table query is hanging.

Hi I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated postgres with hive. Few queries are working fine. I am using postgresql-9.0-802.jdbc3.jar for connecting to JDBC. But "drop table query" is hanging. Following is Hive DEBUG log . 08/12/28 06:02:09 DEBUG lazy

RE: Issue when trying to debug hive

Have you running hadoop component in debug mode..? This problem can occur if you have started Hadoop component in Debug mode with same port. Change the port and try.. From: Kasun Weranga [mailto:kas...@wso2.com] Sent: Sunday, September 23, 2012 11:58 AM To: u...@hive.apache.org Cc: dev@hi

Re: Issue when trying to debug hive

Have you running hadoop component in debug mode..? This problem can occur if you have started Hadoop component in Debug mode with same port. Change the port and try.. From: Kasun Weranga [mailto:kas...@wso2.com] Sent: Sunday, September 23, 2012 11:58 AM To: u...@hive.apache.org Cc: dev@hi

[jira] [Created] (HIVE-2263) Wrong value is retrieved by ResultSet.getColumnDisplaySize() for SMALLINT and FLOAT Datatype

Project: Hive Issue Type: Bug Components: JDBC Affects Versions: 0.7.1, 0.5.0 Environment: Linux. Hadoop-20.1 and Hive-0.7.1 Reporter: rohithsharma Priority: Minor 1).Create a table with smallint datatype. create table test(a

[jira] [Created] (HIVE-2264) Hive server is SHUTTING DOWN when invalid/complex queries been used.

Components: Query Processor Affects Versions: 0.7.1, 0.7.0 Environment: SuSE-Linux-11 Reporter: rohithsharma Priority: Critical When invalid query is beeing executed, Hive server is shutting down. {noformat} "CREATE TABLE SAMPLETABLE(IP STRING , sho

[jira] [Updated] (HIVE-2264) Hive server is SHUTTING DOWN when invalid/complex queries been used.

[ https://issues.apache.org/jira/browse/HIVE-2264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-2264: --- Description: When invalid query is beeing executed, Hive server is shutting down. {noformat} "C

[jira] [Updated] (HIVE-2264) Hive server is SHUTTING DOWN when invalid queries beeing executed.

[ https://issues.apache.org/jira/browse/HIVE-2264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-2264: --- Summary: Hive server is SHUTTING DOWN when invalid queries beeing executed. (was: Hive server is

[jira] [Created] (HIVE-2265) "insert overwrite directory" for Multilevel directory fails.

Components: Query Processor Affects Versions: 0.7.1, 0.7.0 Environment: SuSE-Linux-11 Reporter: rohithsharma Couldnot able to complete query execution for "insert overwrite directory" query when the Directory path is Multilevel. create table test ( a int , b i

[jira] [Created] (HIVE-2271) InConsistency between Infomation Document and Actual Behavior for Built In Aggregate Functions(UDAF) Return Type.

://issues.apache.org/jira/browse/HIVE-2271 Project: Hive Issue Type: Bug Components: Documentation, Query Processor Affects Versions: 0.7.1, 0.7.0, 0.6.0, 0.5.0 Environment: SuSE-Linux-11 Reporter: rohithsharma I followed the Information Document

[jira] [Commented] (HIVE-3060) ClassNotFoundError while executing the getClusterStatus API

[ https://issues.apache.org/jira/browse/HIVE-3060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13284296#comment-13284296 ] rohithsharma commented on HIVE-3060: This exception is thrown when Hive-0.9.

[jira] [Commented] (HIVE-3060) ClassNotFoundError while executing the getClusterStatus API

[ https://issues.apache.org/jira/browse/HIVE-3060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288587#comment-13288587 ] rohithsharma commented on HIVE-3060: I verified with patch. It is working fine. Pl

[jira] [Created] (HIVE-3091) Fix eclipse classpath for hadoop-2.0.1 support

rohithsharma created HIVE-3091: -- Summary: Fix eclipse classpath for hadoop-2.0.1 support Key: HIVE-3091 URL: https://issues.apache.org/jira/browse/HIVE-3091 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-3091) Fix eclipse classpath for hadoop-2.0.1 support

[ https://issues.apache.org/jira/browse/HIVE-3091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13289966#comment-13289966 ] rohithsharma commented on HIVE-3091: I have 2 approached to handle this problem

[jira] [Updated] (HIVE-3141) Bug in SELECT query

[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3141: --- Component/s: (was: CLI) Tests > Bug in SELECT qu

[jira] [Created] (HIVE-3143) Following Test Cases fails in Hive-0.9 and Hadoop-0.23

rohithsharma created HIVE-3143: -- Summary: Following Test Cases fails in Hive-0.9 and Hadoop-0.23 Key: HIVE-3143 URL: https://issues.apache.org/jira/browse/HIVE-3143 Project: Hive Issue Type

[jira] [Updated] (HIVE-3141) Bug in SELECT query

[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3141: --- Component/s: (was: Tests) CLI > Bug in SELECT qu

[jira] [Created] (HIVE-3151) Not able to configure HIVE_OPTS.

rohithsharma created HIVE-3151: -- Summary: Not able to configure HIVE_OPTS. Key: HIVE-3151 URL: https://issues.apache.org/jira/browse/HIVE-3151 Project: Hive Issue Type: Bug Components

[jira] [Commented] (HIVE-3143) Following Test Cases fails in Hive-0.9 and Hadoop-0.23

[ https://issues.apache.org/jira/browse/HIVE-3143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13395976#comment-13395976 ] rohithsharma commented on HIVE-

[jira] [Created] (HIVE-3156) Support MiniMR tests for Hadoop-0.23

rohithsharma created HIVE-3156: -- Summary: Support MiniMR tests for Hadoop-0.23 Key: HIVE-3156 URL: https://issues.apache.org/jira/browse/HIVE-3156 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-3151) Not able to configure HIVE_OPTS.

[ https://issues.apache.org/jira/browse/HIVE-3151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13396788#comment-13396788 ] rohithsharma commented on HIVE-3151: I tried with passing these arguments thr

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397421#comment-13397421 ] rohithsharma commented on HIVE-2804: I also encountered the same problem with

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397429#comment-13397429 ] rohithsharma commented on HIVE-2804: In addition to above, Currently, Once the

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398194#comment-13398194 ] rohithsharma commented on HIVE-2804: @zhenxiao >>> Are you using

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398195#comment-13398195 ] rohithsharma commented on HIVE-2804: I think, adding "GenericUDFEvaluat

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398234#comment-13398234 ] rohithsharma commented on HIVE-2804: In TaskLogProcessor.java, there are 2 met

[jira] [Created] (HIVE-3170) Failed Job URL should be depends on MR cluster used.

rohithsharma created HIVE-3170: -- Summary: Failed Job URL should be depends on MR cluster used. Key: HIVE-3170 URL: https://issues.apache.org/jira/browse/HIVE-3170 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

rohithsharma created HIVE-3309: -- Summary: drop partition doesnot work for mixture of string and non-string columns for non-equality operatior Key: HIVE-3309 URL: https://issues.apache.org/jira/browse/HIVE-3309

[jira] [Commented] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424271#comment-13424271 ] rohithsharma commented on HIVE-3309: bq. Which version of Hive are you using.?

[jira] [Commented] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424877#comment-13424877 ] rohithsharma commented on HIVE-3309: If the query contains partition column of

[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Fix Version/s: 0.10.0 Labels: patch (was: ) Affects Version/s: 0.10.0

[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Attachment: HIVE-3309.patch > drop partition doesnot work for mixture of string and non-str

[jira] [Created] (HIVE-3324) analyze command is not gathering "num_rows" present in the table.

rohithsharma created HIVE-3324: -- Summary: analyze command is not gathering "num_rows" present in the table. Key: HIVE-3324 URL: https://issues.apache.org/jira/browse/HIVE-3324 Pro

[jira] [Commented] (HIVE-3324) analyze command is not gathering "num_rows" present in the table.

[ https://issues.apache.org/jira/browse/HIVE-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425819#comment-13425819 ] rohithsharma commented on HIVE-3324: >From the code I see, default configura

[jira] [Commented] (HIVE-3324) analyze command is not gathering "num_rows" present in the table.

[ https://issues.apache.org/jira/browse/HIVE-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425822#comment-13425822 ] rohithsharma commented on HIVE-3324: I have one doubt for analyze configuration. b

[jira] [Commented] (HIVE-3324) analyze command is not gathering "num_rows" present in the table.

[ https://issues.apache.org/jira/browse/HIVE-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13426345#comment-13426345 ] rohithsharma commented on HIVE-3324: There are 2 problems for analyze command

[jira] [Commented] (HIVE-2532) Evaluation of non-deterministic/stateful UDFs should not be skipped even if constant oi is returned.

[ https://issues.apache.org/jira/browse/HIVE-2532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427133#comment-13427133 ] rohithsharma commented on HIVE-2532: Hi, I have one doubt on ASSERT_TRUE() fun

[jira] [Commented] (HIVE-2532) Evaluation of non-deterministic/stateful UDFs should not be skipped even if constant oi is returned.

[ https://issues.apache.org/jira/browse/HIVE-2532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427249#comment-13427249 ] rohithsharma commented on HIVE-2532: I tested with changing implementatio

[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Attachment: HIVE-3309.patch > drop partition doesnot work for mixture of string and non-str

[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Status: Patch Available (was: Open) > drop partition doesnot work for mixture of string and

[jira] [Created] (HIVE-3419) drop partition does not work for non-equality oprator.

rohithsharma created HIVE-3419: -- Summary: drop partition does not work for non-equality oprator. Key: HIVE-3419 URL: https://issues.apache.org/jira/browse/HIVE-3419 Project: Hive Issue Type

[jira] [Commented] (HIVE-3419) drop partition does not work for non-equality oprator.

[ https://issues.apache.org/jira/browse/HIVE-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13445726#comment-13445726 ] rohithsharma commented on HIVE-3419: JDO throws NullPointerException for a

[jira] [Commented] (HIVE-3419) drop partition does not work for non-equality oprator.

[ https://issues.apache.org/jira/browse/HIVE-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13445818#comment-13445818 ] rohithsharma commented on HIVE-3419: I think it looks like problem with datanuclu

[jira] [Created] (HIVE-3425) NPE exception in Tests escape1 and escape2.

rohithsharma created HIVE-3425: -- Summary: NPE exception in Tests escape1 and escape2. Key: HIVE-3425 URL: https://issues.apache.org/jira/browse/HIVE-3425 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-3425) NPE exception in Tests escape1 and escape2.

[ https://issues.apache.org/jira/browse/HIVE-3425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447185#comment-13447185 ] rohithsharma commented on HIVE-3425: Exception trace is as follows {noformat} 201

[jira] [Created] (HIVE-3469) When new hive cluster is started, hive jdbc client hangs.

rohithsharma created HIVE-3469: -- Summary: When new hive cluster is started, hive jdbc client hangs. Key: HIVE-3469 URL: https://issues.apache.org/jira/browse/HIVE-3469 Project: Hive Issue Type

[jira] [Commented] (HIVE-3469) When new hive cluster is started, hive jdbc client hangs.

[ https://issues.apache.org/jira/browse/HIVE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13456356#comment-13456356 ] rohithsharma commented on HIVE-3469: 1. For the first problem , exception from JD

[jira] [Commented] (HIVE-3469) When new hive cluster is started, hive jdbc client hangs.

[ https://issues.apache.org/jira/browse/HIVE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13456357#comment-13456357 ] rohithsharma commented on HIVE-3469: Any exception in above 1 or 3, Hive client h

[jira] [Commented] (HIVE-3469) When new hive cluster is started, hive jdbc client hangs.

[ https://issues.apache.org/jira/browse/HIVE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13457605#comment-13457605 ] rohithsharma commented on HIVE-3469: bq. Any idea why this doesn't solve th

[jira] [Commented] (HIVE-3469) When new hive cluster is started, hive jdbc client hangs.

[ https://issues.apache.org/jira/browse/HIVE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13461604#comment-13461604 ] rohithsharma commented on HIVE-3469: Applying patch of HIVE-2937 has fixed all 3 i

[jira] [Commented] (HIVE-2084) Upgrade datanucleus from 2.0.3 to 3.0.1

[ https://issues.apache.org/jira/browse/HIVE-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13461627#comment-13461627 ] rohithsharma commented on HIVE-2084: Could anyone please update on this i

[jira] [Resolved] (HIVE-2265) "insert overwrite directory" for Multilevel directory fails.

[ https://issues.apache.org/jira/browse/HIVE-2265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma resolved HIVE-2265. Resolution: Duplicate > "insert overwrite directory" for Multilevel di

[jira] [Commented] (HIVE-2265) "insert overwrite directory" for Multilevel directory fails.

[ https://issues.apache.org/jira/browse/HIVE-2265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13462731#comment-13462731 ] rohithsharma commented on HIVE-2265: This issue is resolved. Making duplicate of

[jira] [Commented] (HIVE-4633) MR Jobs execution failed.

[ https://issues.apache.org/jira/browse/HIVE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13670338#comment-13670338 ] rohithsharma commented on HIVE-4633: Complete exception trace is as below {nofo

[jira] [Created] (HIVE-4633) MR Jobs execution failed.

rohithsharma created HIVE-4633: -- Summary: MR Jobs execution failed. Key: HIVE-4633 URL: https://issues.apache.org/jira/browse/HIVE-4633 Project: Hive Issue Type: Bug Components: Query

[jira] [Commented] (HIVE-4633) MR Jobs execution failed.

[ https://issues.apache.org/jira/browse/HIVE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13671101#comment-13671101 ] rohithsharma commented on HIVE-4633: It is working fine with patch :-) I dupli

[jira] [Resolved] (HIVE-4633) MR Jobs execution failed.

[ https://issues.apache.org/jira/browse/HIVE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma resolved HIVE-4633. Resolution: Duplicate > MR Jobs execution fai

[jira] [Commented] (HIVE-4633) MR Jobs execution failed.

[ https://issues.apache.org/jira/browse/HIVE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13671114#comment-13671114 ] rohithsharma commented on HIVE-4633: Is this fix is from hadoop? The current patc

[jira] [Commented] (HIVE-4633) MR Jobs execution failed.

[ https://issues.apache.org/jira/browse/HIVE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13671114#comment-13671114 ] rohithsharma commented on HIVE-4633: Is this fix is from hadoop? The current patc

[jira] [Created] (HIVE-4720) Provide Metastore upgrade scripts and default schemas for 0.11.0 version.

rohithsharma created HIVE-4720: -- Summary: Provide Metastore upgrade scripts and default schemas for 0.11.0 version. Key: HIVE-4720 URL: https://issues.apache.org/jira/browse/HIVE-4720 Project: Hive

[jira] [Created] (HIVE-3644) Connection String for ZK need to be constructed for more than one server.

rohithsharma created HIVE-3644: -- Summary: Connection String for ZK need to be constructed for more than one server. Key: HIVE-3644 URL: https://issues.apache.org/jira/browse/HIVE-3644 Project: Hive

[jira] [Commented] (HIVE-3644) Connection String for ZK need to be constructed for more than one server.

[ https://issues.apache.org/jira/browse/HIVE-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13487533#comment-13487533 ] rohithsharma commented on HIVE-3644: I will give patch for this de

[jira] [Updated] (HIVE-3644) Connection String for ZK need to be constructed for more than one server.

[ https://issues.apache.org/jira/browse/HIVE-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3644: --- Attachment: HIVE-3644.1.patch I have attached patch. Please review the patch

[jira] [Created] (HIVE-2526) "lastAceesTime" is always zero when executed through "describe extended " unlike "show table extende like " where lastAccessTime is updated.

ere lastAccessTime is updated. - Key: HIVE-2526 URL: https://issues.apache.org/jira/browse/HIVE-2526 Project: Hive Issue Type: Bug Affects Versions: 0.9.0 Environment: Linux : SuSE 11 SP1 Reporter: rohithshar

[jira] [Created] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.

Affects Versions: 0.8.0 Environment: SuSE11 SP1 Reporter: rohithsharma Priority: Minor In the SQL , "select empno from test t group by t.empno" type of query work fine where as in hive ,below exception "org.apache.hadoop.hive.ql.parse.SemanticEx