hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jinhang du <dujinh...@gmail.com>
Subject Re: Hive create table
Date Thu, 26 May 2011 01:50:41 GMT
Thanks for your information. It works.

在 2011年5月25日 下午9:57,valentina kroshilina <kroshilina@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 <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
>



-- 
dujinhang

Mime
View raw message