spark-sql

create table mt_info_day6(src int, tel string,submit_time string,smscontent string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '#' STORED AS TEXTFILE;

load data local inpath '/home/MT_INFO_DAY.txt' into table mt_info_day6;

create table teldb(tel string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\r\n' STORED AS TEXTFILE;
load data local inpath '/home/dengyulei/TEL.TXT' into table teldb;


create table tel_segment(tel string,city string,operator string ) partitioned  by(province string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;
hive> insert into table test
    > partition (age='25')
    > select id, name, tel
    > from wyp;


select sum(*) from (select count(*) from mt_info_day union all select count(*) from mt_info_day2 union all select count(*) from mt_info_day3 union all select count(*) from mt_info_day4 union all select count(*) from mt_info_day5 union all select count(*) from mt_info_day6) tmp;

select * from (select * from mt_info_day union all select * from mt_info_day2 union all select * from mt_info_day3 union all select * from mt_info_day4 union all select * from mt_info_day5 union all select * from mt_info_day6) tmp sort by rand() limit 100;