7.00.02 - JSONParser Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
TextColumn
Specifies the name of the input table column that contains the JSON string.
Nodes
Specifies the parent/child pairs. All pairs must have the same format. You can specify a parent with multiple children with this syntax:
parent_node/{child_node [,…]}
SearchPath
[Optional] Specifies the path to find the direct value of the child. To reach the grandparent, include it in this path. When you include the path to the grandparent, you can output all siblings of the parent by including them in the Nodes argument. If anything from root is to be parsed, represent it as either '/' or an empty string. Default behavior: The function does not output the direct values of the children.
Delimiter
[Optional] Specifies the delimiter that separates multiple children with the same name and the same parent node in the JSON String. Default: ',' (comma).
The delimiter cannot include '#'.
MaxItemNum
[Optional] Specifies the maximum number of nodes with the same name to display in the output. Default: 10.
NodeIDOutputColumn
[Optional] Specifies the name of the column to use in the result schema to contain the identifier (from the input table) of the each node extracted. Default: 'out_nodeid'.
ParentNodeOutputColumn
[Optional] Specifies the name of column to use in the result schema to contain the tag name of the parent node extracted. Default: 'out_parent_node'.
Accumulate
[Optional] Specifies the names of the input table columns to copy to the output table.
ErrorHandler
[Optional] Specifies whether the function continues processing when the input table contains bad data (for example, invalid UTF-8 characters) and adds an error column to the output table. Default: 'false' (the function aborts).

The name of the error column is output_column. Default: ERROR_HANDLER.

The error column contains the data from each specified input_column, separated by semicolons. If you specify no input_column, the error column is empty.