Dear all, I am doing optimization for multiple join. I am not sure if Pig can decide the join order in optimization layer. Does anyone know about this? Or Pig just execute the query as the way it is written.
And, I want to do the multiple way Join on different keys. Can the following query work? Res = JOIN (JOIN catalog_sales BY cs_item_sk, inventory BY inv_item_sk) BY (cs_item_sk, cs_order_number), catalog_returns BY (cr_item_sk, cr_order_number); BTW, each time, I run the query, it is finished in one second. Is there a way to see the execution time? I have set the pig.udf.profile=true. Where can I find the time? Bests, Mingda