hive-dev mailing list archives

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


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

*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.

* 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:
>             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:

View raw message