Using vsql Almost Anywhere

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser, VerticaPartners
edited May 2018 in Vertica Tips

Jim Knicely authored this tip.

I’m an old school kind of guy so I love our vsql command line interface (CLI) tool. What’s cool is if I am on a remote Linux host, I can copy the vsql binary from the database host and run then run it locally.

Example:

[[email protected] ~]$ vsql
-bash: vsql: command not found

[[email protected] ~]$ scp verticademos.com:/opt/vertica/bin/vsql /usr/bin
vsql

[[email protected] ~]$ vsql -h verticademos.com
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

dbadmin=>

Have Fun!

Comments

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

    Note that the vsql CLI does have some several dependencies:

    [[email protected] ~]$ ldd /opt/vertica/bin/vsql
            linux-vdso.so.1 =>  (0x00007fff2773c000)
            libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fad2f594000)
            libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fad2f354000)
            libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fad2f134000)
            libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fad2ef14000)
            libdl.so.2 => /lib64/libdl.so.2 (0x00007fad2ed0c000)
            libssl.so.10 => /opt/vertica/lib/libssl.so.10 (0x00007fad2ea9c000)
            libcrypto.so.10 => /opt/vertica/lib/libcrypto.so.10 (0x00007fad2e6b4000)
            libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fad2e3a4000)
            libm.so.6 => /lib64/libm.so.6 (0x00007fad2e11c000)
            libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fad2defc000)
            libc.so.6 => /lib64/libc.so.6 (0x00007fad2db64000)
            /lib64/ld-linux-x86-64.so.2 (0x00007fad2f7b4000)
            libfreebl3.so => /lib64/libfreebl3.so (0x00007fad2d95c000)
            libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fad2d714000)
            libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fad2d424000)
            libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fad2d21c000)
            libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fad2cfec000)
            libz.so.1 => /lib64/libz.so.1 (0x00007fad2cdcc000)
            libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fad2cbbc000)
            libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fad2c9b4000)
            libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fad2c78c000)
    
Sign In or Register to comment.