Installing or Upgrading the Vertica Pulse Package on Your Host

After you install a JVM on all of the nodes in your cluster, you must install the Pulse Package on a single node. If upgrading, install the new package on the same host on which you previously installed the package. Pulse installation or upgrade is a two-step process:

  1. Install/Update the RPM or DEB package for Pulse.
  2. Run included sql scripts to install or update the Pulse functions and create the user dictionaries.

The Pulse install process installs the functions and schema required for sentiment analysis. You need only install it on a single node. However, be aware that the following SQL scripts are only available from the node on which you installed the Pulse package:

You can access Pulse functions on all nodes, regardless if the package is installed on the node to which you are connecting.

Install or Upgrade the Pulse Package

When you upgrade or reinstall Pulse, it automatically uses port 5433 for vsql. If you are using a different port, configure it using the command export VSQL_PORT=<port_number>.

  1. Copy the RPM or DEB package to the node where you want to install or upgrade Pulse. If you are upgrading Pulse then copy the new package to the same node where you previously installed the Pulse package. The version of Vertica Pulse must match the version of the Vertica server. For example, if your Vertica server is version 7.1.0, then the VerticaPulse version must also be 7.1.0.

    If you are upgrading Pulse, you can find the currently-installed version number of Pulse with the command:

    select lib_version, lib_sdk_version from user_libraries where lib_name = 'SentimentLib';
  2. Log into the host and install the package.

    • For Red Hat, use:
    sudo rpm -Uvh /path-to-package/vertica-pulse.x86_64.xxx.rpm
    
    • For Debian, use:
    sudo dpkg -i /path-to-package/vertica-pulse.x86_64.xxx.deb
    

The Pulse Package is installed to /opt/vertica/packages/pulse.

After you install the package, you must run the appropriate SQL scripts to install or upgrade the Pulse functions and install the dictionary tables. Vertica automatically reloads any labeled user-defined dictionaries.

Running the Pulse Install Script

Run the install script to install or upgrade the Pulse functions and schema for the dictionaries and mappings required for sentiment analysis. You must run the install script once on the node on which you installed the package. After you run the install script, then all nodes can use the Pulse functions.

Important! Before running the install script, you must set the JavaBinaryforUDx configuration parameter or the install script fails to install the Pulse functions. See Installing Java on Vertica Hosts.

To run the install script:

  1. As the dbadmin user, on the node on which you installed the Pulse RPM/DEB, run the install.sh script:

    bash /opt/vertica/packages/pulse/install.sh

    Note: You must run the install script for installs or upgrades.

  2. The script installs/upgrades the Pulse functions:

    CREATE LIBRARY
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
    CREATE TRANSFORM FUNCTION
        etc...
     
  3. If this is a fresh installation, then Modify the jvm Resource Pool to match your system hardware.