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 Threaded View
Pig >> mail # user >> Number format exception : For input string


Copy link to this message
-
Re: Number format exception : For input string
FYI - I think Jose just put the asterisks for emphasis. I believe it should
be -
1369546091667L (to indicate a long constant)
On 2 July 2013 21:07, jose moreno <[EMAIL PROTECTED]> wrote:

> Hi,
>
> I not sure if this is the right channel for this question. Anyway, the
> issue is related with the number format. Pig does not recognized long
> format numbers by default (that is why it works with the 3 digits less).
> Please try with:
> Data = LOAD 'part-r-00000' AS (session_start_gmt:long)
> FilterData = FILTER Data BY  session_start_gmt=1369546091667*L*
>
> P.S.: I didn't test the code, sorry if it does not work.
>
>
> 2013/7/2 Mix Nin <[EMAIL PROTECTED]>
>
> > 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
> >
>
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