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 Fri, 27 May 2011 12:07:17 GMT
Are there any documents to help me understand the meaning and usage of
"input.regex"?

I create table as your introduction. And "select * from table1" returns the
right answer.
However, "select table1.str1 from table1" gains the following exception.

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201104251139_2123, Tracking URL =
http://hadoop-12.apexlab.org:50030/jobdetails.jsp?jobid=job_201104251139_2123
Kill Command = /usr/lib/hadoop/bin/hadoop job
-Dmapred.job.tracker=hadoop-12:9001 -kill job_201104251139_2123
2011-05-27 20:04:41,618 Stage-1 map = 0%,  reduce = 0%
2011-05-27 20:05:05,413 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201104251139_2123 with errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask

Can you help me? thanks.



在 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