[jira] [Created] (CARBONDATA-1520) 4 Load aggregation tables from main table after finish.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-1520) 4 Load aggregation tables from main table after finish.

Akash R Nilugal (Jira)
Ravindra Pesala created CARBONDATA-1520:
-------------------------------------------

             Summary: 4 Load aggregation tables from main table after finish.
                 Key: CARBONDATA-1520
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1520
             Project: CarbonData
          Issue Type: Sub-task
            Reporter: Ravindra Pesala


Generate 'insert into ' query for every aggregation table and execute it.
{code}
insert into table agg_table select UDF(order_time, day) , user_id, sum(quantity), sum(price) from orders
{code}
Here the selection of aggregation types should be depending on aggtypes mentioned while creating aggregation tables.
Here AVG should be stored as COUNT and SUM separately.




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