1270257 - Add range function in presto

Status: RESOLVED FIXED

(Cloud Services Graveyard :: Metrics: Pipeline, defect, P3)

Description

[Benjamin Smedberg]

It would be nice to have a range function in presto so that I can search for missing data efficiently:

SELECT date_add('day', -N, today()) FROM range(0, date_diff('day', '2015-12-01'::date, today())

Bonus, range that handles datetimes directly and not just integers.

Exploding an array would be reasonable too, if a range() function that returns a rowset is not easy.

Comment 1

[Mark Reid [:mreid]]

See also this issue: https://github.com/prestodb/presto/issues/2169

And the "generate_series" function in postgresql: http://www.postgresql.org/docs/current/static/functions-srf.html

Comment 2

[Benjamin Smedberg]

There is now a `sequence` function in presto which I think does exactly what I want. It was added two weeks ago so I don't know whether it's in a release yet, and probably not on EMR.

Comment 3

[Thomas Huelbert]

this will addressed by the upgrade

Comment 4

[Blake Imsland [:robotblake]]

The Presto cluster has now been upgraded and the SEQUENCE function appears to be working.