You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tianyu Qi (Jira)" <ji...@apache.org> on 2020/03/13 04:56:00 UTC
[jira] [Updated] (CASSANDRA-12760) SELECT JSON "firstName" FROM ...
results in {"\"firstName\"": "Bill"}
[ https://issues.apache.org/jira/browse/CASSANDRA-12760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tianyu Qi updated CASSANDRA-12760:
----------------------------------
Attachment: Cesar Agustin Garcia Vazquez.url
> SELECT JSON "firstName" FROM ... results in {"\"firstName\"": "Bill"}
> ---------------------------------------------------------------------
>
> Key: CASSANDRA-12760
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12760
> Project: Cassandra
> Issue Type: Improvement
> Components: Legacy/Core
> Environment: Cassandra 3.7
> Reporter: Niek Bartholomeus
> Assignee: Shivang Nagaria
> Priority: Normal
> Labels: lhf
> Attachments: Cesar Agustin Garcia Vazquez.url
>
>
> 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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org