Search found 1 match

by rekha1111
Wed May 31, 2017 6:01 pm
Forum: New to Vertica
Topic: Timeseries with crossjoin
Replies: 1
Views: 799

Timeseries with crossjoin

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

Go to advanced search