- HP columnar database.
- PostgreSQL fork.
- Updates and inserts (even batched) are slow. Bulk loading required.
- Binaries at opt/vertica/bin and opt/vertica/bin
adminTools
- SQL frontend: SQuirrel
VM credentials
dbadmin/passwordroot/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
- Columnar
- Compression
- Projections
- Clustering and partitions
- EPOCH (update / insert timestamp) EPOCH (update / insert timestamp)
Tips
https://github.com/jackghm/Vertica/wiki/HP-Vertica-Tips,-Tricks,-and-Best-Practices