hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject RE: drop table command hang
Date Wed, 11 Mar 2015 07:06:28 GMT
Have you truncated the table before dropping it? I

 

Truncate table <table_name>

Drop table <rable_name>

 

Mich Talebzadeh

 

http://talebzadehmich.wordpress.com

 

Publications due shortly:

Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache

 

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Ltd,
its subsidiaries or their employees, unless expressly so stated. It is the responsibility
of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd,
its subsidiaries nor their employees accept any responsibility.

 

From: Jeff Zhang [mailto:zjffdu@gmail.com] 
Sent: 11 March 2015 06:56
To: user@hive.apache.org
Subject: drop table command hang

 

I invoke a drop table command and it hangs there. Here's the log. I am using mysql and I can
invoke describe command and create table through mysql console, so I assume mysql works properly.
Can anyone help this ? Thanks

 

 

 

2015-03-11 14:48:09,441 INFO  [main]: ql.Driver (Driver.java:checkConcurrency(161)) - Concurrency
mode is disabled, not creating a lock manager

2015-03-11 14:48:09,441 INFO  [main]: log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) -
<PERFLOG method=Driver.execute from=org.apache.hadoop.hive.ql.Driver>

2015-03-11 14:48:09,441 INFO  [main]: ql.Driver (Driver.java:execute(1321)) - Starting command:
drop table student_bucketed_s1

2015-03-11 14:48:09,441 INFO  [main]: log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG
method=TimeToSubmit start=1426056489421 end=1426056489441 duration=20 from=org.apache.hadoop.hive.ql.Driver>

2015-03-11 14:48:09,442 INFO  [main]: log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) -
<PERFLOG method=runTasks from=org.apache.hadoop.hive.ql.Driver>

2015-03-11 14:48:09,442 INFO  [main]: log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) -
<PERFLOG method=task.DDL.Stage-0 from=org.apache.hadoop.hive.ql.Driver>

2015-03-11 14:48:09,442 INFO  [main]: ql.Driver (Driver.java:launchTask(1640)) - Starting
task [Stage-0:DDL] in serial mode

2015-03-11 14:48:09,442 INFO  [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(743))
- 0: get_table : db=default tbl=student_bucketed_s1

2015-03-11 14:48:09,443 INFO  [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(368))
- ugi=jzhang  ip=unknown-ip-addr  cmd=get_table : db=default tbl=student_bucketed_s1

2015-03-11 14:48:09,458 INFO  [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(743))
- 0: get_table : db=default tbl=student_bucketed_s1

2015-03-11 14:48:09,458 INFO  [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(368))
- ugi=jzhang  ip=unknown-ip-addr  cmd=get_table : db=default tbl=student_bucketed_s1

2015-03-11 14:48:09,474 INFO  [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(743))
- 0: drop_table : db=default tbl=student_bucketed_s1

2015-03-11 14:48:09,474 INFO  [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(368))
- ugi=jzhang  ip=unknown-ip-addr  cmd=drop_table : db=default tbl=student_bucketed_s1

 




 

-- 

Best Regards

Jeff Zhang


Mime
View raw message