Is this suppose to be working on pig 5 ?
On 5/16/10 4:47 PM, "Syed Wasti" <[email protected]> wrote: > Hmmm,,, not really, it doesn't show the \n if I don't use the bincond operator > on that column... > > > On 5/16/10 4:33 PM, "Dmitriy Ryaboy" <[email protected]> wrote: > >> In that case, maybe it's the data, and what you think is null is actually >> '\n' ? >> >> -D >> >> On Sun, May 16, 2010 at 4:07 PM, Syed Wasti <[email protected]> wrote: >> >>> Doing absolutely the same thing and I am using pig 6 too. >>> Tried with the fake data on both local and mapreduce modes, works fine. >>> But on my script against actual data in mapreduce mode, it fails to do the >>> same thing, places \N instead of U. >>> >>> grunt> rel1 = LOAD '/user/swasti/data' USING PigStorage('\t') as (num); >>> grunt> dump rel1; >>> (1) >>> (2) >>> (3) >>> () >>> (5) >>> grunt> find_null = FOREACH rel1 GENERATE (num is null?'U':num); >>> grunt> dump find_null; >>> (1) >>> (2) >>> (3) >>> (U) >>> (5) >>> >>> >>> On 5/16/10 2:23 PM, "Dmitriy Ryaboy" <[email protected]> wrote: >>> >>>> So what I am saying is, check that you are not inserting some weird >>>> non-ascii quotes in your actual script. >>>> I just ran this on Pig 6, it worked: >>>> >>>> grunt> data = load 'tmp/nulltest' using PigStorage() as (num); >>>> grunt> dump data; >>>> (1) >>>> (2) >>>> () >>>> (3) >>>> grunt> find_nulls = foreach data generate ( num is null ? 'U' : num ); >>>> grunt> dump find_nulls; >>>> (1) >>>> (2) >>>> (U) >>>> (3) >>>> >>>> I double-checked just in case, and it works in both local and mapreduce >>>> modes. >>>> >>>> -Dmitriy >>>> >>>> On Sun, May 16, 2010 at 1:49 PM, Syed Wasti <[email protected]> wrote: >>>> >>>>> Hmm not sure why, I used quotes in this mail, let me rewrite, >>>>> SQL(U is within single quotes): NVL(city,U) city >>>>> Pig(U is within single quotes): (city is null?U:city) AS city >>>>> >>>>> >>>>> >>>>> On 5/16/10 1:36 PM, "Dmitriy Ryaboy" <[email protected]> wrote: >>>>> >>>>>> Syed, >>>>>> The samples you pasted include all kinds of extraneous characters. Are >>>>> you >>>>>> sure your script is properly encoded? >>>>>> >>>>>> >>>>>> On Sun, May 16, 2010 at 1:16 PM, Syed Wasti <[email protected]> >>> wrote: >>>>>> >>>>>>> I am trying the SQL ³NVL(city, ŒU¹) city² in pig I am using the >>> >>>>>>> operator, ³(city is null?'U': city) AS city², which is of chararray >>>>> type, >>>>>>> the result file shows Œ\N¹ instead of U. Any ideas ? >>>>>>> >>>>> >>>>> >>>>> >>> >>> >>>
