Function similar the generate_series of Postgres

Hello everyone!
I’m migrating some ETL jobs to Dremio and I came across a PostgreSQL function that I could not convert to Dremio.

This function is called generate_series () where I pass the start date, end date and frequency (if it is daily, monthly, yearly) and returns a result equal to this example:

Does anyone have a clue how to generate this result in Dremio?

Hello @jSantos, we do not currently have function like that, but thank you for the suggestion.

You can of course generate a series like this in Postgres and access this table via Dremio.

1 Like