You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by Murphy Ric <mu...@gmail.com> on 2013/10/30 09:02:48 UTC

SQL code in PIG

Hi,

I have a code in SQL to convert to Pig. I request for your help in
converting this code.

WHILE @Dt1 <= @Dt2
BEGIN
INSERT INTO ( , , , )
                SELECT , , , ,
                WHERE X > Y
SELECT @Dt1 = (SELECT DATEADD(MM,1,@Dt1))
END


Thanks in Advance