[jira] [Commented] (NIFI-7402) PutCassandraRecord Processor doesn't allow to dump case sensitive columns data to dump into Cassandra DB

["Mike Thomsen (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-7402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17512114#comment-17512114 ] 

Mike Thomsen commented on NIFI-7402:
------------------------------------

I'll investigate the case-sensitivity issue, but the special characters issue is blocked by Apache Avro's limits. No work around for that one.

> PutCassandraRecord Processor doesn't allow to dump case sensitive columns data to dump into Cassandra DB
> --------------------------------------------------------------------------------------------------------
>
>                 Key: NIFI-7402
>                 URL: https://issues.apache.org/jira/browse/NIFI-7402
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Sandhiya
>            Priority: Major
>
> We need to dump the CSV file data to Cassandra DB - the file contains mixed case column names with special characters (eg:- *Actual_Values,* *[Serial.NO|https://slack-redir.net/link?url=http%3A%2F%2FSerial.NO]**, quantity*).
> A Cassandra table with these 3 columns were created as such but while dumping data from NIFI through *PutCassandraRecord* processor its throwing error as *InvalidQueryException: undefined column actual_values.*
> Observed NIFI by default converts the column names to lowercase and its not accepting column names defined with special characters other than underscore (column_names mapping between NIFI and DB fails).
> Please help to fix this issue.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)