商城分析

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

;