I gone through the thread. http://www.mail-archive.com/user@hive.apache.org/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: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 > >
