[ https://issues.apache.org/jira/browse/PIG-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13066082#comment-13066082 ]
Alan Gates commented on PIG-2159: --------------------------------- Dmitry, I don't see this as a blocker for 0.9. It does not produce wrong results and users can rewrite their scripts to work around it. I agree it should go on the 0.9 branch and be part of the anticipated 0.9.1 release. > New logical plan uses incorrect class for SUM causing for ClassCastException > ----------------------------------------------------------------------------- > > Key: PIG-2159 > URL: https://issues.apache.org/jira/browse/PIG-2159 > Project: Pig > Issue Type: Bug > Affects Versions: 0.9.0 > Reporter: Vivek Padmanabhan > Priority: Blocker > Fix For: 0.9.0 > > Attachments: PIG-2159-1.patch, PIG-2159-2.patch > > > The below is my script; > {code} > A = load 'input1' using PigStorage(',') as > (f1:int,f2:int,f3:int,f4:long,f5:double); > B = load 'input2' using PigStorage(',') as > (f1:int,f2:int,f3:int,f4:long,f5:double); > C = load 'input_Main' using PigStorage(',') as (f1:int,f2:int,f3:int); > U = UNION ONSCHEMA A,B; > J = join C by (f1,f2,f3) LEFT OUTER, U by (f1,f2,f3); > Porj = foreach J generate C::f1 as f1 ,C::f2 as f2,C::f3 as f3,U::f4 as > f4,U::f5 as f5; > G = GROUP Porj by (f1,f2,f3,f5); > Final = foreach G generate SUM(Porj.f4) as total; > dump Final; > {code} > The script fails at while computing the sum with class cast exception. > Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to > java.lang.Double > at org.apache.pig.builtin.DoubleSum$Initial.exec(DoubleSum.java:82) > ... 19 more > This is clearly a bug in the logical plan created in 0.9. The sum operation > should have processed using org.apache.pig.builtin.LongSum, but instead 0.9 > logical plan have used org.apache.pig.builtin.DoubleSum which is meant for > sum of doubles. And hence the ClassCastException. > The same script works fine with Pig 0.8. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira