Re: Can't drop table

2014-06-12 Thread Keith Wiley

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 will not get the class not found 
 error :)

Okay, thanks.  Still a pretty weird bug all in all, considering that the 
conclusion of that bug report was to not fix the bug.


Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

Luminous beings are we, not this crude matter.
   --  Yoda




Re: Can't drop table

2014-06-11 Thread Nitin Pawar
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 full path to 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 Wed, Jun 11, 2014 at 2:24 AM, Keith Wiley kwi...@keithwiley.com wrote:

 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, even
 though the paths were correct).

 So I decided to drop the table since it wasn't working...but the serde
 error that is causing these problems to begin with prevents me from
 dropping the table due to a serde-doesn't-exist error.  Yeah, duh, that's
 the problem in the first place.

 This is an acknowledged problem, as indicated here:
 https://issues.apache.org/jira/browse/HIVE-3392
 ...but I don't understand from that page how to get around the problem.
  There is a lengthy discussion, but it's unclear how to actually drop the
 darn table.  In fact, that page suggests the problem is officially
 classified as won't be fixed.

 Note, this problem also prevents me from renaming the table via alter.

 I don't know what to do at this point.  Any ideas?


 
 Keith Wiley kwi...@keithwiley.com keithwiley.com
 music.keithwiley.com

 The easy confidence with which I know another man's religion is folly
 teaches
 me to suspect that my own is also.
--  Mark Twain

 




-- 
Nitin Pawar


Re: Can't drop table

2014-06-11 Thread Keith Wiley
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 table with a serde definition 
 
 then just keep the jar in local filesystem and then in hive console do 
 add jar full path to 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 Wed, Jun 11, 2014 at 2:24 AM, Keith Wiley kwi...@keithwiley.com wrote:
 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, even though 
 the paths were correct).
 
 So I decided to drop the table since it wasn't working...but the serde error 
 that is causing these problems to begin with prevents me from dropping the 
 table due to a serde-doesn't-exist error.  Yeah, duh, that's the problem in 
 the first place.
 
 This is an acknowledged problem, as indicated here:
 https://issues.apache.org/jira/browse/HIVE-3392
 ...but I don't understand from that page how to get around the problem.  
 There is a lengthy discussion, but it's unclear how to actually drop the darn 
 table.  In fact, that page suggests the problem is officially classified as 
 won't be fixed.
 
 Note, this problem also prevents me from renaming the table via alter.
 
 I don't know what to do at this point.  Any ideas?
 
 
 Keith Wiley kwi...@keithwiley.com keithwiley.com
 music.keithwiley.com
 
 The easy confidence with which I know another man's religion is folly teaches
 me to suspect that my own is also.
--  Mark Twain
 
 
 
 
 
 -- 
 Nitin Pawar



Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

What I primarily learned in grad school is how much I *don't* know.
Consequently, I left grad school with a higher ignorance to knowledge ratio than
when I entered.
   --  Keith Wiley




Re: Can't drop table

2014-06-11 Thread Keith Wiley
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 definition 
 
 then just keep the jar in local filesystem and then in hive console do 
 add jar full path to 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 Wed, Jun 11, 2014 at 2:24 AM, Keith Wiley kwi...@keithwiley.com wrote:
 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, even though 
 the paths were correct).
 
 So I decided to drop the table since it wasn't working...but the serde error 
 that is causing these problems to begin with prevents me from dropping the 
 table due to a serde-doesn't-exist error.  Yeah, duh, that's the problem in 
 the first place.
 
 This is an acknowledged problem, as indicated here:
 https://issues.apache.org/jira/browse/HIVE-3392
 ...but I don't understand from that page how to get around the problem.  
 There is a lengthy discussion, but it's unclear how to actually drop the darn 
 table.  In fact, that page suggests the problem is officially classified as 
 won't be fixed.
 
 Note, this problem also prevents me from renaming the table via alter.
 
 I don't know what to do at this point.  Any ideas?
 
 
 Keith Wiley kwi...@keithwiley.com keithwiley.com
 music.keithwiley.com
 
 The easy confidence with which I know another man's religion is folly teaches
 me to suspect that my own is also.
--  Mark Twain
 
 
 
 
 
 -- 
 Nitin Pawar



Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

