apache pig - Issues with ToDate and MonthsBetween function in pig latin -

i trying calculate number of months between 2 datetime objects following code.

abc = load '/tmp/abc_2013_06_29/*' using pigstorage('\u0001') ( open_dte: datetime, clsd_dte: datetime);

duration_in_months = monthsbetween(open_dte, clsd_dte);

i trying generate relation duration_in_months in relation. facing following error,

could not infer matching function org.apache.pig.builtin.getmonth multiple or none of them fit. please use explicit cast.

appreciate , of in-depth guide learning casting , functions in pig.

thanks, murali

your code not correct. try instead

duration_in_months = foreach abc generate monthsbetween(open_dte, clsd_dte);

O9