Hi Vineet, I'd recommend you have a look at these excellent resources:
http://hortonworks.com/blog/pig-eye-for-the-sql-guy/ http://mortar-public-site-content.s3-website-us-east-1.amazonaws.com/Mortar-Pig-Cheat-Sheet.pdf http://www.slideshare.net/trihug/practical-pig/11 --Lorand On 28/10/14 14:34, Vineet Mishra wrote:
Hi, I was looking out to transform SQL statement which is consisting of multiple clause in the same query specifically, a JOIN followed by some condition(WHERE) and finally grouping on some fields(GROUP BY). Can I have a link or some briefing which can guide me how can I implement this k/o of complex SQL statement in PIG. Thanks!
