Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB