05-31-2018 01:37 AM - edited 05-31-2018 01:56 AM
I just migrated my namenode and somehow impala command gave me an error after that, I have updated the hive namenode and restarted Impala service.
ERROR: AnalysisException: Failed to load metadata for table: 'table_name'
CAUSED BY: TableLoadingException: Failed to load metadata for table: table_name
CAUSED BY: CatalogException: Error initializing partition
CAUSED BY: IOException: Incomplete HDFS URI, no host: hdfs://host:8020:8020/user/hive/warehouse/database_name.db/table_name
I have also check the DBS table in hive database, there is nothing wrong, all the URI entries are showing only 1 8020 instead of 2.
Anyone experience this before?