Just rename your column locally in your code. You can regenerate you column names and rename them by
e.g. FOREACH A GENERATE It as 'new_name', the rest of columns you like to call. Just rename it temporary to skip the error. On 3 December 2013 16:09, Benoit Mathieu <[email protected]> wrote: > Hello, > > Is there any way to escape field names so that Pig do not throw an error > when field name is a reserved keyword ? > > Here is my script: > A = LOAD 'logs.stream5' USING org.apache.hcatalog.pig.HCatLoader(); > B = FILTER A BY lt>120; > DUMP B; > > Pig throws an ERROR because "lt" is a reserved keyword. > It's annoying because I can't change this field name, and I don't really > want to use $15 because it will break on future schema changes. > Is there any magic syntax ? > > Thanks for help. > > Benoit > -- Aida Mashkouri NajafiData Scientist T. +44(0) 20 7775 5625 [image: Infectious Media]3-7 Herbal Hill / London / EC1R 5EJwww.infectiousmedia.com [image: Infectious Media] <http://www.infectiousmedia.com/> [image: Facebook]<http://www.facebook.com/infectiousmedia>[image: Twitter] <https://twitter.com/infectiousmedia>[image: LinkedIn]<http://www.linkedin.com/company/infectious-media-ltd>[image: Youtube] <http://www.youtube.com/user/InfectiousMediaLtd> This email and any attachments are confidential and may also beprivileged. If you are not the intended recipient, please notify the senderimmediately, and do not disclose the contents to another person, use it forany purpose, or store, or copy the information in any medium. Please alsodestroy and delete the message from your computer.
