AnsweredAssumed Answered

Issue connecting Cassandra 3.11.1 to Pentaho Server CE 8.1

Question asked by Manuel Perez Vega on May 22, 2018

I have a problem with my "Data Preview" using a simple SQL to extract data from cassandra.

 

I'm using cassandra 3.11.1 and Pentaho Server CE 8.1

I'm using datastax cassandra jdbc driver wrapper 3.1.0 (Connecting QuerySurge to Cassandra with JDBC (Adejanovski DataStax Wrapper) – Customer Support )

     URLjdbc:cassandra://MY_IP:9042

     com.github.adejanovski.cassandra.jdbc.CassandraDriver

 

I get success when I tests my datasource. But I get an error when I want to retrieve data from cassandra using a SQL.

 

14:15:49,931 ERROR [AbstractGwtRpcProxyServlet] com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public org.pentaho.platform.dataaccess.datasource.beans.SerializedResultSet org.pentaho.platform.dataaccess.datasource.wizard.service.impl.DSWDatasourceServiceImpl.doPreview(java.lang.String,java.lang.String,java.lang.String) throws org.pentaho.platform.dataaccess.datasource.wizard.service.DatasourceServiceException' threw an unexpected exception: java.lang.NullPointerException

 

Any ideas?

Outcomes