日前有用户反映之前创建的hive表无法删除,登录后台查询发现用户使用了中文作为分区值,下面是解决方法:
1.删表时报错信息
StatementCallback; SQL [DROP TABLE IF EXISTS qcdb.eval_15696_kpi]; Error while processing
statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
(message:Timeout when executing method: drop_table_with_environment_context; 1800028ms exceeds 1800000ms);
nested exception is java.sql.SQLException: Error while processing statement: FAILED: Execution Error,
return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Timeout when executing
method: drop_table_with_environment_context; 1800028ms exceeds 1800000ms)
2.解决办法
解决思路无非就是修改hive元数据表。