hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From valentina kroshilina <kroshil...@gmail.com>
Subject Re: Hive create table
Date Wed, 25 May 2011 13:57:50 GMT
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 <dujinhang@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

Mime
View raw message