java读取hive查询结果,hive sql 多结果拼接查询

select case when size(appusage) < 100 then 'num_100'

when size(appusage) < 100 then 'num_100'

when size(appusage) < 200 then 'num_200'

when size(appusage) < 300 then 'num_300'

when size(appusage) < 400 then 'num_400'

when size(appusage) < 500 then 'num_500'

when size(appusage) < 600 then 'num_600'

when size(appusage) < 700 then 'num_700'

when size(appusage) < 800 then 'num_800'

when size(appusage) < 900 then 'num_900'

when size(appusage) < 1000 then 'num_1000'

when size(appusage) < 1500 then 'num_1500'

when size(appusage) < 2000 then 'num_2000'

when size(appusage) < 3000 then 'num_3000'

else 'other' end

from miuicore.screentime_user_raw_data

group by

case when size(appusage) < 100 then 'num_100'

when size(appusage) < 100 then 'num_100'

when size(appusage) < 200 then 'num_200'

when size(appusage) < 300 then 'num_300'

when size(appusage) < 400 then 'num_400'

when size(appusage) < 500 then 'num_500'

when size(appusage) < 600 then 'num_600'

when size(appusage) < 700 then 'num_700'

when size(appusage) < 800 then 'num_800'

when size(appusage) < 900 then 'num_900'

when size(appusage) < 1000 then 'num_1000'

when size(appusage) < 1500 then 'num_1500'

when size(appusage) < 2000 then 'num_2000'

when size(appusage) < 3000 then 'num_3000'

else 'other' end