How to find installed packages on Vertica server using the admintools command line
Using the admintools command line we can create all types of routines and scripts.
For this task you need to use the list_packages
[dbadmin@bih001 ~]$ admintools -t list_packages
Package Description
flextable Flexible Tables Data Load and Query
approximate Probabilistic/Approximate Aggregation Functions
hcat Java/HCatalog data load and query
pload
geospatial [dbadmin@bih001 ~]$ admintools -t list_packages -d test -p test
Package Installed? Description
flextable Yes Flexible Tables Data Load and Query
approximate Yes Probabilistic/Approximate Aggregation Functions
hcat No Java/HCatalog data load and query
pload No
geospatial No
