Environment: Impala version 4.1 Scenario: I have a table that has an id column and a JSON column, like so: id json_col 111 [{"m_id":"896de41d","name":"DE"},{"m_id":"194a3028","name":"Free"}] 222 [{"m_id":"687c6baa","name":"Texti"},{"m_id":"194a3028","name":"Default"},{"m_id":"896de41d","name":"Parcel"}] Is there a function that dynamically takes out m_id and name attrtibutes into rows per id? I tried the GET_JSON_OBJECT function but I'm not sure if it has that ability.

Impala: Dynamically extract JSON attributes into rows

Environment: Impala version 4.1

Scenario: I have a table that has an id column and a JSON column, like so:

id	json_col
111	[{"m_id":"896de41d","name":"DE"},{"m_id":"194a3028","name":"Free"}]
222	[{"m_id":"687c6baa","name":"Texti"},{"m_id":"194a3028","name":"Default"},{"m_id":"896de41d","name":"Parcel"}]

Is there a function that dynamically takes out m_id and name attrtibutes into rows per id?

I tried the GET_JSON_OBJECT function but I'm not sure if it has that ability.