Hello Dmitriy,

My apology for missing braces , actually i removed extra stuff from the
code to make it general.

as i am using just to give alias name.

You can read it as SUBSTRING inside group By clause for 0.10

On Wed, Jun 6, 2012 at 8:03 AM, Dmitriy Ryaboy <[email protected]> wrote:

> 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.
> >>
>

Reply via email to