G2 Crowd Acquires Siftery to Create a New Way to Buy and Manage Software Spend 🚀
G2 Crowd User

JSON

over 1 year ago

How can I handle nested JSON records?

Vendor Responses

Response by Treasure Data

over 1 year 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.