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

Posted to mapreduce-user@hadoop.apache.org by Mix Nin <pi...@gmail.com> on 2013/07/02 17:31:11 UTC

Fwd: Number format exception : For input string

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
max_session_start_time;

I get below output
(1369546091667,1369638849418)

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.?


Thanks