I'm sorry if this is too simple or too tangled up, I just started Pig a few days ago . I have this table of orders and it has a column where we store the number of items i in a single order and then, in the backend part of our project, we loop through that number and create columns named as 'product_i' in which we store the reference of said product.
My problem now is that I need to find the highest selling products through pig , and for that I have to extract the product references from the columns that we created but I have no idea how I can do that since the size of an order is variable .
Anyone has an idea on how I can do this?
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
