@Sergey_Cherepan_1 Please consider the following: SELECT VERSION(); -- Vertica Analytic Database v12.0.4-6CREATE USER user104;CREATE TABLE dbadmin_table (f1 int);INSERT INTO dbadmin_table VALUES (1);… (View Post)

In addition, to profile a query you can use the qprof script provided by Maurizio Felici available here: https://github.com/mfelici/qprof Run the qprof shell script this way: ./qprof.sh -f YourQuery.… (View Post)

The issue with the MERGE statement is that it involves columns with NULL values. When comparing NULL values with the "=" operator, it returns NULL instead of true, which causes the MERGE to… (View Post)

In addition, lacat is old and simple utility that exports CEF records from a Logger archive file. It prints them to stdout by design, allowing the user to redirect them to a file or pipe them into cs… (View Post)

Please open a support case to investigate why the same node goes down. In general, you can see messages in the file vertica.log To find where vertica.log file is located run the command: admintools -… (View Post)