hadoop-hive
花与少年°
Break through 30
展开
-
hive语句记录
group by后根据count排序 select name,count(*) pc from crv.credit_xuke where cast(createtime as bigint)>1603641600000 group by name order by pc desc原创 2021-10-26 09:34:33 · 661 阅读 · 0 评论 -
Hive相关
一.建表(分区、分桶) 1.建普通表 a.语句 CREATE table dtjd.atest ( userid int,sex string ) row FORMAT DELIMITED fields TERMINATED BY '\001' STORED AS TEXTFILE b. desc 查看表结构 2.建分区表 a.语句 CREATE table dtjd.atestuser ( userid int,sex string ) PARTITIONED BY (username string)原创 2020-06-29 18:39:44 · 1247 阅读 · 0 评论