創(chuàng)建表

hive> create table sgr(qtime string, qid string, qword string, url string) row format delimited fields terminated by ',';
hive> desc sgr;
OK
qtime                   string                                      
qid                     string                                      
qword                   string                                      
url                     string                                      
Time taken: 0.086 seconds, Fetched: 4 row(s)

加載數(shù)據(jù)

hive> load data inpath '/sougou.dic' into table sgr;

熱搜榜

hive>create table sgr_results as select keyword, count(1) as count from (select qword as keyword from sgr) t group by keyword order by count desc;

查詢結(jié)果

hive> select * from sgr_results limit 10;