getJsonFields

Extract field names from a JSON object. Returns a concatenated comma-separated field list ordered in ascending order.

Usage Details

LQL Command

select getJsonFields(fieldname) from table

Input
table

json_data
{"a": "v", "b": "c"}
{"a": {"b": "c"}}

LQL Command

select *, getJsonFields(json_data) as a jsonFields from table

Output

json_data	jsonFields
{"a": "v", "b": "c"}	a , b
{"a": {"b": "c"}}	a