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

can we create a facts and dimensional tables in hive? if there is please help me out?

Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Expert Contributor

Hive is considered as the "Hadoop Data Warehouse", so indeed you can create fact and dimensional tables.

Here is a doc giving an introduction on that: http://www.ibm.com/developerworks/library/bd-hivewarehouse/

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:

http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/

http://hortonworks.com/apache/hive/#tutorials

View solution in original post

1 REPLY 1

Expert Contributor

Hive is considered as the "Hadoop Data Warehouse", so indeed you can create fact and dimensional tables.

Here is a doc giving an introduction on that: http://www.ibm.com/developerworks/library/bd-hivewarehouse/

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:

http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/

http://hortonworks.com/apache/hive/#tutorials

View solution in original post