Pulse Virtual Machine Quick Start

These Quick Start instructions detail the minimal steps for installing and using Pulse with the Vertica Virtual Machine Image. Consult the complete documentation for detailed steps on installing Pulse on your own platform.

Downloading and Installing Pulse

  1. Go to http://my.vertica.com/ and sign in. Then, click the Download tab.
  2. Scroll down to the section "Download Vertica 7.1 Virtual Machines" and click the download link for your VM environment. These instructions assume you are installing the VMDK version - VMWare Server 2.0 and Workstation 7.0.
  3. After the download completes, unzip the file.
  4. Double-click the .vmx file in vmsrvr_64/Vertica 7.1.x x64 for VMware. The VM starts in your VMWare application.
  5. You are automatically logged in as dbadmin. However, the password for the user (and root) is 'password'.
  6. In the VM, select Applications > Accessories > Terminal to open a terminal.
  7. In the terminal, type admintools to start the administration tools.
  8. You are prompted for a license when admintools starts for the first time. To use the community edition license, simply click OK. You are then prompted to accept the EULA. Accept the EULA then exit admintools.
  9. As dbadmin, using vsql on any node in the cluster, set the JavaBinaryforUDx Configuration Parameter (use which java to determine your java location):

    vsql -t -c "ALTER DATABASE mydb SET JavaBinaryForUDx = '/usr/bin/java';"
  10. Copy the Vertica Pulse install package to the VM then, as root, install the Pulse Package:

    rpm -Uvh /path/to/vertica-pulse.x86_64.xxx.rpm

    Note: Only install Vertica Pulse on a single node. All Pulse functions are available on all nodes. However, the installation SQL scripts and user-dictionary loading script are only available on the node on which you install the Pulse package.

  11. As dbadmin, run the Pulse install script on the node on which you installed the Pulse Package:

    vsql -f /opt/vertica/packages/pulse/ddl/install.sql

Using Pulse

  1. Run a sentiment function:

    select sentimentanalysis('Cookies are sweet.') OVER(PARTITION BEST);
     sentence | attribute | sentiment_score
    ----------+-----------+-----------------
            1 | cookies   |               1
    (1 row)
    

Note: By default, VerticaPulse analyzes English text, however, you can also specify the language of the text being analyzed as an attribute of the sentimentanalysis() function. For example:

select sentimentanalysis('Cookies are sweet.', 'english') OVER(PARTITION BEST);

English and Spanish are the supported languages.