I wrote some hive udfs you can use with a macro to process complex types without lateral view or custom udfs.
I wrote about them here: https://tech.trivago.com/2019/01/30/a-new-functional-approach-to-complex-types-in-apache-hive/
they are open sourced aswell. https://github.com/trivago/hive-lambda-sting
Let me know what you think.
Thanks to trivago for offering me the time to do this