MSCEWI2062
JSON value was not recognized due to invalid format
Medium
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.
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);
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;
- Be sure the JSON have the expected format according to the Teradata grammar.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 1yr ago