Tuesday, May 16, 2017

HP Vertica

  • HP columnar database. 
  • PostgreSQL fork.
  • Updates and inserts (even batched) are slow. Bulk loading required.
Tools
  • Binaries at opt/vertica/bin and opt/vertica/bin
vsql
adminTools

VM credentials
dbadmin/password
root/password

Example Database
Scripts location: /opt/vertica/examples
Installation: ./install_example VMart 
Verification: launch vsql and select count(1) from store.store_sales_fact;

Singularities
Bulk loading
Tips
https://github.com/jackghm/Vertica/wiki/HP-Vertica-Tips,-Tricks,-and-Best-Practices

No comments:

Post a Comment