https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220969#M74772 <P>Perhaps some more details could help. Do you want to query the data after you created a table in hive?</P> Tue, 20 Feb 2018 17:08:03 GMT arald 2018-02-20T17:08:03Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220968#M74771 Tue, 20 Feb 2018 17:03:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220968#M74771 wamshikreshna 2018-02-20T17:03:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220969#M74772 <P>Perhaps some more details could help. Do you want to query the data after you created a table in hive?</P> Tue, 20 Feb 2018 17:08:03 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220969#M74772 arald 2018-02-20T17:08:03Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220970#M74773 <P>Hive Views are a logical construct with no associated storage. Neither are they permanent, they exist only for the session.</P><P>I don't think you'll be able to see a directory in hdfs hive warehouse corresponding to the view.</P><P>See below links for reference:</P><P><A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterView" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterView</A></P><P><A href="https://community.hortonworks.com/content/supportkb/48761/what-is-a-hive-view.html" target="_blank">https://community.hortonworks.com/content/supportkb/48761/what-is-a-hive-view.html</A></P> Tue, 20 Feb 2018 19:18:59 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-check-views-in-hive-from-hdfs/m-p/220970#M74773 tsharma 2018-02-20T19:18:59Z