hive sql 生成分钟级别的表格

SELECT

            unix_timestamp(‘2022-11-21 00:01:00’) + a.pos * 60 AS date_timestamp,

            from_unixtime(unix_timestamp(‘2022-11-21 00:01:00’) + a.pos * 60) AS date_str

        FROM

            (

                SELECT

                    posexplode(split(repeat(‘o’, CAST((unix_timestamp(‘2022-11-21 00:10:00’) – unix_timestamp(‘2022-11-21 00:01:00’)) / 60 AS INT)), ‘o’))

            )

            a