Error happening while using json_tuple syntax in hive script Error happening while using json_tuple syntax in hive script hadoop hadoop

Error happening while using json_tuple syntax in hive script


The '.' operator is only supported for structs or list of structs.You are trying to apply that on a STRING type.

You probably need something like this:

SELECT x.event_type, x.app_id, x.idfa, x.idfvFROM in_app_logs aLATERAL VIEW JSON_TUPLE(    a.event,   'ev',   'global.app_id',   'global.ios.idfa',   'global.ios.idfv') x AS event_type, app_id, idfa, idfv