Support Questions

Find answers, ask questions, and share your expertise

[CDH 5.4 Upgrade] cannot select from Hive tables

avatar
Contributor

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

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

 

1 ACCEPTED SOLUTION

avatar
Contributor
If you don't see the problem with tables created after the upgrade, it
could be because something went wrong during upgrade.

View solution in original post

13 REPLIES 13

avatar
Contributor

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?

 

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

avatar
Contributor

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.

avatar
Explorer

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/ -->