Hive造数据

--显示建表语句
show create table data10;--创建外表
create external table rxg_db.data1026(username String,money double,register_data timestamp,cancel_data timestamp,loan string,acc string
)
row format delimited by ','
lines terminated by '\n'
stored as textfile location 'hdfs://poc70:8020/user/hive/warehouse/rxg_db.db/data1026'--往data1026中插入数据insert into rxg_db.data1026
select a.*
from
(select uuid() as username,
rand()*100 as register_data,
'2019-1025' as register_data,
'9999-12-31' as calcel_data,
'1' as loan,
'1' as acc
from pcb_db.m_acc_info limit 30000)a;--查询前十条
select * from data1026 limit10;--修改某一字段类型
alter table data1026 modify column money int;--新表data1026_newuser   临时表  data1026_new_user
select
a.username,
a.money,
a.register_data,
a.cancel_data,
a.loan,
a.acc
from rxg_db.data1026_newuser as a lift join rxg_db.data1026 as b on a.username = b.username where b.name is not null