The Vertica HASH function calculates a hash value over the function arguments, producing a value in the range 0 <= x < 2^63. When calculating a hash value, the HASH function takes into consider… (View Post)

The Vertica ROUND function rounds a value to a specified number of decimal places, retaining the original precision and scale. Fractions greater than or equal to .5 are rounded up. Fractions less tha… (View Post)

@ahaldar1106: @Bryan_H's suggestion might be the better choice as COALESCE is an ANSI SQL-92 standard! dbadmin=> SELECT * FROM t; a | b | c---+---+--- A | | B(1 row)dbadmin=> SELECT coales… (View Post)

The jar file is for JDBC. The Windows client does not install the jar file. It's a separate download and you can put it anywhere on your system. @Sankarmn gave you the link. https://www.vertica.… (View Post)

@rajatpaliwal86 - If you have a different epoch for every dup row, you can run a DELETE statemen to reove the duplicates, keeping the recordsi having the latest record... Example: dbadmin=> \d dup… (View Post)