创建表-添加数据

佚名 6年前 (2019-04-19) 随笔 1308人围观抢沙发百度已收录

set mapreduce.job.queuename=root.kg;
set hive.exec.dynamic.partition.mode=nonstrict;

drop table if exists kg_fk_city;

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

set mapreduce.job.queuename=root.kg;
set hive.exec.dynamic.partition.mode=nonstrict;
create table kg_fk_city(
start_id bigint,
end_id bigint
)
row format delimited fields terminated by '\t';

set mapreduce.job.queuename=root.kg;
set hive.exec.dynamic.partition.mode=nonstrict;
load data local inpath '/home/kg/qiaoruihua/hive_test/city/city.txt' into table kg_fk_city;

set mapreduce.job.queuename=root.kg;
set hive.exec.dynamic.partition.mode=nonstrict;
select count(start_id) from kg_fk_city where hex(start_id)<hex(end_id);