hive Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException

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>