Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to handle null value of an UUID column of Cassandra?

I used the tCassandraInput component to extract data from a Cassandra database. 
the source table looks like: 
create table tbl001 ( recid uuid, createddttm timestamp, addressid uuid, primary key ( recid, createddttm) );
when handling a row in this table with addressid is NULL, Talend stops and reports an nullPointerException error.
in java debug run window, I can see the error was cause by this line:
row5.addressid = row_tCassandraInput_2.getUUID("\"addressid\"").toString();
( because  row_tCassandraInput_2.getUUID("\"addressid\"") gets null, toString() raises the exception )
but as you know, the jave code generated automatically can not be changed. 
how can I do in such a case?
Labels (3)
2 Replies
Anonymous
Not applicable
Author

can anyone help?
Anonymous
Not applicable
Author

I can modify the java code and compile it out of Talend Open Studio.
but I wonder if I can do this in the studio?