The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
SPSS compatibility with Vertica?
We are going to purchase SPSS Modeler Professional Version 16. IBM is telling us that SPSS is not certified for Vertica so it may not work. Does any of you have any experience in using SPSS with Vertica?
I can connect to the Vertica schemas. SPSS retrieves variable list but it does not retrieve any data.
I'm forced to ctrl+alt+delete to kill SPSS.
The reason, you are unable to see the data is because of the setting of "Result buffer size" (the size of the memory buffer the client uses when retrieving a result set). The default is 131072 bytes. If you are fetching data that is more the default value, then, SPSS Statistics engine pop with a message that "spssengine has stopped working" and it force you to kill the process.
To resolve this issue, you should set "result buffer size" to "0" (zero) or to a fixed value. It is a good practices to set the value to "fixed value". Please see the client setting tab in the ODBC DSN configuration to set this value.
This will allow you to read and write (use export to database) data into Vertica.
Please let us know if you still have any issue.