hive 创建表，

hive 创建表，

create table

create database xxx;
create external table if not exists xxx.userkey_sid_rank_expo(
userkey string,
sid string,
rec_time string,
rank string,
rtoken string,
expo string,
pv string,
duration string
)
partitioned by (dt string)
row format delimited
fields terminated by '\t'
;

insert data

insert overwrite table userkey_sid_rank
partition (dt='20181106') 
select
a.userkey
from table

add columns

alter table xxx add columns xx string;