Check the log file, you can find more information about the error. The log file could be found from the URL given below.
At 2011-05-27 20:07:17，"jinhang du" <dujinh...@gmail.com> wrote: 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<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
