Steve, Scalar projection errors usually happen when you use "foo.bar" syntax instead of "foo::bar" (and a relation called foo happens to exist) or, possibly, if there is a relation you create inside a nested foreach, and another one with identical name outside. The former doesn't seem to be present in the snippet you provided. The latter has been fixed iirc (and I think it actually manifested in a different error, don't remember off the top of my head). Would really need to see the complete script to reproduce the error and see what's going on.
Jagat -- are you sure the code you pasted is what you are getting errors on? For starters, it doesn't have balanced parenthesis. It's also unclear to me what you are trying to do with the "as" clause. D On Tue, Jun 5, 2012 at 5:53 AM, Subir S <[email protected]> wrote: > It was very nice to know answers to these, since it will help while > upgrading from 0.8.1 to 0.10.0 pig. > > On Sun, Jun 3, 2012 at 11:38 PM, Jagat <[email protected]> wrote: > >> Hello everyone , >> >> I also came across one bug in 0.10.0 would like to confirm following >> behaviour which i observed. >> >> myGroup = group myData by ( SUBSTRING(NAME,0,1) as FIRST_LETTER; >> >> Assume NAME is present in myData >> >> Syntax error, unexpected symbol at or near 'SUBSTRING' >> >> The above code used to work in 0.8 version , with 0.10 version it gives >> error above. >>
