parseJsonTable

swordfish.function.parseJsonTable()

Parses JSON objects into an in-memory table. An empty JSON object will parsed as an empty row of the table.

• When json is a string containing multiple JSON objects, each object will be converted to a row in the table.

• When json is a vector of strings, each element will be converted to a row in the table.

Parameters:

• json (Constant) – A STRING scalar or vector containing JSON objects. If it is a STRING scalar, it can contain one or more JSON objects. JSON arrays and recursive JSON objects are not supported yet.

• schema (Constant, optional) –

  A table that specifies the column names and types. It can contain the following columns:

  Column	Description
  name	a string representing the column name
  type	a string representing the column type.
  format	a string specifying the format of date or time columns.

• keyCaseSensitive (Constant, optional) – Indicates whether keys are case-sensitive. true (default) means case sensitive, false means case insensitive.