hive 的ARRAY,MAP,STRUCT使用

1.创建表

CREATE TABLE employees (

name STRING,

salary FLOAT,

subordinates ARRAY<STRING>,

deductions MAP<STRING, FLOAT>,

address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>

)

PARTITIONED BY(country STRING, state STRING)

ROW FORMAT DELIMITED 

FIELDS TERMINATED BY ','

COLLECTION ITEMS TERMINATED BY '|'

MAP KEYS TERMINATED BY ':';

2.导入数据

load data local inpath '/data/employees_1'
overwrite into table employees partition(country = 'CH',state = 'BeiJin');
 
load data local inpath '/data/employees_2'
overwrite into table employees partition(country = 'US',state = 'NY');

3.查询所有数据

4.查询array中的数据

5.查询MAP中的数据

6.查询

有问题欢迎指教，欢迎学习交流