Build Vertica Docker Instance
Greatly inspired by work done by sumitchawla/vertica - but I wanted something that worked with Vertica 8 and that seemed to work for persistent stores.
My original docker file can be found here: https://github.com/MattJermyWright/vertica-base
- DEB package of Vertica install (http://my.vertica.com). The latest version changes from CentOS to Debian.
- Patience - this is obviously not production ready, but it works
Standard Build Instructions
docker build -t zahlen/vertica-base .
Start the server (Non-Persistent)
docker run -p 5433:5433 -d zahlen/vertica-base
Start the server with persistent catalog on exit
export datadir=`pwd`/data docker run -p 5433:5433 -d -v $datadir:/home/dbadmin/docker zahlen/vertica-base
Username: dbadmin, no password
Tab Delimited File
vsql -h localhost -p 5433 -U dbadmin -c "copy public.mjw_tmp_csdblog from local '/Users/matt/Desktop/shr2_vrt_pro_hpcom_usr_mjw_tmp_csdblog.tsv' delimiter E'\t'"
Regrettably I found there were incompatibilities with the Vertica installer in Centos 7, so changed the setup to use Debian. Apologies to those who went to the trouble to download RPMs and now have to download Debian archives.