MSCEWI2062

JSON value was not recognized due to invalid format

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This message is shown when SnowConvert needs to deserialize JSON data for a transformation context but the JSON value didn't have the expected format or is not valid JSON.

Example code

Input Code:

SELECT
*
FROM 
 JSON_TABLE
(ON (SELECT id,
trainSchedule as ts
FROM demo.PUBLIC.Train T)
USING rowexpr('$.weekShedule.Monday[*]')
      colexpr('[ {"ordinal"  true},
                 {"jsonpath"  "$.time",
                  "type"" : "CHAR ( 12 )"},
                 {"jsonpath"  "$.city",
                  "type" : "VARCHAR ( 12 )"}]'))
AS JT(Id, Ordinal, Time, City);

SELECT
*
FROM 
 JSON_TABLE
(ON (SELECT id, 
trainSchedule as ts
FROM demo.PUBLIC.Train T)
USING rowexpr('$.weekShedule.Monday[*]')
      colexpr('{"jsonpath"  "$.time",
                  "type"" : "CHAR ( 12 )"}'))
AS JT(Id, Ordinal, Time, City);

Output Code:

SELECT
*
FROM (SELECT id /*** MSC-ERROR - MSCEWI2062 - UNRECOGNIZED JSON LITERAL [ {"ordinal"  true},
                  {"jsonpath"  "$.time",
                   "type"" : "CHAR ( 12 )"},
                  {"jsonpath"  "$.city",
                   "type" : "VARCHAR ( 12 )"}] ***/
 FROM demo.PUBLIC.Train T, TABLE(FLATTEN(INPUT =>
trainSchedule:weekShedule.Monday)) rowexpr) JT;

SELECT
*
FROM (SELECT id /*** MSC-ERROR - MSCEWI2062 - UNRECOGNIZED JSON LITERAL {"jsonpath"  "$.time",
                   "type"" : "CHAR ( 12 )"} ***/
 FROM demo.PUBLIC.Train T, TABLE(FLATTEN(INPUT =>
trainSchedule:weekShedule.Monday)) rowexpr) JT;

Recommendations

• Be sure the JSON have the expected format according to the Teradata grammar.

• If you need more support, you can email us at [email protected]