[CARBONDATA-1518] 2. Support creating timeseries while creating main table.

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Assignee: Kumar Vishal
• Reporter: Ravindra Pesala
• Created: 27/Sep/17 09:52
• Updated: 26/Jan/18 07:00
• Resolved: 07/Dec/17 02:59

Description

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

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

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

Issue Links

• links to: GitHub Pull Request #1565