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');
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.查询
有问题欢迎指教,欢迎学习交流