UseJsonFormat
Whether to submit and return the JSON encoding for CQL data types.
Data Type
bool
Default Value
true
Remarks
Cassandra 2.2 introduced a CQL extension that allows you to JSON-encode CQL data types. By default, you use the JSON syntax to manipulate data and SELECT statements return JSON through the adapter. Set this property to false to use CQL literals to interact with Cassandra data.
The syntax for CQL literals has several differences from JSON. For example:
- CQL strings are defined in single quotes, while JSON strings are defined in double quotes.
- CQL sets, tuples, and lists are JSON-encoded as arrays.
- User-defined types and CQL uuid types are JSON-encoded as objects.
| Format | Syntax | ||
| CQL | INSERT INTO users (user_id, emails) VALUES(@user_id, @emails) | ||
| Parameters | |||
| user_id | frodo | ||
| emails | {'f@baggins.com', 'baggins@gmail.com'} | ||
| JSON | INSERT INTO users (user_id, emails) VALUES (@user_id, @emails) | ||
| Parameters | |||
| user_id | frodo | ||
| emails | ["f@baggins.com", "baggins@gmail.com"]) |
Note that in queries to the adapter, you must use single quotes to define strings.