[
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
