Hi, I have table DESC SUCC_COUNT FAIL_COUNT ================================== ABC 5 1 BCD 7 2 Here my intension is to find the sum of SUCC_COUNT and FAIL_COUNT for list of DESC. I have a possible list of values for DESC . DESC values should be among (ABC,BCD,CDE,XYZ). Here there are cases where som...

Hi,

I was able to connect to vertica as below

vsql -U ${VERTICA_USR} -d ${VERTICA_DB} -c "<sql query>' -At -o <output_file> -F ',' -q.

The above resulted the output without header and comma separated

Thanks
Sach

Hi,

Is there any sample example to connect to Vertica and execute sql's through shell script ?.I tried with option \i <file.sql>, but the vertica ignores the arguments...

Thanks in Advance,
Sach