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.
I gone through the thread.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg01293.html

My problem resolved when I create metastore schema manually.

I have few doubts here
1. For derby , we need not to create metastore schema explicitely where as
for postgres drop table query worked when metastore schema is created
mannuly. Why it is like this..? Any JDO interface 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
>
>