PDA

View Full Version : cassandra input component error



samiscrazy87
11-05-2012, 12:03 PM
Hi

I am trying to connect to the Cassandra system using the Cassandra input component. I have specified the host name, port no and the key space. When i click on show schema, it is throwing an error as given in the screen shot. Any body faced this problem?
9743



When i tried to preview data, i get the following error


2012/11/05 16:13:30 - org.pentaho.di.trans.steps.cassandrainput.CassandraInputMeta@2ce4d238 - Unable to connect to retrieve column meta data for 'CROSSING' at this stage.
2012/11/05 16:13:32 - org.pentaho.di.trans.steps.cassandrainput.CassandraInputMeta@2ce4d238 - Unable to connect to retrieve column meta data for 'CROSSING' at this stage.
2012/11/05 16:13:32 - Spoon - The transformation has finished!!
2012/11/05 16:30:55 - Spoon - Save as...
2012/11/05 16:30:55 - Spoon - Save file as...
2012/11/05 16:31:03 - org.pentaho.di.trans.steps.cassandrainput.CassandraInputMeta@2ce4d238 - Unable to connect to retrieve column meta data for 'CROSSING' at this stage.
2012/11/05 16:31:07 - Transformation 1 - Dispatching started for transformation [Transformation 1]
2012/11/05 16:31:07 - Cassandra Input.0 - Connecting to Cassandra node at 'localhost:9160' using keyspace 'UTS'...
2012/11/05 16:31:07 - org.pentaho.di.trans.steps.cassandrainput.CassandraInputMeta@2ce4d238 - Unable to connect to retrieve column meta data for 'CROSSING' at this stage.
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException:
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : It doesn't look like the query will produce any output fields!
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.cassandrainput.CassandraInput.processRow(CassandraInput.java:144)
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/05 16:31:07 - Cassandra Input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Thread.java:722)
2012/11/05 16:31:07 - Cassandra Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2012/11/05 16:31:07 - Spoon - The transformation has finished!!
2012/11/05 16:31:07 - Transformation 1 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
2012/11/05 16:31:07 - Transformation 1 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
2012/11/05 16:31:07 - Transformation 1 - Transformation 1
2012/11/05 16:31:07 - Transformation 1 - Transformation 1

Kindly let me know how to overcome this error

sflatley
11-05-2012, 12:21 PM
Hi, Sean here.

I'll see if I can reproduce what you are seeing. I'll get back to you.

samiscrazy87
11-05-2012, 12:40 PM
Thank u Sean

sflatley
11-05-2012, 01:59 PM
I tried reproduce with our "Read from Cassandra" example found here: http://wiki.pentaho.com/display/BAD/How+To+Read+Data+From+Cassandra.
I did everything from specifying an invalid column family name, column names, keyspace, ip address and port. I could not get the error you are reporting.

Can you email me the CROSSING column family definition? I'm at sflatley@pentaho.com

Thanks!