Hive知识点总结

Hive支持的数据类型

primitive_type
array_type
map_type
struct_type 

DDL

create table t1(
    id int,
    name string,
) row format delimited
  fields terminated by '\t'                 // 字段之间用'\t'隔开
  lines terminated by '\n'                  // 行元素之间用'\n'隔开
  collection terminated by ','              // 数组元素之间用','隔开
  map keys terminated by ':';               // Map元素之间用','隔开

加载数据的两种方式

load data local inpath '/user/local/test.txt' into table t1;   // 从本地文件加载数据
load data inpath '/user/local/test.txt' into table t1;         // 从hdfs文件加载数据
insert into table t1 select id, name from t2;                  // 从其他表中加载数据

分区

// 创建分区表
create table t1(
    id int,
    name string,
) PARTITIONED BY (dt string);

// 加载数据
load data local inpath '/user/local/test1.txt' into t1 partition (date = '2018-3-28')
load data local inpath '/user/local/test2.txt' into t1 partition (date = '2018-3-29')

// 查询数据
select * from t1 where date = "2018-03-28"