Why doesn't get_json_object() work to extract a value from JSON stored in a Hive SQL table?
In my hive table T the field A is a string in json format and A stores a value of {"c_e_i":"{"e_c_f":1}"}. I want to get c_e_i."e_c_f" So I used get_json_object(T.A, '$.c_e_i.\"e_c_f\"') but it doesn't work. what should I do? I…