1.1 - 8.10 - JSONParser Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TextColumn
Specify the name of the input table column that contains the JSON string.
Nodes
Specify 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 [,…]}
JSON has two format types for arrays:
Array Format Type Nodes Syntax Element
parent:[key:value,key:value] 'parent/key'
parent[value,value] 'parent/parent'
Root sometimes has a key:value pair, as in JSONParser Example: Default Values. To get the value of such a pair, use Nodes syntax element '/key'.
SearchPath
[Optional] Specify 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 syntax element. 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] Specify the delimiter that separates multiple children with the same name and the same parent node in the JSON String.
The delimiter cannot include '#'.
Default: ',' (comma)
MaxItemNum
[Optional] Specify the maximum number of nodes with the same name to display in the output.
Default: 10
NodeIDOutputColumn
[Optional] Specify 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] Specify 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] Specify the names of the input table columns to copy to the output table.
ErrorHandler
[Optional] Specify whether the function continues processing when the input table has 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.