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?
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.