You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Patcharee Thongtra <Pa...@uni.no> on 2014/06/02 23:49:12 UTC

Backend error : java.lang.String cannot be cast to java.lang.Integer

Hi,

I am using hive with pig. In my pig script I tried to query and sort 
data from a hive table as below:

query = load 'fino31' USING org.apache.hive.hcatalog.pig.HCatLoader();
z_query = FILTER query BY zone==2 and z >= 2 and z <= 9;
z_order = ORDER z_query by z;
dump z_order;

the column 'z' is integer, but I got an error
ERROR grunt.Grunt: ERROR 1066: Unable to open iterator for alias 
z_order. Backend error : java.lang.String cannot be cast to 
java.lang.Integer

Any ideas?

Patcharee