[
https://issues.apache.org/jira/browse/CARBONDATA-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kumar vishal reassigned CARBONDATA-1518:
----------------------------------------
Assignee: kumar vishal
> 2. Support creating timeseries while creating main table.
> ---------------------------------------------------------
>
> Key: CARBONDATA-1518
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1518
> Project: CarbonData
> Issue Type: Sub-task
> Reporter: Ravindra Pesala
> Assignee: kumar vishal
>
> User can give timeseries option while creating the main table itself and
> carbon will create aggregate tables automatically.
> {code}
> CREATE TABLE agg_sales
> STORED BY 'carbondata'
> TBLPROPERTIES ('parent_table'='sales', ‘timeseries_column’=’order_time’,
> ‘granualarity’=’hour’, ‘rollup’ =’quantity:sum, max # user_id: count # price:
> sum, max, min, avg’)
> {code}
> In the above case, user choose timeseries_column, granularity and aggregation
> types for measures, so carbon generates the aggregation tables automatically
> for year, month, day and hour level aggregation tables (totally 4 tables,
> their table name will be prefixed with agg_sales).
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
