hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amareshwari Sriramadasu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4115) Introduce cube abstraction in hive
Date Tue, 05 Mar 2013 10:45:14 GMT

    [ 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

Mime
View raw message