array_agg in vertica
Array_agg is something supported by Postgres, but not Vertica.
What would be the best way to achieve the following?
SELECT id, business_time_minute, (array_agg(price ORDER BY business_time_second DESC)) AS minute_price, FROM ticks GROUP BY business_time_minute
Unfortunately, as far as I tried, last_value or ts_last_value would work with group by, otherwise it would be perfect.