51Testing软件测试论坛

标题: 常用hive命令 [打印本页]

作者: liudezheng 时间: 2018-5-15 11:15
标题: 常用hive命令
DROP TABLE IF EXISTS manual.A;
CREATE TABLE  manual.A(email string,user_id string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
load data local inpath '/tmp/ldz/AA.csv' overwrite into table manual.A ;

GET_JSON_OBJECT(row_ip2dmp(ipctor,'HWIP|CN|VAL','hwipinnet.csv'), '$.CTOR') ipctor

create table 表A ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' as select * from 表B;

select group_concat(ip, ',') as groups from 表A where pt_date=20170608 and vt='pv' group by sid

show create table 表名;

hive -e 'SELECT * FROM table' > table.csv

load data local inpath '/tmp/AA.csv'  into table 表A partition (pt_year='2017',pt_month='201712',pt_date='20171217');

regexp_extract(r7,'(.*)/',1) in ('DOC1000081706','DOC1000081707','DOC1000081708','DOC1000081709',
                                 'DOC1000081710','DOC1000081702','DOC1000081703','DOC1000081704','DOC1000081701','DOC1000081700')

百分数  cast((cast((t2.pv/t1.pv) as decimal(9,4)))*100 as varchar(10))+'%'

insert into table 表A SELECT * FROM 表B;

create table if not exists

作者: qqq911 时间: 2018-5-15 11:34
感谢分享

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)