and whose time_ is between '2019-09-21 08:53:00.0' and '2019-09-21 08:53:45.8' (View Post)

So you are in a DOS box of a Windows system. Add an environment variable to your account, by hitting the magnifying glass next to the Windows button at the far low left corner of your Windows screen,… (View Post)

You have to give the TIMESERIES a different name than the name of the column you use in ORDER BY: SELECT new_ts_name AS ts,TS_FIRST_VALUE(bid, 'const') fv_c,TS_FIRST_VALUE(bid, 'linear… (View Post)

The "cleanest" way to make apportioned load happen is to have the load file on a directory that is locally mounted under the exact same directory on all existing Vertica nodes. You transfer… (View Post)

Vertica has a clause that has been invented for something like what you ask the TIMESERIES clause. In your case, you would be tempted to use it as: TIMESERIES gen_date AS '1 DAY' OVER(PARTI… (View Post)