Thanks for your information. It works. 在 2011年5月25日 下午9:57，valentina kroshilina <kroshil...@gmail.com>写道：
> you can use something like this: > > CREATE EXTERNAL TABLE IF NOT EXISTS table1 ( > str1 int, > str2 int, > str3 int > ) > ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' > With SERDEPROPERTIES ( > "input.regex"="(\\d+)&&&&(\\d+)&&&&(\\d+)" > ) > LOCATION '/path1; > > > 2011/5/25 jinhang du <dujinh...@gmail.com> > >> 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 >> > > > > -- > valentina kroshilina > -- dujinhang
