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.

how to check views in hive from hdfs?

Solved Go to solution
Highlighted

how to check views in hive from hdfs?

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: how to check views in hive from hdfs?

Expert Contributor

Hive Views are a logical construct with no associated storage. Neither are they permanent, they exist only for the session.

I don't think you'll be able to see a directory in hdfs hive warehouse corresponding to the view.

See below links for reference:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/Al...

https://community.hortonworks.com/content/supportkb/48761/what-is-a-hive-view.html

View solution in original post

2 REPLIES 2
Highlighted

Re: how to check views in hive from hdfs?

Super Collaborator

Perhaps some more details could help. Do you want to query the data after you created a table in hive?

Highlighted

Re: how to check views in hive from hdfs?

Expert Contributor

Hive Views are a logical construct with no associated storage. Neither are they permanent, they exist only for the session.

I don't think you'll be able to see a directory in hdfs hive warehouse corresponding to the view.

See below links for reference:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/Al...

https://community.hortonworks.com/content/supportkb/48761/what-is-a-hive-view.html

View solution in original post

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