cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kiran Challa (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-8170) Issues Inserting Collections (List) into Cassandra using Mulesoft driver 1.2.2 - mulesoft/CassandraDB-connector
Date Thu, 23 Oct 2014 00:08:35 GMT
Kiran Challa created CASSANDRA-8170:

             Summary: Issues Inserting Collections (List) into Cassandra using Mulesoft driver
1.2.2 - mulesoft/CassandraDB-connector 
                 Key: CASSANDRA-8170
             Project: Cassandra
          Issue Type: Bug
          Components: Drivers (now out of tree)
         Environment: Windows, MuleSoft
            Reporter: Kiran Challa

I was trying to insert records into Cassandra using "Execute cql query" operation for CassandraDB
connector (ver 1.2.2). The query is made up of ints and strings, with the last 4 fields being
Collection type List. 

If I test by inserting the exact same query directly into cqlsh or DataStax Dev Center (and
add a trailing semicolon), the insert works fine. But if I try it from within a Mule flow,
I get the following error: 

org.mule.api.MessagingException: Failed to invoke executeCqlQuery. 
 InvalidRequestException(why:line 1:1056 no viable alternative at character ']') 

Can someone help me with the resolution. Thanks

cassandradb:execute-cql-query config-ref="CassandraGenesisDB" query="INSERT INTO genesis.document_master
(doc_id, doc_number,doc_number_formatted,doc_state_abbr,doc_state_name,doc_state_fips,doc_county_name,doc_county_fips,doc_county_id,
values ('1-06-059-2014.15','2014.15','2014.15 ','CA', 'CALIFORNIA','06', 'ORANGE','059','OR',
20140102, 'CORPORATE ASSIGNMENT OF DEED OF TRUST','1', '2014.15', 'null','null', '-14','null',
'AS ',0, 'I', 20140102,'0', 'N', 'null','null', '00000000000015','', 'null', 'null','null',
'null',0, 'null', 'null','null', 'null' ,['NATIONSTAR MTG LLC - ASSIGNOR', 'SARM 2007-4 TRUST
FUND - ASSIGNEE', 'DAVIS ALANA R - BORROWER1'])" doc:name="CassandraDB" 

Note that if we eliminate the last column, which is called "name", and the corresponding string
array of values for this field, the query works fine. 

Mulesoft info: 


Here is our Cassandra info: 

Search 4.6 
 DSE 4.5.2 

This message was sent by Atlassian JIRA

View raw message