Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

[CDH 5.4 Upgrade] cannot select from Hive tables

Solved Go to solution
Highlighted

Re: [CDH 5.4 Upgrade] cannot select from Hive tables

Rising Star

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?

 

Highlighted

Re: [CDH 5.4 Upgrade] cannot select from Hive tables

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

Highlighted

Re: [CDH 5.4 Upgrade] cannot select from Hive tables

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.

Highlighted

Re: [CDH 5.4 Upgrade] cannot select from Hive tables

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

 

Don't have an account?
Coming from Hortonworks? Activate your account here