Dear All. i having some issue with combining two columns fields into single fields as STruct type. below code i tried but still getting the same issue? create table dummy_TBL2 (id int,fname string ,lname string) ;
insert into dummy_TBL2 (id,fname,lname) values(1,'bhau','anna') ; //dummy side
now below show the struct table:-
create table data_TBL2 (id int, name struct<fname:string,lname:string>)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;//in this table i took name as struct type
___inserting the data from dummy into struct type-----
insert into table data_TBL2
select id,
name(fname,lname)
from dummy_TBL2 limit 1; Thanks HadoopHelp
... View more
