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

Can't drop table

I tried to create a table that would use a csv serde. There were various problems with it, primarily in that I couldn't figure out how to specify the path to the serde (whether I indicate the serde location either locally or on HDFS) there were subsequent errors about not finding the serde, eve

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"

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

2011/1/6 wd > >> > >> hi, > >> > >> I've setup a single node hadoop and hive. And can create table in hive, > >> but can't drop table, hive cli will hang there, nothing more infos. > >> > >> hive-0.6.0-bin > >> hadoop-0.20.2 > >> jre1.6.0_23 > >> postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-701.jdbc4.jar) > >> pgsql 9.0.2 > >> > >> How to find what's wrong happed? thx. > > > > >

Re: Can't drop table

rst > > 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 had

Re: Can't 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

hadoop and hive. And can create table in hive, but > can't drop table, hive cli will hang there, nothing more infos. > > hive-0.6.0-bin > hadoop-0.20.2 > jre1.6.0_23 > postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-701.jdbc4.jar) > pgsql 9.0.2 > > How to find what's wrong happed? thx. >

Re: Can't drop table

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 >>> >>> Thank

Re: Can't drop table

ng info try >> >> hive -hiveconf hive.root.logger=DEBUG,console >> >> Thanks. >> >> Carl >> >> On Thu, Jan 6, 2011 at 1:29 AM, wd wrote: >> >>> hi, >>> >>> I've setup a single node hadoop and hive. And can create ta

Re: Can't drop table

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: > >> hi, >> >> I've setup a single node hadoop and hive. And can create table in hive, >> but c

Re: Can't drop table

: > hi, > > I've setup a single node hadoop and hive. And can create table in hive, but > can't drop table, hive cli will hang there, nothing more infos. > > hive-0.6.0-bin > hadoop-0.20.2 > jre1.6.0_23 > postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-70

Can't drop table

hi, I've setup a single node hadoop and hive. And can create table in hive, but can't drop table, hive cli will hang there, nothing more infos. hive-0.6.0-bin hadoop-0.20.2 jre1.6.0_23 postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-701.jdbc4.jar) pgsql 9.0.2 How to find wh