hadoop-hdfs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mix Nin <pig.mi...@gmail.com>
Subject Fwd: Number format exception : For input string
Date Tue, 02 Jul 2013 15:31:11 GMT
I wrote a script as below.

Data = LOAD 'part-r-00000' AS (session_start_gmt:long)
FilterData = FILTER Data BY  session_start_gmt=1369546091667

I get below error

2013-07-01 22:48:06,510 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 1200: For input string: "1369546091667"
In detail log it says number format exception.

When I give
x = group Data ALL;
y = FOREACH  GENERATE MIN(Data.session_start_gmt) as
min_session_start_time,MAX(Data.session_start_gmt) as

I get below output

When just give session_start_gmt=1369546091 (3 digits less) it works fine

So, why is the first error coming when I compare with exact value.?


View raw message