Support Questions

Find answers, ask questions, and share your expertise

how to check views in hive from hdfs?

avatar
Contributor
 
1 ACCEPTED SOLUTION

avatar
Super Collaborator

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

avatar
Super Collaborator

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

avatar
Super Collaborator

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