数据按照字段某个参数复制对应次数

将某份数据按照字段某个参数复制对应次数

方法一：

SELECT A,B,b.help_topic_id FROM (
SELECT A,B,C FROM dual)a
LEFT JOIN mysql.help_topic b ON b.help_topic_id < a.C

方法二:

select * from table
lateral view posexplode(split(space(C-1)," ")) tem as time,explode_date