HP Vertica Pulse installation issues

Hi Muthu,

The error suggests that that the jvm ran out of memory. Please use the following command inside vertica to allocate more memory to the jvm.

alter resource pool JVM maxmemorysize '6G' plannedconcurrency 1;

Please note that the above settings will allow you to run pulse quesries from only one session concurrently. If you expect to run pulse queries from multiple sessions concurrently e.g. 4, then set the plannedconcurrency to 4 and maxmemorysize to 6*4 i.e. 24

Please let us know if this helps.

Thanks
Pratibha

Thanks Pratibha. 

I downloaded VM with Vertica. This is the configuration as per vertica documentation.

• The VM image is preconfigured with the following hardware settings:
  • 1 CPU
  • 1024 MB RAM
  • 50 GB Hard Disk (SCSI, not preallocated, single file storage)

I tried the command. I got the following error.

alter resource pool JVM maxmemorysize '6G'plannedconcurrency 1;
ROLLBACK 3912:  maxMemorySize of 6G [6291456 KB] is not in bounds [max is 877982 KB]


So I tried this

alter resource pool JVM maxmemorysize '800M'plannedconcurrency 1;ALTER RESOURCE POOL
dbadmin=> select SentimentAnalysis('Cookies are sweet') OVER(PARTITION AUTO);
 sentence | attribute | sentiment_score 
----------+-----------+-----------------
        1 | cookies   |               1

What should be the optimum memory size for doing any meaningful work?
Will I be able to use VM provided by Vertica for any Vertica Pulse POC work? Will I run into issues because of memory?

Thanks.

My host is Windows 7 with RAM size of 8GB.

Hi Muthu,

We suggest you use 25% of your RAM size or altleast 2G. So I think for you setting the maxmemorysize to 2G should do the trick.

Pratibha