hive sql之:最大登录天数,获取连续登录指定天数
create table test2( id string, pday string);INSERT INTO test2(id,pday) values ('A','20190701');INSERT INTO test2(id,pday) values ('A','20190702');INSERT INTO test2(id,pday) values ('A','20190703');INSERT INTO test2(id,pday) values ('A','20190704'