----tables06
DROP TABLE IF EXISTS tables06 ;
create external table tables06(`area` string COMMENT '联系地址',
`num` int COMMENT '数量')
row format delimited fields terminated by ','
location '/yiyuan/result/tables06';
insert overwrite table tables06
select area,count(1) from yiyuan where length(area)>0 group by area order by area ;select * from tables06 limit 3;