Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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.

Don't have an account?
Coming from Hortonworks? Activate your account here