mosheg
Administrator
mosheg Administrator
Reactions
-
Re: New feature request - swap_tables
Thank you for your question. It is possible to use one statement like ALTER TABLE...RENAME TO to swap tables within the same schema, without actually moving data as mentioned here: https://www.vertic… (View Post)2 -
Re: Question on UTF-8
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)1 -
Re: Is commit still necessary when using INSERT /*+direct*/ INTO ... ?
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)1 -
Re: How show the CPU load of a vertica process
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)1 -
Re: SUM, AVERAGE, COUNT, STDEV across columns?
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 ',' NU… (View Post)1