hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ho Kenneth - kennho <Kenneth...@acxiom.com>
Subject Re: unicode character as delimiter
Date Fri, 11 Jan 2013 00:52:40 GMT
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.Ho@acxiom.com> wrote:

>Thanks for the quick response.
>
>I try '\376', but still not working  :(
>
>
>
>On 1/10/13 6:23 AM, "Dean Wampler" <dean.wampler@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.Ho@acxiom.com>wrote:
>>
>>> 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 fields terminated by '\c3be';
>>>
>>> I'd appreciate your help! Thanks in advance.
>>>
>>> --ken
>>>
>>>
>>>
>>> 
>>>************************************************************************
>>>*
>>>**
>>> The information contained in this communication is confidential, is
>>> intended only for the use of the recipient named above, and may be
>>>legally
>>> privileged.
>>>
>>> If the reader of this message is not the intended recipient, you are
>>> hereby notified that any dissemination, distribution or copying of this
>>> communication is strictly prohibited.
>>>
>>> If you have received this communication in error, please resend this
>>> communication to the sender and delete the original message or any copy
>>> of it from your computer system.
>>>
>>> Thank You.
>>>
>>> 
>>>************************************************************************
>>>*
>>>***
>>>
>>
>>
>>
>>-- 
>>*Dean Wampler, Ph.D.*
>>thinkbiganalytics.com
>>+1-312-339-1330
>

Mime
View raw message