Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of rohithsharmaks@huawei.com
 designates 119.145.14.64 as permitted sender)
Reply-To: <rohithsharmaks@huawei.com>
From: rohithsharma <rohithsharmaks@huawei.com>
To: "'wd'" <wd@wdicc.com>, <user@hive.apache.org>
References: <00b701cd859e$9dcbab70$d9630250$@com>
 <CABexzmgt=4kha79bM-KA4h2uJ0pf1fDDnNF6QFCTVFChQzY6Zw@mail.gmail.com>
In-Reply-To: 
 <CABexzmgt=4kha79bM-KA4h2uJ0pf1fDDnNF6QFCTVFChQzY6Zw@mail.gmail.com>
Subject: RE: Please help : Hive + postgres integration. Drop table query is
 hanging.
Date: Wed, 29 Aug 2012 11:42:34 +0530
Organization: Htipl
Message-ID: <00ce01cd85ad$483a7740$d8af65c0$@com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-index: Ac2FqE7/sqxvZSEoTXGMAVKKSpkg4QABISNg
Content-Language: en-us

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:wd@wdicc.com] 
Sent: Wednesday, August 29, 2012 11:07 AM
To: user@hive.apache.org; rohithsharmaks@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
<rohithsharmaks@huawei.com> 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
>
>