Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

how to check views in hive from hdfs?

avatar
Frequent Visitor
 
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