Home Forums Pig Javascript UDF return Empty results

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  tedr 1 year, 2 months ago.

  • Creator
    Topic
  • #27714

    Eran Sagi
    Member

    Hi,

    I’ve written a PIG LATIN batch which loads a CSV file.
    To support DateAdd calculation I’ve written and registered a javascript function:
    Enclosed is the Java Script:
    Calcadd.outputSchema = “result:long”;
    function Calcadd(curdate) {
    var tmp = curdate.replace(“-”, “/”);
    var tmp = tmp.replace(“-”, “/”);
    var tmp2 = new Date(tmp);
    tmp2.setDate(tmp2.getDate() – 7);
    var y = tmp2.getFullYear();
    var m = (tmp2.getMonth()+1);
    var d = tmp2.getUTCDate();
    var result = (y * 10000 + m * 100 + d);
    return {long:result};
    }

    Enclosed is the register tag of the batch:
    register ‘C:\Samples\Calc.Js’ using javascript as myfunctions;

    Enclosed is the invocation:
    D = FOREACH C GENERATE DeviceID, CountryTwoLetterName, myfunctions.Calcadd(tmpDATE) as newData;
    E = DUMP D;

    the tmpDate field is a 10 character char array : ’2012-04-21′ Representing 4Y-MM-DD structure
    The Dump statement returns empty values for the ‘newData’ field (the output of the UDF)

    I’ll appreciate and insights
    Thanks,

    Eran

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #28704

    tedr
    Moderator

    Hi Eran,

    Does the javascript work when run outside of pig?

    Thanks,
    Ted

    Collapse
Viewing 1 replies (of 1 total)