Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

how to check views in hive from hdfs?

avatar
 
1 ACCEPTED SOLUTION

avatar
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

avatar
Super Collaborator

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

avatar
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

Labels