[CDH 5.4 Upgrade] cannot select from Hive tables

[#1]

I have upgraded from CDH 5.3 to CDH 5.4.

While executing a simple select statement in Hive it is erroring out:

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

hive> select * from employees;
FAILED: SemanticException Unable to determine if hdfs://<hive-master>:8020:8020/user/hive/warehouse/employees is encrypted:
java.lang.IllegalArgumentException: Wrong FS: hdfs://<hive-master>:8020:8020/user/hive/warehouse/employees, expected: hdfs://<hive-master>:8020

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

[#2]

Thank you!

So , the only way to overcome the issue is to execute the 'alter table...' command!

I have to do that to ALL existing tables!

Any other way?

[#3]

You are welcome. This is the safest method. You may want to come up a
script to do so.

[#4]

BTW, if you can let us know how you did the upgrade, it should help us to find out the root cause of the problem. Thanks.

[#5]

Hi

We have the same problem, we upgraded from Cloudera 5.3.8 to 5.4.8 usign parcels

<!-- fs.default.name, fs.defaultFS = 8020 -->
<!-- hive.metastore.warehouse.dir = /user/hive/warehouse -->
 
<!-- hdfs://hd01:8020:8020/user/hive/warehouse/ -->