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"<user@hive.apache.org> 抄送: 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 delimiter->'||' hi, all. I see something strange. the defaule delimiter is \001 and I want to change to '||'. So I just run my command : CREATE TABLE table1( channelid INT,serviceno STRING,regid STRING,pageurl STRING,urlext STRING,pagetitle STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '||' stored as textfile; then I load the txt data(with one record="12||12003||2131||44123||22222||112") into the table, select * from the table, I see that the 6 fields are filled with "12","","12003","","2131","" I think the empty value is "\t",which replace the "||", am I right? I think there is some other ways to replace the delimiter and make hive work fine(of cause we can overwrite the inputformat class). 2012-04-13 Best Regards Andes Email:ylyy-1...@163.com