[jira] [Assigned] (CARBONDATA-1518) 2. Support creating timeseries while creating main table.

[Akash R Nilugal (Jira)]

     [ 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)