Created on 06-20-2017 01:07 PM - edited 08-17-2019 08:40 PM
Hey everyone,
My case today is a little weird for me cause according to me I'm running the right scripts but well anyways, the thing is that I need load a file with a char structure but then I need to delete the headers and set the right structure relation.
Here my code:
Finally, I'm trying to perform a sum using this new structure but Pig always according with the log return an error casting the column with the new format as long for salary and int for the year so is like Pig won't be able to get the new structure.
Error:
Could some of our gurus let me know the right way to get a nice transformation and perform my scripts.
thanks so much
Created 06-22-2017 06:37 PM
Created 06-22-2017 06:37 PM
Instead of
year as (year:int)
try
(int) year as castedYear:int
Created 06-23-2017 07:18 PM
Thanks so much @Lester Martin I appreciate your help now worked, I replaced my statement using yours and it worked.
salaries_cl = FOREACH salaries_fl GENERATE (int)year as year:int,$1,$2,$3, (long)salary as salary:long;
Weird why the other one didn't work but well thanks so much.