[
https://issues.apache.org/jira/browse/CASSANDRA-12760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15879894#comment-15879894
]
Paul Fife commented on CASSANDRA-12760:
---------------------------------------
I did find in the Apache docs as well:
http://cassandra.apache.org/doc/latest/cql/json.html#cql-json
"The result map keys are the same as the column names in a normal result set.
For example, a statement like SELECT JSON a, ttl(b) FROM ... would result in a
map with keys "a" and "ttl(b)". However, this is one notable exception: for
symmetry with INSERT JSON behavior, case-sensitive column names with upper-case
letters will be surrounded with double quotes. For example, SELECT JSON
myColumn FROM ... would result in a map key "\"myColumn\"" (note the escaped
quotes)."
> SELECT JSON "firstName" FROM ... results in {"\"firstName\"": "Bill"}
> ---------------------------------------------------------------------
>
> Key: CASSANDRA-12760
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12760
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra 3.7
> Reporter: Niek Bartholomeus
> Assignee: Shivang Nagaria
> Labels: lhf
>
> I'm using Cassandra to store data coming from Spark and intended for being
> consumed by a javascript front end.
> To avoid unnecessary field name mappings I have decided to use mixed case
> fields in Cassandra. I also happily leave it to Cassandra to jsonify the data
> (using SELECT JSON ...) so my scala/play web server can send the results from
> Cassandra straight through to the front end.
> I noticed however that all mixed case fields (that were created with quotes
> as Cassandra demands) end up having a double set of quotes
> {code}
> create table user(id text PRIMARY KEY, "firstName" text);
> insert into user(id, "firstName") values ('b', 'Bill');
> select json * from user;
> [json]
> --------------------------------------
> {"id": "b", "\"firstName\"": "Bill"}
> {code}
> Ideally that would be:
> {code}
> [json]
> --------------------------------------
> {"id": "b", "firstName": "Bill"}
> {code}
> I worked around it for now by removing all "\""'s before sending the json to
> the front end.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
