I have created one table in HIve using 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' and given HDFS location with old namenode
and now i changed the Namenode and enabled HA. Table become inaccessible and i am also not able to drop. It is thrwoing below exception
hive> drop table test;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: Wrong FS: 'hdfs:/oldnamenode:8020/data/Personal/, expected: hdfs://nameservice1)
I am using mysql to store hive metadata and i tried to find out these properties in metadata tables to manually update the namenode to nameservice1 but couldnt find related properties in the meta tables.
Anyone have any idea on this ?
Any help is appericiated.
Metadata looks fine. Other tables are still accessible like hbase external table and managed tables.
This table is having the issue because it required static values at the time of table creation.
I passed the older namenode and now when i am trying to query this table, it is giving wrong FS.
Is there any way that i can change older namenode to nameservice1 by updating metadata table record ?
I tried finding these values in Hive meta tables but couldnt manage to find it. Even not able to drop this table.