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.

S020 data storage error when I run ‘show database’

Solved Go to solution

S020 data storage error when I run ‘show database’

New Contributor

When I ran ‘show database’ on hive view . It thrown error ‘S020 data storage .

1 ACCEPTED SOLUTION

Accepted Solutions

Re: S020 data storage error when I run ‘show database’

@Wil Don

Do you have this error with any other commands? Any chance you could share the full stack trace of the error?
When you encounter this error, do you see any errors on the same timestamp in /var/log/ambari-server/ambari-server.log and the hive view log?
The hive view logs are located here;

In case of hive view 2.0
# /var/log/ambari-server/hive20-view/hive20-view.log
In case of hive view 1.5.0
# /var/log/ambari-server/hive-next-view/hive-view.log

Also, here are some other examples of the same error and resolutions;

https://community.hortonworks.com/questions/8735/hive-view-can-not-used-for-s020-data-storage-error....

https://community.hortonworks.com/content/supportkb/193858/errors020-data-storage-when-migrating-sav...

3 REPLIES 3

Re: S020 data storage error when I run ‘show database’

@Wil Don

Do you have this error with any other commands? Any chance you could share the full stack trace of the error?
When you encounter this error, do you see any errors on the same timestamp in /var/log/ambari-server/ambari-server.log and the hive view log?
The hive view logs are located here;

In case of hive view 2.0
# /var/log/ambari-server/hive20-view/hive20-view.log
In case of hive view 1.5.0
# /var/log/ambari-server/hive-next-view/hive-view.log

Also, here are some other examples of the same error and resolutions;

https://community.hortonworks.com/questions/8735/hive-view-can-not-used-for-s020-data-storage-error....

https://community.hortonworks.com/content/supportkb/193858/errors020-data-storage-when-migrating-sav...

Re: S020 data storage error when I run ‘show database’

@Wil Don Glad to hear your issue got resolved :) If you have a moment please click accept answer so that others will be able to find the solutions quickly when searching for the same issue on the community site

Re: S020 data storage error when I run ‘show database’

New Contributor

I do. Follow by the fiirst document. It can solve my problem . Thank you very much @jonathan sneep