question Re: S020 data storage error when I run ‘show database’ in Archives of Support Questions (Read Only)

S020 data storage error when I run ‘show database’

wilailak_don — Tue, 16 Oct 2018 11:52:47 GMT

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

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

JonathanSneep — Tue, 16 Oct 2018 13:57:23 GMT

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.html

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

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

wilailak_don — Tue, 16 Oct 2018 15:52:45 GMT

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

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

JonathanSneep — Tue, 16 Oct 2018 16:30:48 GMT

@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