Skip to main content
Question

List the functions within Vertica packages

  • November 20, 2020
  • 1 reply
  • 5 views

Pieter_Sheth-Vo
Forum|alt.badge.img+2

Are there docs or a command to list the functions within the various Vertica packages, and conversely which package a particular Vertica function is in? Specifically, the command below lists the available packages, but what is available within txtindex or VFunctions?

I've recently run into a couple cases where a package expected to be installed by default wasn't, but could be by running admintools -t install_package -d mydb -P <package> --force-reinstall -p <password> where <package> is one of the below. For now I've reinstalled each

But out of curiosity, I tried searching Googling and searching Vertica docs for terms like "packages" and
"VFunctions" with no immediate results.

~]$ admintools -t list_packages 
             Package Description
                 AWS Amazon Web Services Package
     MachineLearning In-dataBase Machine Learning package.
       ParquetExport Functions that support Parquet Export
      SparkConnector Spark connector for reading from and writing into Vertica
          VFunctions Vertica functions
         approximate Probabilistic/Approximate Aggregation Functions
           flextable Flexible Tables Data Load and Query
                hcat Java/HCatalog data load and query
               kafka Kafka streaming load and export
           logsearch Common Advanced text search functions
               place Geospatial Data Query
            txtindex Common string-manipulation functions
       voltagesecure Voltage SecureData functions

1 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • November 20, 2020

Maybe something like this?

SELECT DISTINCT 
       l.lib_name 
     , l.description
     , f.schema_name function_schema
     , f.function_name
     , f.procedure_type function_type
  FROM user_functions f
  JOIN user_libraries l ON f.function_definition ILIKE '%' || lib_name || '%'
  ORDER BY 1, 2, 3, 4;