question hive insert into struct fields get_json

question hive insert into struct fields get_json_object in Support Questions https://community.cloudera.com/t5/Support-Questions/hive-insert-into-struct-fields-get-json-object/m-p/81028#M4105 Hello I have hdfs json files, specifically the files are tweets messages in json format, i'm trying to read that files with hive into a table. i'm using the function get_json_object to extract each element of the json an insert in a table field. Te problem is that i don't know how to manage struct fields, for example i have defined in th testination table a struct field with several fields for example, the field retweeted_status  is a srutct field with two fields :   first i create a table to insert the tweets like a string: CREATE EXTERNAL TABLE `tweets_raw`( `json_response` string)   then i create a second table where i want to split each json field in a table field. i created the next table:   CREATE TABLE tweets (    in_reply_to_status_id_str string,   in_reply_to_status_id string,   created_at STRING,   in_reply_to_user_id_str STRING,   source string ,   retweeted_status STRUCT<     in_reply_to_status_id_str:STRING,     in_reply_to_status_id:STRING       >,   retweet_count STRING, ....   then, using the function get_json_object , i'm trying to insert data with a sentence like this: INSERT overwrite table tweets SELECT cast(get_json_object(json_response, '$.in_reply_to_status_id_str') as STRING), cast(get_json_object(json_response, '$.in_reply_to_status_id') as STRING), cast(get_json_object(json_response, '$.created_at') as STRING), cast(get_json_object(json_response, '$.in_reply_to_user_id_str') as STRING), cast(get_json_object(json_response, '$.source') as STRING), struct( cast(get_json_object(json_response, '$.retweeted_status.in_reply_to_status_id_str') as STRING), cast(get_json_object(json_response, '$.retweeted_status.in_reply_to_status_id') as STRING) ) as retweeted_status ,  cast(get_json_object(json_response, '$.retweet_count') as STRING), ... the simple fileds are ok, bur i don't know how insert the struct field retweeted_status , i try several things but none work, using struct( cast(get_json_object(json_response, '$.retweeted_status.in_reply_to_status_id_str') as STRING),           cast(get_json_object(json_response, '$.retweeted_status.in_reply_to_status_id') as STRING)          )   hive give me the next error: <DIV class="snippet-execution-status"> <DIV class="snippet-error-container alert alert-error"> <UL> <LI>Error while compiling statement: FAILED: SemanticException [Error 10044]: line 1:23 Cannot insert into target table because column number/types are different 'tweets': Cannot convert column 5 from struct<col1:string,col2:string> to struct<in_reply_to_status_id_str:string,in_reply_to_status_id:string>.</LI> </UL> </DIV> </DIV> <DIV class="snippet-code-resizer ui-draggable"> </DIV> <DIV class="snippet-code-resizer ui-draggable">anyone know how to insert values in a struct field?</DIV> <DIV class="snippet-code-resizer ui-draggable">Thanks inadvance for your help</DIV> <DIV class="snippet-code-resizer ui-draggable">best regards</DIV> <DIV class="snippet-code-resizer ui-draggable">diego</DIV>   Fri, 16 Sep 2022 13:48:02 GMT dcond 2022-09-16T13:48:02Z