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