Re: Can't drop table

On Jun 11, 2014, at 13:15 , Edward Capriolo wrote: > "There is a lengthy discussion, but it's unclear how to actually drop the > darn table. In fact, that page" > > Dumb work around: > > You could go directly to mysql and delete the table... > > Or make a serde with that name just so you wi

Re: Can't drop table

"There is a lengthy discussion, but it's unclear how to actually drop the darn table. In fact, that page" Dumb work around: You could go directly to mysql and delete the table... Or make a serde with that name just so you will not get the class not found error :) On Wed, Jun 11, 2014 at 9:59

Re: Can't drop table

That's beside the point. The question is, why can't I drop the table? There is no excuse for not dropping a table just because some serde can't be found. It shouldn't operate that way at all. Thanks. On Jun 10, 2014, at 23:33 , Nitin Pawar wrote: > if you have added a table with a serde def

Re: Can't drop table

Yeah, that doesn't work. Hive gives clear failure-to-find serdes when running queries against such a table. The serde unquestionably resides at the local file system path I specified to "add jar". It just doesnt' work. On Jun 10, 2014, at 23:33 , Nitin Pawar wrote: > if you have added a tabl

Re: Can't drop table

if you have added a table with a serde definition then just keep the jar in local filesystem and then in hive console do add jar ; this should make your serde available to table and you should be able to drop the table then. I just tried above steps and it works for my json based tables. On We

Re: Can't drop table

Seems I found the reason. I'm try to upgrade my hive-0.5.0 to hive-0.7 today, and executed the sql in upgrade directory, migrate conf to new hive. Then found that can't drop table again. When drop a table, I found there is a connection from hive try to do something on "IDXS" table in postgress,

RE: Can't drop table

Jan 2011 22:46:44 +0900 Subject: Re: Can't drop table From: warwit...@gmail.com To: user@hive.apache.org CC: hive-u...@hadoop.apache.org Hi All, I'm using PostgreSQL for Hive metastore in production. As far as I know MySQL has limitations on constraints in unicode environments. I rem

Re: Can't drop table

Hi All, I'm using PostgreSQL for Hive metastore in production. As far as I know MySQL has limitations on constraints in unicode environments. I remember Hive could not create metastore schema automatically with MySQL, Innodb and UTF-8 encoding environment. so I switched PostgreSQL for metastore.

Re: Can't drop table

Hi all, We use postgres as a metastore for Hive and haven't come across any problems. The postgres driver jar is: postgresql-8.4.701-jdbc.jar. We use the version of hive that comes out of Cloudera's CDH3b2, which I believe is some variant of Hive 0.5.0. Java: HotSpot 1.6.0_20 OS: Ubuntu Lucid (10

Re: Can't drop table

You are the first person I have heard of using postgres. I commend you for not succumbing to the social pressure and just installing mysql. However I would advice succumbing to the social pressure and using either derby or mysql. The reason I say this is because jpox "has support" for a number of

Re: Can't drop table

Finally I found, when use hive-0.5.0-bin, 'drop table' will hung at first time, after Ctrl-c kill the client, and run hive again, it can successfully drop the table. When use hive-0.6.0-bin, it will always hung there. 2011/1/6 wd > hi, > > I've setup a single node hadoop and hive. And can create

Re: Can't drop table

Oh, WTF It worked now, But I've done nothing! 在 2011年1月17日 下午3:14，wd 写道： > I've tried in postgresql-8.1.22-1.el5_5.1, and tried hive-0.5-bin，the > problem still there... > Also tried postgresql-8.4-702.jdbc4.jar, anyone else have this problem ? > > 2011/1/6 wd > > 11/01/06 18:20:14 INFO metastor

Re: Can't drop table

I've tried in postgresql-8.1.22-1.el5_5.1, and tried hive-0.5-bin，the problem still there... Also tried postgresql-8.4-702.jdbc4.jar, anyone else have this problem ? 2011/1/6 wd > 11/01/06 18:20:14 INFO metastore.HiveMetaStore: 0: get_table : db=default > tbl=t1 > 11/01/06 18:20:14 INFO metastor

Re: Can't drop table

11/01/06 18:20:14 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=t1 11/01/06 18:20:14 INFO metastore.HiveMetaStore: 0: drop_table : db=default tbl=t1 11/01/06 18:20:14 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=t1 11/01/06 18:20:14 DEBUG metastore.ObjectStore: Executin

Re: Can't drop table

The best first step is enable logging to the console and then try the operation again through the CLI: hive -hiveconf hive.root.logger=INFO,console or if you want even more logging info try hive -hiveconf hive.root.logger=DEBUG,console Thanks. Carl On Thu, Jan 6, 2011 at 1:29 AM, wd wrote: