CONCAT((chararray)id, '/user/zahra/Sequence/data/') Russell Jurney twitter.com/rjurney [email protected] datasyndrome.com
On Sep 26, 2012, at 1:56 PM, "HAJIHASHEMI, ZAHRA (AG/1000)" <[email protected]> wrote: > I have two strings that I want to concatenate. The first one holds a number > and coming from this set of commands: > > library = LOAD 'discovery_library' USING > org.apache.pig.backend.hadoop.hbase.HBaseStorage('A:TISSUE' ,'-loadKey true') > as (id:int, name:chararray); > grpd = group library all; > data = foreach grpd generate MAX(library.id) as id; > > The second one is a root path. > root_path = '/user/zahra/Sequence/data/'; > > I want to concatenate these two and create new path. For example if data=268, > I would like to have : '/user/zhaji/Sequence/data/268' > When I used CONCAT(root_path, data), I got this error: > > ERROR 1000: Error during parsing. Lexical error at line 15, column 14. > Encountered: "/" (47), after : "\"" > Which is pointing to path assignment to roo_path variable! > > Thanks for any help. > > -Zahra > > This e-mail message may contain privileged and/or confidential information, > and is intended to be received only by persons entitled > to receive such information. If you have received this e-mail in error, > please notify the sender immediately. Please delete it and > all attachments from any servers, hard drives or any other media. Other use > of this e-mail by you is strictly prohibited. > > All e-mails and attachments sent and received are subject to monitoring, > reading and archival by Monsanto, including its > subsidiaries. The recipient of this e-mail is solely responsible for checking > for the presence of "Viruses" or other "Malware". > Monsanto, along with its subsidiaries, accepts no liability for any damage > caused by any such code transmitted by or accompanying > this e-mail or any attachment. > > > The information contained in this email may be subject to the export control > laws and regulations of the United States, potentially > including but not limited to the Export Administration Regulations (EAR) and > sanctions regulations issued by the U.S. Department of > Treasury, Office of Foreign Asset Controls (OFAC). As a recipient of this > information you are obligated to comply with all > applicable U.S. export laws and regulations.
