Timerange Table SQL Presto Timerange Table SQL Presto database database

Timerange Table SQL Presto


sql database presto

Pro tipp, you might even be able to get away without a temporary table using the WITH syntax. And then in the following SELECT statement you can use hours as if it were a table.

WITH hours AS (SELECT * FROM UNNEST(ARRAY[0,1, ... 22,23]) AS t (hour))SELECT     * FROM     hours;

sql database presto

I would do this:

CREATE TABLE fakehours ASWITH hours AS (SELECT * FROM UNNEST(SEQUENCE(0,23,1)) AS t (hour))SELECT   * FROM hours;

sql database presto

Depending on your Presto version try:

SELECT * FROM UNNEST(SEQUENCE(0,23))

or

SELECT * FROM UNNEST(ARRAY[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23])

Should achieve what you want in a join, short of having temp tables available in Presto.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last