How about using the explicit cast like
ordered = ORDER query BY (int)z; Alcaid ------------------ Original ------------------ From: "Patcharee Thongtra";<patcharee.thong...@uni.no>; Date: Fri, May 30, 2014 06:02 PM To: "user"<user@pig.apache.org>; Subject: java.lang.String cannot be cast to java.lang.Integer Hi, I got very strange exception. 80693 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias ordered. Backend error : java.lang.String cannot be cast to java.lang.Integer 14/05/30 11:53:22 ERROR grunt.Grunt: ERROR 1066: Unable to open iterator for alias ordered. Backend error : java.lang.String cannot be cast to java.lang.Integer In my pig script below, z is integer but pig complains as it is String. query = load 'fino32' USING org.apache.hcatalog.pig.HCatLoader() as ( date: chararray, u: float, v: float, t: float, zone: int, z: int); ordered = ORDER query BY z; dump ordered; Any suggestion is appreciated. Patcharee