It's a fine line between meticulous and obsessive-compulsive and a slippery
rope between obsessive-compulsive and debilitatingly slow.
   --  Keith Wiley




Re: Can't drop table

2014-06-11 Thread Edward Capriolo
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 AM, Keith Wiley kwi...@keithwiley.com wrote:

 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 definition
 
  then just keep the jar in local filesystem and then in hive console do
  add jar full path to 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 Wed, Jun 11, 2014 at 2:24 AM, Keith Wiley kwi...@keithwiley.com
 wrote:
  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, even though the paths were correct).
 
  So I decided to drop the table since it wasn't working...but the serde
 error that is causing these problems to begin with prevents me from
 dropping the table due to a serde-doesn't-exist error.  Yeah, duh, that's
 the problem in the first place.
 
  This is an acknowledged problem, as indicated here:
  https://issues.apache.org/jira/browse/HIVE-3392
  ...but I don't understand from that page how to get around the problem.
  There is a lengthy discussion, but it's unclear how to actually drop the
 darn table.  In fact, that page suggests the problem is officially
 classified as won't be fixed.
 
  Note, this problem also prevents me from renaming the table via alter.
 
  I don't know what to do at this point.  Any ideas?
 
 
 
  Keith Wiley kwi...@keithwiley.com keithwiley.com
 music.keithwiley.com
 
  The easy confidence with which I know another man's religion is folly
 teaches
  me to suspect that my own is also.
 --  Mark Twain
 
 
 
 
 
 
  --
  Nitin Pawar



 
 Keith Wiley kwi...@keithwiley.com keithwiley.com
 music.keithwiley.com

 It's a fine line between meticulous and obsessive-compulsive and a
 slippery
 rope between obsessive-compulsive and debilitatingly slow.
--  Keith Wiley

 




Re: Can't drop table

2011-04-28 Thread wd
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, and hung at this sql.

 16385 | hive_metadb |8259 |16386 | hive| ALTER TABLE IDXS ADD
CONSTRAINT IDXS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (
SD_ID) INITIALLY DEFERRED  | t   | 2011-04-28 13:54:16.384769+08 |
2011-04-28 13:54:16.404204+08 | 2011-04-28 13:54:01.784839+08 | 12
7.0.0.1   |   37438

But there is no table named IDXS exists. So I think this problem is cased
by these missing tables. Then I migrate a upgrade sql file from mysql, and
upgrade my postgress, the problem solved.

The attachment is the upgrade SQLs to run.

2011/1/6 wd w...@wdicc.com

 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.

CREATE TABLE IDXS (
  INDEX_ID bigint NOT NULL,
  CREATE_TIME int NOT NULL,
  DEFERRED_REBUILD bit(1) NOT NULL,
  INDEX_HANDLER_CLASS varchar(256) DEFAULT NULL,
  INDEX_NAME varchar(128) DEFAULT NULL,
  INDEX_TBL_ID bigint DEFAULT NULL,
  LAST_ACCESS_TIME int NOT NULL,
  ORIG_TBL_ID bigint DEFAULT NULL,
  SD_ID bigint DEFAULT NULL,
  PRIMARY KEY (INDEX_ID),
  CONSTRAINT UNIQUEINDEX UNIQUE (INDEX_NAME,ORIG_TBL_ID),
  CONSTRAINT IDXS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID),
  CONSTRAINT IDXS_FK2 FOREIGN KEY (INDEX_TBL_ID) REFERENCES TBLS (TBL_ID),
  CONSTRAINT IDXS_FK3 FOREIGN KEY (ORIG_TBL_ID) REFERENCES TBLS (TBL_ID)
) ;

create index IDXS_FK1 on IDXS using btree (SD_ID);
create index IDXS_FK2 on IDXS using btree (INDEX_TBL_ID);
create index IDXS_FK3 on IDXS using btree (ORIG_TBL_ID);


CREATE TABLE INDEX_PARAMS (
  INDEX_ID bigint NOT NULL,
  PARAM_KEY varchar(256) NOT NULL,
  PARAM_VALUE varchar(767) DEFAULT NULL,
  PRIMARY KEY (INDEX_ID,PARAM_KEY),
  CONSTRAINT INDEX_PARAMS_FK1 FOREIGN KEY (INDEX_ID) REFERENCES IDXS (INDEX_ID)
);


