Hi Jinhang I don't think hive supports multi character delimiters. The hassle free option here would be to preprocess the data using mapreduce to replace the multi character delimiter with another permissible one that suits your data. Regards Bejoy K S
-----Original Message----- From: jinhang du <dujinh...@gmail.com> Date: Wed, 25 May 2011 19:56:16 To: <user@hive.apache.org> Reply-To: user@hive.apache.org Subject: Hive create table Hi all, I want to custom the delimiter of the table in a row. Like my data format is '1&&&&2&&&&4‘, and how could I create a table (int, int, int) Thanks. -- dujinhang