Timeseries with crossjoin
Posted: Wed May 31, 2017 6:01 pm
Hi
I am trying to generate a time series with cross join .. here is my sql
SELECT
time_slice
FROM
table1
CROSS JOIN
table2
TIMESERIES time_slice AS '1 hour' over(ORDER BY date_to_process)
this does not work .. is there anything wrong with sql
Thanks
I am trying to generate a time series with cross join .. here is my sql
SELECT
time_slice
FROM
table1
CROSS JOIN
table2
TIMESERIES time_slice AS '1 hour' over(ORDER BY date_to_process)
this does not work .. is there anything wrong with sql
Thanks