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 wrote: > Hi, > > Is it possible to store results in to a file with determined filename, > instead of part-r-0? Ho

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 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 '%aacc%'); > > Help much a

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