mosheg
Administrator
mosheg Administrator
Reactions
-
Re: VSQL output to excel
From Vertica's vsql command-line tool, you cannot directly create an Excel file. However, you can generate CSV output from Vertica using vsql and then convert that CSV file to an Excel file. For exam… (View Post)1 -
Re: How to enable/disable database Audits?
@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)1 -
Re: Reading Query Plan And Optimizing It
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)1 -
Re: Why MERGE does not consider null values "properly" ?
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)1 -
Re: Can you provide guidance on how to accomplish this?
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)1