Consolidation of Questionnaire Questions and Answers

The obtained question and answer are in json format, and the field is map. It is necessary to separate the serial number from the following questions or answers. The method of lateral view explode is used. Compared with explode, lateral view explode can select non-burst field

It should be noted that the two fields after the explosion do not need parentheses. If there is a where, where is placed at the end

 select q_key, q_valuefrom questionnairelateral view explode(questions) t as q_key, q_value

You can use lateral view explode multiple times

 select q_key, q_value, a_key, a_valuefrom questionnairelateral view explode(questions) t as q_key, q_valuelateral view explode(answers) t2 as a_key, a_valuewhere q_key=a_key