商城分析
2023-03-09 20:26 作者:一個(gè)普通的優(yōu)菈廚 | 我要投稿
create table if not exists data (
? ? id int,
? ? name string,
? ? score int,
? ? level string,
? ? title string,
? ? content string
)row format delimited
fields terminated by ','
;
load data local inpath '/root/discuz/data.txt' overwrite into table data;
select * from data limit 10;
insert overwrite local directory '/root/discuz01/'
row format delimited fields terminated by '\t'
select count(*) from data;
insert overwrite local directory '/root/discuz02/'
row format delimited fields terminated by '\t'
select count(distinct name) as user_count from data;
insert overwrite local directory '/root/discuz03/'
row format delimited fields terminated by '\t'
select name,count(*) as post_count from data
group by name
order by post_count desc,name
limit 10
;
標(biāo)簽：
