Hi, I am trying to load a pi delimited file. After reading the documentation, I believe this is possible.
* The default delimiter is a tab. You can specify any character as a literal ("a"), * a known escape character ("\\t"), or a dec or hex value ("\\u001", "\\x0A"). My pig script: A = LOAD '/user/pi.txt' USING PigStorage('<various things I've tried>'); B = FOREACH A GENERATE $0; DUMP B; pi.txt: oneπtwoπthree Regardless of what I've tried, I cannot get the desired output of "one." Instead, because I am not passing the right delimiter, the output is "oneπtwoπthree." Can anyone help me load a pi delimited file? Thank you in advance for your help! -Rob ________________________________________________________ The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.