No result set produces file with size zero (prefer no file)
Posted: Tue Dec 17, 2013 2:20 pm
Good morning!
From the vsql command line, I am running a query which does not produce a result set. The -o option creates a file having a size of zero.
Example:
I would prefer Vertica NOT to create the file at all if the query has no result set.
Is that possible?
From the vsql command line, I am running a query which does not produce a result set. The -o option creates a file having a size of zero.
Example:
Code: Select all
[dbadmin@vertica-1]$ vsql -Atc "select * from dual where 1 = 2" -o /home/dbadmin/test.txt
[dbadmin@vertica-1]$ ls -lrt /home/dbadmin/test.txt
-rw-r--r--. 1 dbadmin verticadba 0 Dec 17 08:13 /home/dbadmin/test.txt
Is that possible?