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 >
