Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB