获取N到0之间的所有整数数字
-- 获取0-9之间所有整数数字
select num from (select 1 k1) as t lateral view explode_numbers(9 +1) tmp1 as num
-- 获取0-N所有整数数字则为
select num from (select 1 k1) as t lateral view explode_numbers(N +1) tmp1 as num
获取0-当前小时的数字(整数)则为:
select num from (select 1 k1) as t lateral view explode_numbers(HOUR(NOW()) +1) tmp1 as num