2015-03    2015-03-10    cookie1

2015-03    2015-03-10    cookie5

2015-03    2015-03-12    cookie7

2015-04    2015-04-12    cookie3

2015-04    2015-04-13    cookie2

2015-04    2015-04-13    cookie4

2015-04    2015-04-16    cookie4

2015-03    2015-03-10    cookie2

2015-03    2015-03-10    cookie3

2015-04    2015-04-12    cookie5

2015-04    2015-04-13    cookie6

2015-04    2015-04-15    cookie3

2015-04    2015-04-15    cookie2

2015-04    2015-04-16    cookie1

2015-02    2015-02-16    cookie2

2015-02    2015-02-16    cookie3

create table uv(month string,day string, id string) row format delimited fields terminated by '\t';

load data local inpath '/home/centos/files/pv.txt' into table uv;

    SET hive.exec.mode.local.auto=true;

select month ,count(distinct id) from uv group by month;

select day ,count(distinct id) from uv group by day;

select month ,count(distinct id) from uv group by month union all select day ,count(distinct id) from uv group by day;

select month, day,count(distinct id), grouping__id from uv group by month,day grouping sets(month,day);

select month, day,count(distinct id), grouping__id from uv group by month,day with cube order by grouping__id;

select month, day,count(distinct id), grouping__id from uv group by month,day with rollup order by grouping__id;