My hive table has the complicated structure as columns such as array and struct.

for example, the table definition:

 hive> desc books;
id int
name string
lang struct<eng:int,chn:int>
types array<string>
price float
Time taken: 0.234 seconds, Fetched: 5 row(s)

To insert the values for columns lang and types, I have to use the dummy syntax as follows.

 hive> insert into books select 101,"learning spring boot",NAMED_STRUCT("eng",1,"chn",0),array("programming","web"),29.99;

To select the last inserted values:

 hive> select * from books order by id desc limit 1;
101 learning spring boot {"eng":1,"chn":0} ["programming","web"] 29.99
Time taken: 2.45 seconds, Fetched: 1 row(s)

Return to home | Generated on 09/29/22