Support Questions
Find answers, ask questions, and share your expertise

insert statement into an structured array

insert statement into an structured array

New Contributor

Need to manually insert a row in a structured array array<(structure<

The table structure is as follows:

create table emp

(

EmpID varchar(20),

EmpName varchar(100),

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.