Lindorm:Support on JSON

SELECT JSON

Add the JSON keyword to a SELECT statement to return each row as a JSON-encoded map.

SELECT JSON a, b FROM <table_name>;

The map keys match the column names in a regular result set. For example, the statement above returns a map with the keys "a" and "b".

INSERT JSON

Add the JSON keyword to an INSERT statement to insert a JSON-encoded map as a row. The JSON map format must match the result set format that SELECT JSON returns for the same table. Enclose case-sensitive column names in double quotation marks (").

INSERT INTO persioninfo JSON '{ "c1": "key", "c2": "value"}'

By default, columns not included in the JSON map are set to null, and any existing values for those columns are removed.

JSON encoding of CQL data types

Lindorm CQL represents and accepts most data types in their native JSON format, and also accepts string representations for all single-field types (for example, float values, integers, UUIDs, and dates can be represented as CQL text strings).

The following table describes the JSON types that Lindorm CQL accepts in INSERT JSON statements and fromJson() calls, and the types it returns in SELECT JSON statements and toJson() calls.