I had tried this, but not work. and the sys works with '|'.
2012-04-13
Best Regards
Andes
Email:ylyy-1...@163.com
发件人：Tucker, Matt
发送时间：2012-04-13 21:32
主题：RE: to change hive delimiter->'||'
收件人："user@hive.apache.org"
抄送：
I’m not sure how multiple-charact
You can not have a '||' with the delimted serde. Just insert dummy
columns in your DML.
id - name
5 || bob
create table people ( id int, dummy1 string , name string)
On Fri, Apr 13, 2012 at 9:30 AM, Tucker, Matt wrote:
> I’m not sure how multiple-character delimiters work with Hive, but you mi
I’m not sure how multiple-character delimiters work with Hive, but you might
try escaping each pipe (“\|\|”). I had a similar issue with using pipes in
str_to_map().
Matt Tucker
From: ylyy-1985 [mailto:ylyy-1...@163.com]
Sent: Friday, April 13, 2012 9:24 AM
To: hive_user
Subject: to change hive
