Hi, so I ran into the same exception on a HDP 3.1.0 for my own external tables, as well as the default and sys tables of hive. My value for fs.defaultFS was hdfs://my_host.com:8020 Using ALTER TABLE ... SET LOCATION did not work, since it needs the original location of the table to change its location, which of course isn't possible. I then went into the Hive Metastore to change the location of the tables manually. To do this, two Metastore tables are necessary: hive.DBS stores the location of databases in column DB_LOCATION_URI hive.SDS stores the location of tables in column LOCATION I then updated those values to only containing the port once using e.g. "UPDATE SDS SET LOCATION = 'example' WHERE SD_ID = 1" After that I changed fs.defaultFS to hdfs://my_host.com (without the port number) After that everything worked out. fs.defaultFS not containing a port number didn't seem to break anything, but be aware.
... View more