Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 5 Mar 2013 10:45:14 +0000 (UTC)
From: "Amareshwari Sriramadasu (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12635308.1362478732986.382454.1362480314666@arcas>
In-Reply-To: <JIRA.12635308.1362478732986@arcas>
References: <JIRA.12635308.1362478732986@arcas>
Subject: [jira] [Commented] (HIVE-4115) Introduce cube abstraction in hive
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13593296#comment-13593296 ] 

Amareshwari Sriramadasu commented on HIVE-4115:
-----------------------------------------------

Logical model :
-----------------
*Cube* :
* A cube is a set of dimensions and measures in a particular subject. 
* A measure is a quantity that you are interested in measuring.
* A dimension is an attribute, or set of attributes, by which you can divide measures into sub-categories. 

*Fact Tables* :
* Cube will have fact tables associated with it.
* A fact table would have subset of measures and dimensions.
* Fact tables can be rolled at any dimension and time.

*Dimensions* :
* The cube dimension can refer to a dimension table 
* The cube dimension can have hierarchy of elements.

*Dimension tables* :
* A table with list of columns.
* The table can have references to other dimension tables.
* The dimension tables can be shared across cubes.

*Storage*:
* Fact or dimension table can have storages associated with it.

Storage Model :
---------------------
A physical table will be created in hive metastore for each fact, per storage per rollup.

                
> Introduce cube abstraction in hive
> ----------------------------------
>
>                 Key: HIVE-4115
>                 URL: https://issues.apache.org/jira/browse/HIVE-4115
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Amareshwari Sriramadasu
>
> We would like to define a cube abstraction so that user can query at cube layer and do not know anything about storage and rollups. 
> Will describe the model more in following comments.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira