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

how to check views in hive from hdfs?

 
1 ACCEPTED SOLUTION

Accepted Solutions

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

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?

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