mysql - 在 hive/mysql 中实现 sum_reverse() [Explode table result]

Question

我们希望平均分配数量。Table Sales 如下所示

product category qty
123     A        3
345     B        2

输出

product category qty
123     A        1
123     A        1
123     A        1
345     B        1
345     B        1

Answer 1

hive

select  t.product
       ,t.category
       ,1           as qty

from    mytable t
        lateral view explode(split(space(t.qty - 1),' ')) e
;

---

+---------+----------+-----+
| product | category | qty |
+---------+----------+-----+
| 123     | A        | 1   |
+---------+----------+-----+
| 123     | A        | 1   |
+---------+----------+-----+
| 123     | A        | 1   |
+---------+----------+-----+
| 345     | B        | 1   |
+---------+----------+-----+
| 345     | B        | 1   |
+---------+----------+-----+