[ https://issues.apache.org/jira/browse/CARBONDATA-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravindra Pesala updated CARBONDATA-1517: ---------------------------------------- Description: User should add aggregation tables with following syntax {code} CREATE TABLE agg_sales STORED BY 'carbondata' TBLPROPERTIES ('parent_table'='sales') AS SELECT user_id, sum(quantity), avg(price) FROM sales GROUP BY user_id {code} was: User should add aggregation tables with following syntax {code} create table agg_sales (order_time timestamp, user_id string, quantity int, price bigint) stored by 'carbondata' tblproperties('parent'='sales', 'aggtype'='quanity:sum,max#user_id:count#price:sum,max,min,avg') {code} > 1. Add parser rule and support creating aggregation tables to main table.And > update aggregation table information to main table schema. > --------------------------------------------------------------------------------------------------------------------------------------- > > Key: CARBONDATA-1517 > URL: https://issues.apache.org/jira/browse/CARBONDATA-1517 > Project: CarbonData > Issue Type: Sub-task > Reporter: Ravindra Pesala > > User should add aggregation tables with following syntax > {code} > CREATE TABLE agg_sales > STORED BY 'carbondata' > TBLPROPERTIES ('parent_table'='sales') > AS SELECT user_id, sum(quantity), avg(price) FROM sales GROUP BY user_id > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)