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

[Akash R Nilugal (Jira)]

Ravindra Pesala created CARBONDATA-1518:
-------------------------------------------

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


User can give timeseries option while creating the main table itself and carbon will create aggregate tables automatically.

{code}
create table sales (order_time timestamp, user_id string, order_id string, status string, quantity int, price bigint) stored by 'carbondata' tblproperties('timeseries_column'='order_time', granularity='hour' 'aggtype'='quanity:sum,max#user_id:count#price:sum,max,min,avg')
{code}

In the above case user created main table and chosen timeseries column, granularity and aggregation types for measures, so carbon generates the aggregation tables automatically for year, month, day and hour level aggregation tables.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)