Home | About | Sematext search-lucene.com search-hadoop.com
 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
> >
>