Re: Opposite of FLATTEN

2015-06-30 Thread Ted Dunning
I could write a custom Hive aggregator, but I want to use Drill and get all the performance possible. On Mon, Jun 29, 2015 at 7:02 PM, Venky Kandaswamy ve...@adisya.com wrote: Couldn¹t you write a custom aggregate function in Hive? (I don¹t have one). Thanks, Venky On 6/29/15, 6:41 PM,

Opposite of FLATTEN

2015-06-29 Thread Jim Scott
Given a data set: 'ndb_no','description' '02001','SPICE OR HERB (US CFR)' '02001','ALLSPICE' '02001','FINELY GROUND' '02001','NOT HEAT-TREATED' '02001','COOKING METHOD NOT APPLICABLE' '02001','WATER REMOVED' '02001','NATURALLY DRIED' '02001','SUN DRIED' I'm seeking the capability to be able

Re: Opposite of FLATTEN

2015-06-29 Thread Ted Dunning
Like array_agg in postgres: http://www.craigkerstiens.com/2013/04/17/array-agg/ On Mon, Jun 29, 2015 at 2:23 PM, Jim Scott jsc...@maprtech.com wrote: Given a data set: 'ndb_no','description' '02001','SPICE OR HERB (US CFR)' '02001','ALLSPICE' '02001','FINELY GROUND' '02001','NOT

Re: Opposite of FLATTEN

2015-06-29 Thread Venky Kandaswamy
Couldn¹t you write a custom aggregate function in Hive? (I don¹t have one). Thanks, Venky On 6/29/15, 6:41 PM, Ted Dunning ted.dunn...@gmail.com wrote: Like array_agg in postgres: http://www.craigkerstiens.com/2013/04/17/array-agg/ On Mon, Jun 29, 2015 at 2:23 PM, Jim Scott