G2 Crowd User

JSON

11 months ago

How can I handle nested JSON records?

Vendor Responses

Response by Treasure Data

11 months ago

Nested JSON records can be parsed by using Hive’s native get_json_object UDF function or Presto’s native JSON functions. However, we recommend that you maintain a flat JSON structure since this command is a source of additional CPU performance overhead.