Support Questions
Find answers, ask questions, and share your expertise

S020 data storage error when I run ‘show database’

Solved Go to solution
Highlighted

S020 data storage error when I run ‘show database’

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted

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

View solution in original post

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

Highlighted

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

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