CREATE TABLE ROLES (
  ROLE_ID bigint NOT NULL,
  CREATE_TIME int NOT NULL,
  OWNER_NAME varchar(128) DEFAULT NULL,
  ROLE_NAME varchar(128) DEFAULT NULL,
  PRIMARY KEY (ROLE_ID),
  CONSTRAINT ROLEENTITYINDEX UNIQUE (ROLE_NAME)
) ;


CREATE TABLE ROLE_MAP (
  ROLE_GRANT_ID bigint NOT NULL,
  ADD_TIME int NOT NULL,
  GRANT_OPTION smallint NOT NULL,
  GRANTOR varchar(128) DEFAULT NULL,
  GRANTOR_TYPE varchar(128) DEFAULT NULL,
  PRINCIPAL_NAME varchar(128) DEFAULT NULL,
  PRINCIPAL_TYPE varchar(128) DEFAULT NULL,
  ROLE_ID bigint DEFAULT NULL,
  PRIMARY KEY (ROLE_GRANT_ID),
  CONSTRAINT USERROLEMAPINDEX UNIQUE (PRINCIPAL_NAME,ROLE_ID,GRANTOR,GRANTOR_TYPE),
  CONSTRAINT ROLE_MAP_FK1 FOREIGN KEY (ROLE_ID) REFERENCES ROLES (ROLE_ID)
) ;

CREATE TABLE GLOBAL_PRIVS (
  USER_GRANT_ID bigint NOT NULL,
  CREATE_TIME int NOT NULL,
  GRANT_OPTION smallint NOT NULL,
  GRANTOR varchar(128) DEFAULT NULL,
  GRANTOR_TYPE varchar(128) DEFAULT NULL,
  PRINCIPAL_NAME varchar(128) DEFAULT NULL,
  PRINCIPAL_TYPE varchar(128) DEFAULT NULL,
  USER_PRIV varchar(128) DEFAULT NULL,
  PRIMARY KEY (USER_GRANT_ID),
  CONSTRAINT GLOBALPRIVILEGEINDEX UNIQUE (PRINCIPAL_NAME,PRINCIPAL_TYPE,USER_PRIV,GRANTOR,GRANTOR_TYPE)
) ;

CREATE TABLE DB_PRIVS (
  DB_GRANT_ID bigint NOT NULL,
  CREATE_TIME int NOT NULL,
  DB_ID bigint DEFAULT NULL,
  GRANT_OPTION smallint NOT NULL,
  GRANTOR varchar(128) DEFAULT NULL,
  GRANTOR_TYPE varchar(128) DEFAULT NULL,
  PRINCIPAL_NAME varchar(128) DEFAULT NULL,
  PRINCIPAL_TYPE varchar(128) DEFAULT NULL,
  DB_PRIV varchar(128) DEFAULT NULL,
  PRIMARY KEY (DB_GRANT_ID),
  CONSTRAINT DBPRIVILEGEINDEX UNIQUE (DB_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,DB_PRIV,GRANTOR,GRANTOR_TYPE),
  CONSTRAINT DB_PRIVS_FK1 FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID)
) ;

CREATE TABLE TBL_PRIVS (
  TBL_GRANT_ID bigint NOT NULL,
  CREATE_TIME int NOT NULL,
  GRANT_OPTION smallint NOT NULL,
  GRANTOR varchar(128) DEFAULT NULL,
  GRANTOR_TYPE varchar(128) DEFAULT NULL,
  PRINCIPAL_NAME varchar(128) DEFAULT NULL,
  PRINCIPAL_TYPE varchar(128) DEFAULT NULL,
  TBL_PRIV varchar(128) DEFAULT NULL,
  TBL_ID bigint DEFAULT NULL,
  PRIMARY KEY (TBL_GRANT_ID),
  CONSTRAINT TBL_PRIVS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID)
) ;
  
create index TABLEPRIVILEGEINDEX on TBL_PRIVS using btree (TBL_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_PRIV,GRANTOR,GRANTOR_TYPE);

