获取两个时刻间的所有分钟

SELECT FROM_UNIXTIME(time_long + (number - 1) * 60, 'HH:mm:ss') AS statistic_time
FROM(
  SELECT UNIX_TIMESTAMP(time_str, 'HH:mm:ss') AS time_long, ROW_NUMBER() OVER(ORDER BY time_str) AS number
  FROM(
    SELECT EXPLODE(SPLIT(TRIM(REPEAT(CONCAT('09:00:00', ' '),
           CAST((UNIX_TIMESTAMP('23:00:00', 'HH:mm:ss') - UNIX_TIMESTAMP('09:00:00', 'HH:mm:ss'))/60 AS INT))), ' ')) AS time_str
  ) tb1
) tb2