hive 删除报错
> drop table bid_resp_2017_01_30_tmp;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: Wrong FS: hdfs://iZ2zebpej4l4qvbno2555xZ:9000/user/hive/warehouse/bid_resp_2017_01_30_tmp, expected: hdfs://iZ2ze1m1w392hbsphqo5z3Z:9000)
hive>
> alter table bid_resp_2017_01_30_tmp set location 'hdfs://iZ2ze1m1w392hbsphqo5z3Z:9000/';
OK
Time taken: 0.33 seconds
hive>
> drop table bid_resp_2017_01_30_tmp;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.UnknownHostException: iZ2zebpej4l4qvbno2555xZ)
hive>
在root超级用户下添加ip
cd /etc
192.168.10.28 iZ2zebpej4l4qvbno2555xZ #然后:x保存
注释:192.168.10.28为内网地址
Hive> drop table bid_resp_2017_01_30_tmp;
OK
Time taken: 0.544 seconds
hive>