Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to dump the case sensitive columns to Cassandra DB through NIFI

How to dump the case sensitive columns to Cassandra DB through NIFI

Explorer

Hi,

I have a requirement to dump the CSV file data to Cassandra DB - the file contains mixed case column names with special characters (eg:- "Actual_Values", "Serial.NO", quantity).
I created the Cassandra table with these 3 columns 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.
Could anyone please help to fix this issue.

Don't have an account?
Coming from Hortonworks? Activate your account here