fields terminated by ‘,’
collection items terminated by ‘#’
select std_id,stud_name,city,new_course from std_course lateral explode (course) new_course_list as course;
fields terminated by ‘,’
collection items terminated by ‘#’
select std_id,stud_name,city,new_course from std_course lateral explode (course) new_course_list as course;