Where should Hive Process Installed??

Hi I am using Hive-0.9.0 + Hadoop-2.0.1 with 2 machine. One machine contains say Machine-1 : NameNode, SecondaraNameNode , ResourceManager and Hive Machine-2 : Proxy server, JHS , DataNode and NodeManager. Problem : When I execute Job queries i.e “select count(key) from src” for the ta

RE: Which is the postgres version is compatible for hive-trunk..?

..? Hi, I don't know what exactly was the major changes between 9.0.x and 9.1.x, but when you've a good experience with 9.0.x, use it :) For 9.1.x, it would be great to get a log or stack trace to see whats going wrong there. best, Alex On Nov 6, 2012, at 9:53 AM, rohithsharma wr

RE: Which is the postgres version is compatible for hive-trunk..?

ect: Re: Which is the postgres version is compatible for hive-trunk..? Hey Rohith, last time I used psql was with postgresql-8.4-701.jdbc4.jar, and was working great. But I guess all 8.x version should work. Postgres 9x I personally wouldn't choose. best, Alex On Nov 6, 2012, at 5:29 AM,

Which is the postgres version is compatible for hive-trunk..?

Hi Guys, I am planning to use postgres as metastore with Hive. Can anyone point me which is the postgres version is compatible with Hive..? Regards Rohith Sharma K S

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: user@hive.apache.org Cc: d...@h

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: user@hive.apache.org Cc: d...@h

RE: FAILED: Error in metadata

Hi Exception trace clearly indicates that hive is pointing to default configurations. Make sure your editing hive-site.xml is loaded by hive server. For verifying whether correct configurations are loaded, you enable DEBUG logs. There you can see the loaded configurations. Verify your configu

RE: num_rows is always 0 in statistics

I resolved the issue with following way. Configure "hive.stats.dbconnectionstring=jdbc:derby:;databaseName=/home/TempStore". This works only in single node cluster. Please check HIVE-3324. -Original Message- From: Hiroyuki Yamada [mailto:mogwa...@gmail.com] Sent: Wednesday, August 29

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

. Drop table query is hanging. http://www.mail-archive.com/user@hive.apache.org/msg01293.html Maybe the same error? On Wed, Aug 29, 2012 at 12:27 PM, rohithsharma wrote: > Hi > > > > I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated > postgres with hive. Few q

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

: user@hive.apache.org; rohithsharm...@huawei.com Subject: Re: Please help : Hive + postgres integration. Drop table query is hanging. http://www.mail-archive.com/user@hive.apache.org/msg01293.html Maybe the same error? On Wed, Aug 29, 2012 at 12:27 PM, rohithsharma wrote: > Hi > > >

[no subject]

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

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

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_

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

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

Hive server is shutting down when Invalid Query executed.

Please help me out with this problem, I am blocked here. Thanks & Regards RohithSharma K S *** This e-mail and attachments contain confidential information from HUAWEI, which is intended only fo