I have data in Cassandra where the primary key (one column table_key) contains a key and a value and those are separated by a file separator ' x1c'' unicode. How can I query with this in the where clause of cqlsh? The data gets inserted via an Java application normally.
When my where clause is WHERE table_key = 'key\x1cvalue' it just finds nothing, while the record is in there.
Same is that I want to bulk load data with this same separator via DSBulk, but in some way it does not recognize it and sees it as text only.