Hi Cam,
I couldn't find a function that achieved precisely what you were looking
for, but there is a function that gets pretty close to what you want.
select id, collect_set(date_hour), collect_set(count), sum(count) from test
group by id;
The problem with using collect_set is that it removes du
Hello,
After doing some aggregate counting, I now have data in a table like this:
id countdate_hour (this is a partition name)
1 3 2011310115
1 1 2011310116
2 1 2011310117
2 1 2011310118
and I need to turn this into:
1 [2011310115,2011310
