Re: Concurrency in Vertica
Posted: Thu Jan 22, 2015 9:58 pm
Rolling your own will be more development work, but one advantage is that you cut down on the overhead that you get with JDBC.
By any chance do you have access to the linux boxes that Vertica is installed on?
There is a vertica vsql client in /opt/vertica/bin/vsql that can run SQL queries from the command line.
Assuming you can get the vsql client to work (and it should work!) then it's possible to call it from a control program written in bash, python, or perl.
Doug
By any chance do you have access to the linux boxes that Vertica is installed on?
There is a vertica vsql client in /opt/vertica/bin/vsql that can run SQL queries from the command line.
Assuming you can get the vsql client to work (and it should work!) then it's possible to call it from a control program written in bash, python, or perl.
Doug