2

I get an error when trying to drop a table in hive:

> drop table my_table;

Error:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

I also don't have the related data on the HDFS, what could be the reason for that?

Alg_D
  • 2,242
  • 6
  • 31
  • 63
  • Is table LOCKED, when trying to drop. Pls check table LOCK before running drop command – Manish Saraf Bhardwaj Jun 05 '17 at 05:07
  • when running `UNLOCK TABLE ` I get an error: `FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. unlock Table LockManager not specified`
     – Alg_D Jun 05 '17 at 13:07

1 Answers1

1

You can try to increase the socket timeout:

set hive.metastore.client.socket.timeout=5000
Alex Stanovsky
  • 1,286
  • 1
  • 13
  • 28