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:w...@wdicc.com] Sent: Wednesday, August 29, 2012 11:07 AM To: 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 <rohithsharm...@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 > >
