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
- Go to http://my.vertica.com/ and sign in. Then, click the Download tab.
- 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.
- After the download completes, unzip the file.
- Double-click the .vmx file in
vmsrvr_64/Vertica 7.1.x x64 for VMware
. The VM starts in your VMWare application. - You are automatically logged in as dbadmin. However, the password for the user (and root) is 'password'.
- In the VM, select Applications > Accessories > Terminal to open a terminal.
- In the terminal, type
admintools
to start the administration tools. - 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.
-
As dbadmin, using vsql on any node in the cluster, set the
JavaBinaryforUDx
Configuration Parameter (usewhich java
to determine your java location):vsql -t -c "ALTER DATABASE mydb SET JavaBinaryForUDx = '/usr/bin/java';"
-
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.
-
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
-
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.