Posts: 27
Registered: ‎09-14-2016

Cannot drop table in hive - CDH 5.7.1 error ...message:java.lang.IllegalArgumentException: Wrong FS:

Can someone guide or help me out?


I have CMgr 5.7.1, and this is a CDH-HA cluster.  When I ssh into the gateway server, I invoke hive as shown below and tried to drop unused table without much success.  Earlier I had done a manual failover of NN, and not sure if this could have caused this problem. Seems like the tables are there 


$sudo -u hdfs hive
2016-09-30 18:04:33,499 WARN [main] mapreduce.TableMapReduceUtil: The hbase-prefix-tree module jar containing PrefixTreeCodec is not present. Continuing without it.

Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.7.1-1.cdh5.7.1.p0.11/jars/hive-common-1.1.0-cdh5.7.1.jar!/
WARNING: Hive CLI is deprecated and migration to Beeline is recommended.


hive> show tables;
customer_nation  --> cannot drop this table
customer_region  --> cannot drop this table
supplier_nation    --> cannot drop this table
supplier_region    --> cannot drop this table
Time taken: 0.534 seconds, Fetched: 4 row(s)


hive> drop table customer_nation ;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: Wrong FS: hdfs://nameservice1:8020/user/hive/warehouse/customer_nation, expected: hdfs://nameservice1)


---------- Following when check in the hdfs system, the hive above tables does not exists --------

sudo -u hdfs hadoop fs -ls /user/hive/warehouse/    <-- check in hdfs to see if tables footprint exists and they are not
Found 3 items
drwxrwxrwt - centos hive 0 2016-09-23 18:24 /user/hive/warehouse/atest_30884
drwxrwxrwt - hdfs hive 0 2016-09-30 05:26 /user/hive/warehouse/foo
drwxrwxrwt - hdfs hive 0 2016-09-29 04:25 /user/hive/warehouse/newtesttable

Posts: 777
Registered: ‎05-16-2016

Re: Cannot drop table in hive - CDH 5.7.1 error ...message:java.lang.IllegalArgumentException: Wrong

its problem with the hive cache 

play around with this parameter in the file, you should be able to resolve it . 


hive.metastore-cache-ttl = 20s
hive.metastore-refresh-interval = 10s