Maybe something like this? dbadmin=> SELECT * FROM ld ORDER BY 1; c------------ 1984-12-21 1984-12-31 1987-08-30 1987-08-31 2020-04-28 2020-04-28 2020-04-29 2020-04-30 2021-01-01 2021-08-30 2021-0… (View Post)

Ah, ok. That was resolved in 10.1. We don't have too many clients running a single node Eon cluster :) (View Post)

The Vertica User Profiles documentation page is pretty clear on this: For now you have to use Connection Load Balancing Policies to redirect a connection to a specific subcluster based on the connect… (View Post)

Maybe a temp table? CREATE TEMP TABLE something_fixed_temp ON COMMIT PRESERVE ROWS AS SELECT * FROM something-fixed;SELECT S3EXPORT(col1, col2 USING PARAMETERS url = 'url-1') OVER () FROM something_f… (View Post)

Probably a million ways to get the results... dbadmin=> SELECT aux_date FROM data ORDER BY aux_date; aux_date------------ 2021-11-20 2021-11-21 2021-11-22 2021-11-23 2021-11-24 2021-11-25 2021-11-… (View Post)