[PHOENIX-351] Add built-in function to bucketize a BigDecimal range

• Type: Task
• Status: Open
• Resolution: Unresolved
• old issue number: 220
• Assignee: Unassigned
• Reporter: eldokk
• Created: 10/Mar/14 23:47
• Updated: 10/Mar/14 23:47

Description

I have a select query to apply aggregation for specific groups and for different key sets .

The best approach i think let Phoenix do the aggregation (its fast and i guess it make use of co-processors) but i am missing the option of UNION in select query so that i can find aggregate count for selected key range .

Example : select item,volume,sum(price) form Order where k1 < value1 and k1 > value2 group by item,volume

suppose i am plotting a chart with different range (i can say multiple bin size) i need to split the above query into ,

select item,volume,sum(price) from Order where k1 < x.1 and k1 > x.100 group by item,volume
UNION ALL
select item,volume,sum(price) form Order where k1 < x.100 and k1 > x.200 group by item,volume

Does phoenix allow this or i need to pull all the data to the client side do aggregation and binning at client side ?