Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig >> mail # user >> Number format exception : For input string


Copy link to this message
-
Number format exception : For input string
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
+
jose moreno 2013-07-02, 15:37
+
Abhinav Neelam 2013-07-03, 13:11