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.

Reply via email to