Re: Hive create table

[valentina kroshilina]

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