Re: store to defined filename

2014-05-16 Thread Raviteja Chirala
You can either do Hadoop mv if its a wrapper script or do getMerge to merge and rename all part files to single part file. On May 14, 2014, at 2:11 AM, Patcharee Thongtra patcharee.thong...@uni.no wrote: Hi, Is it possible to store results in to a file with determined filename, instead

Re: Need help in like operator

2013-12-06 Thread Raviteja Chirala
You can use 'matches' keyword in Pig to find out LIKE wise words. On Dec 6, 2013, at 2:17 PM, Krishnan Narayanan krishnan.sm...@gmail.com wrote: Hi All How to write the below query to pig, can i use REGEX_EXTRACT_ALL ? select * from temp where column1 like ( '%abc%' or '%def% or

Re: escape field names

2013-12-03 Thread Raviteja Chirala
After 'load' can you use 'Define' to give alias? That's a guess. On Dec 3, 2013, at 12:22 PM, Benoit Mathieu b...@deezer.com wrote: Aida, Your suggestion don't work. Pig throws the same error, because lt is a reserved word, so you can't use it as a field name, even in a FOREACH statement.