All native UDFs on Hive can also be used on Treasure Data. The complete list of UDFs can be found on the HiveQL Language Manual’s UDF page.
Native UDF can parse nested JSON records
Nested JSON records can be parsed by using Hive’s native get_json_object UDF function. However, we recommend that you maintain a flat JSON structure to avoid additional CPU performance overhead.