https://community.cloudera.com/t5/Archives-of-Support-Questions/can-we-create-a-facts-and-dimensional-tables-in-hive-if/m-p/145486#M28191 Fri, 13 May 2016 10:54:30 GMT omkarmotoe 2016-05-13T10:54:30Z https://community.cloudera.com/t5/Archives-of-Support-Questions/can-we-create-a-facts-and-dimensional-tables-in-hive-if/m-p/145486#M28191 Fri, 13 May 2016 10:54:30 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/can-we-create-a-facts-and-dimensional-tables-in-hive-if/m-p/145486#M28191 omkarmotoe 2016-05-13T10:54:30Z https://community.cloudera.com/t5/Archives-of-Support-Questions/can-we-create-a-facts-and-dimensional-tables-in-hive-if/m-p/145487#M28192 <P>Hive is considered as the "Hadoop Data Warehouse", so indeed you can create fact and dimensional tables.</P><P>Here is a doc giving an introduction on that: <A href="http://www.ibm.com/developerworks/library/bd-hivewarehouse/">http://www.ibm.com/developerworks/library/bd-hivewarehouse/</A></P><P>If you are new to Hive, I recommend you also to start your journey by downloading the Hortonworks Sandbox and looking at the tutorials we have:</P><P><A href="http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/">http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/</A></P><P><A href="http://hortonworks.com/apache/hive/#tutorials">http://hortonworks.com/apache/hive/#tutorials</A></P> Fri, 13 May 2016 13:41:05 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/can-we-create-a-facts-and-dimensional-tables-in-hive-if/m-p/145487#M28192 sluangsay 2016-05-13T13:41:05Z