Need to manually insert a row in a structured array array<(structure<
The table structure is as follows:
create table emp
EmpPhone array<struct<phone_area_code:varchar(5),phone_no: varchar(10),phone_area_type:varchar(15)>>
row format delimited
fields terminated by ','
collection items terminated by ':'
map keys terminated by ';'
Tried writing a manual insert statement, but unable to do so.
can someone help me in writing an insert statement for the above table ? Thx.