Thanks for the quick response.
I try '\376', but still not working :(
On 1/10/13 6:23 AM, Dean Wampler dean.wamp...@thinkbiganalytics.com
wrote:
You have to use the octal representation, e.g., ^A is \001.
On Wed, Jan 9, 2013 at 8:32 PM, Ho Kenneth - kennho
kenneth...@acxiom.comwrote:
Hi
I'd appreicate if someone can help out with this issue. Tons of thanks! :)
I have tried many different combinations but still not able to get it to
work.
Q: how do we parse delimiter - þ
On 1/10/13 8:08 AM, Ho Kenneth - kennho kenneth...@acxiom.com wrote:
Thanks for the quick response.
I
Hi all,
I have an input file that has a unicode character as a delimiter, which is þ
(thorn)
For example:
col1þcol2þcol3
Þ has a value of UTF-8(hex) 0xC3 0xBE (c3be)
And I have tried the following but no luck:
create table test(col1 string, col2 string, col3 string) row format delimited