S020 data storage error when I run ‘show database’

[#1]

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

[#2 · Accepted solution]

@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]

@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

[#4]

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