sorry, yes my question was about accessing b not $1. What's the effect of writing empty() to a file. Say if I did store b into temp then should I expect a line or nothing gets writen at all in the file.
On Thu, Mar 7, 2013 at 10:53 AM, Harsha <[email protected]> wrote: > from your schema b:bag{t:tuple(a:chararray, b:chararray)} > your tuple is inside a bag so on the next line if you are trying to access > through $1 pig will > throw up an error saying non-existent column. > but if your question is about accessing b than it will print empty () if > the there is no value present (as you are setting it as null). > > -- > Harsha > > > On Thursday, March 7, 2013 at 10:35 AM, Mohit Anchlia wrote: > > > Thanks! Does "generate" skip over that? if I did b = for B generate $1 > what > > should be expected outcome of alias "b" > > > > On Thu, Mar 7, 2013 at 10:31 AM, Harsha <[email protected] (mailto: > [email protected])> wrote: > > > > > Hi Mohit, > > > it won't convert into string literal 'NULL' since its a tuple > > > you'll see results like > > > ('Hello',) > > > > > > -- > > > Harsha > > > > > > > > > On Thursday, March 7, 2013 at 10:10 AM, Mohit Anchlia wrote: > > > > > > > Any help would be appreciated. I'll also write something shortly and > see > > > > what happens. > > > > > > > > On Wed, Mar 6, 2013 at 4:58 PM, Mohit Anchlia < > [email protected] (mailto:[email protected])(mailto: > > > [email protected] (mailto:[email protected]))>wrote: > > > > > > > > > If I define and set tuple like this: > > > > > > > > > > Tuple t1 = mTupleFactory.newTuple(2); > > > > > t1.set(0, "Hello"); > > > > > t1.set(1, NULL); > > > > > > > > > > and have schema like: > > > > > > > > > > b:bag{t:tuple(a:chararray, b:chararray) > > > > > > > > > > and then in the pig script if I do: > > > > > > > > > > page = foreach B generate b; > > > > > > > > > > > > > > > > > > > > What should be expected outcome? Would "generate" convert NULL into > > > > > literal 'NULL' as a string? Or does it skip over that NULL. > > > > > > > > > > > > > > > > > > > > > > > >
