UTF-8 is a variable-length character encoding and can represent any universal character in the Unicode standard. Vertica expect to receive all data in UTF-8, and also outputs all data in UTF-8. It is… (View Post)

And if you run "unnecessary" COMMIT when the previous statement(s) were auto-committed you will get INFO 2372: Cannot commit; no transaction in progress BTW, when you combine several INSERT… (View Post)

Try to use the the “top” program for dynamic real-time view of the Vertica process via this command: top -p $(pidof vertica) Or use “pidstat” for report statistics on Linux specific tasks. It can be … (View Post)

Please consider the following example in pure Vertica SQL. CREATE TABLE my_table (userid int, a1 int, a2 int, a3 int, a4 int, a5 int, a6 int) order by userid;COPY my_table FROM STDIN DELIMITER '… (View Post)

NaN (Not a Number) does not equal anything, not even another NaN. You can query for them using the predicate … WHERE column != column See: https://www.vertica.com/blog/vertica-quick-tip-query-nan-val… (View Post)