carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kumar vishal (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (CARBONDATA-1518) 2. Support creating timeseries while creating main table.
Date Tue, 21 Nov 2017 18:18:00 GMT

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

Mime
View raw message