CREATE TABLE TBL_COL_PRIVS (
  TBL_COLUMN_GRANT_ID bigint NOT NULL,
  COLUMN_NAME varchar(128) DEFAULT NULL,
  CREATE_TIME int NOT NULL,
  GRANT_OPTION smallint NOT NULL,
  GRANTOR varchar(128) DEFAULT NULL,
  GRANTOR_TYPE varchar(128) DEFAULT NULL,
  PRINCIPAL_NAME varchar(128) DEFAULT NULL,
  PRINCIPAL_TYPE varchar(128) DEFAULT NULL,
  TBL_COL_PRIV varchar(128) DEFAULT NULL,

RE: Can't drop table

2011-02-03 Thread Tali K

We have a similar problem with not being able to drop tables, using Hive 0.6 
and Hadoop 20.0 along with Postgres.  Can you share with us the schema you 
created?  We are wondering if the schema that was automatically created in our 
case is somehow incomplete.
 
Thanks,
Tali
 


Date: Mon, 17 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 remember Hive could 
not create metastore schema automatically with MySQL, Innodb and UTF-8 encoding 
environment. so I switched PostgreSQL for metastore.


Actually, it works with PostgreSQL. but first time when one run hive cli with 
PostgreSQL, there are problems on creating metastore schema because JDO does 
not work well with PostgreSQL. I created the metastore schema manually. after 
that, everything works fine.


Regards,


- Youngwoo


2011/1/17 Edward Capriolo edlinuxg...@gmail.com

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
data stores (M$ SQL server) however, people have run into issues with
them. Databases other then derby and mysql 'should work' but are
generally untested.

Edward




On Mon, Jan 17, 2011 at 2:52 AM, wd w...@wdicc.com wrote:
 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 w...@wdicc.com

 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

2011-01-17 Thread Edward Capriolo
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
data stores (M$ SQL server) however, people have run into issues with
them. Databases other then derby and mysql 'should work' but are
generally untested.

Edward

On Mon, Jan 17, 2011 at 2:52 AM, wd w...@wdicc.com wrote:
 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 w...@wdicc.com

 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

2011-01-17 Thread Jamie Cockrill
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.04)
Postgres: 8.4.4
Postgres JDBC driver: postgresql-8.4.701-jdbc.jar
Hadoop: 0.20.2+320 (Cloudera CDH3b2)
Hive: 0.5.0+20 (Cloudera CDH3b2)

Thanks,

Jamie

On 17 January 2011 13:13, Edward Capriolo edlinuxg...@gmail.com wrote:

 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
 data stores (M$ SQL server) however, people have run into issues with
 them. Databases other then derby and mysql 'should work' but are
 generally untested.

 Edward

 On Mon, Jan 17, 2011 at 2:52 AM, wd w...@wdicc.com wrote:
  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 w...@wdicc.com
 
  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

2011-01-17 Thread 김영우
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.

Actually, it works with PostgreSQL. but first time when one run hive cli
with PostgreSQL, there are problems on creating metastore schema because JDO
does not work well with PostgreSQL. I created the metastore schema manually.
after that, everything works fine.

Regards,

- Youngwoo

2011/1/17 Edward Capriolo edlinuxg...@gmail.com

 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
 data stores (M$ SQL server) however, people have run into issues with
 them. Databases other then derby and mysql 'should work' but are
 generally untested.

 Edward

 On Mon, Jan 17, 2011 at 2:52 AM, wd w...@wdicc.com wrote:
  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 w...@wdicc.com
 
  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

2011-01-16 Thread wd
Oh, WTF
It worked now, But I've done nothing!

在 2011年1月17日 下午3:14,wd w...@wdicc.com写道:

 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 w...@wdicc.com

 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: Executing listMPartitions

 Will hung at here.

 I've tried derby metadata, it worked.


 2011/1/6 Carl Steinbach c...@cloudera.com

 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 w...@wdicc.com wrote:

 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

2011-01-16 Thread wd
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 w...@wdicc.com

 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

2011-01-06 Thread wd
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: Executing listMPartitions

Will hung at here.

I've tried derby metadata, it worked.


2011/1/6 Carl Steinbach c...@cloudera.com

 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 w...@wdicc.com wrote:

 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.