skip to main content
Input REST file syntax : Table definition entries : Columns with nested objects
  

Try DataDirect Drivers Now

Columns with nested objects

The driver supports objects with nested objects. When generating the relational view, the driver flattens nested objects to the table of the parent object.
A column with three nested columns takes the following form for a column with three nested objects. You can define one or more nested objects in a column definition.
"<column_name>":{
"<nested_column1>":"<data_type>",
"<nested_column2>","<data_type>",
"<nested_column3>","<data_type>"
}
column_name
is the name of the column that contains the nested object.
nested_column
specifies the data type mapping for the map key.
data_type
specifies the data type mapping for the corresponding column.
The following example demonstrates defining a column with nested objects:
"address":{"line1":"varchar(256)", "zip":"integer", "city":"varchar(256)"}