Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: Please help : Hive + postgres integration. Drop table query is hanging.


Copy link to this message
-
RE: Please help : Hive + postgres integration. Drop table query is hanging.
Yes.. Problem(ERROR) is same.

My scenario is I am installing fresh cluster with Hive-0.9.0 +
postgres-9.0.7

I am not doing any upgrade for metastore. Still I am facing this problem.
-----Original Message-----
From: wd [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2012 11:07 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Please help : Hive + postgres integration. Drop table query is
hanging.

http://www.mail-archive.com/[EMAIL PROTECTED]/msg01293.html
Maybe the same error?

On Wed, Aug 29, 2012 at 12:27 PM, rohithsharma
<[EMAIL PROTECTED]> wrote:
> 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.LazySimpleSerDe: LazySimpleSerDe initialized
>
> with: columnNames=[a] columnTypes=[int] separator=[[B@e4600c0]
nullstring=\N
>
> lastColumnTakesRest=false
>
> 08/12/28 06:02:09 INFO metastore.HiveMetaStore: 0: get_table : db=default
>
> tbl=erer
>
> 08/12/28 06:02:09 INFO metastore.HiveMetaStore: 0: drop_table : db=default
>
> tbl=erer
>
> 08/12/28 06:02:09 INFO metastore.HiveMetaStore: 0: get_table : db=default
>
> tbl=erer
>
> *08/12/28 06:02:09 DEBUG metastore.ObjectStore: Executing listMPartitions
>
>
>
>
>
> I find there is no bug in open source . Is there any way to overcome this
> problem please help me.
>
>
>
>
>
>
>
> Regards
>
> Rohith Sharma K S
>
>