RANK complies with SQL99 specification and should behave the same in other DB's. Otherwise, Vertica implementation is Postgres-like and should work like Postgres or Oracle, though I checked SQL … (View Post)

You could place the library on S3 or another supported shared file system, as noted in the PATH argument at https://docs.vertica.com/12.0.x/en/sql-reference/statements/create-statements/create-librar… (View Post)

Re-reading your scenario, "alice" owns the view and needs select with grant option on the base table: grant select on bi_stats.test_table to alice with grant option; This allows "alice… (View Post)

This syntax may be confusing, but it's what I would expect from the documentation: "Interpolated values come from the table that contains the null, not from the other table." Please se… (View Post)

Hi, I've asked client driver team to investigate. However, I know that JDBC converts certain batch loads (preparedStatement, or SQL COPY) into something like a COPY LOCAL. It would help if you c… (View Post)