Hi, I am using hadoop 1.2 and hive 0.81 from cloudera. I am getting the following exception while executing the on external tables.
My table : CREATE EXTERNAL TABLE logdata(createddate STRING,threadname STRING,logginglevel STRING,classname STRING,message STRING)ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES("input.regex" = "^\\s*([0-9]+[\\-\\/][0-9]+[\\-\\/][0-9]+\\s+[0-9]+\\:[0-9]+\\:[0-9]+[\\,\\:][0-9]+)[\\s*\\=]+(\\[?[a-zA-Z\\-0-9\\:\\s\\/\\.]+?\\]?)[\\s+\\=]+([A-Z]+)[\\s+\\>]+([\\S]+)\\s*[\\-\\=]?\\s*\\>?(.*)", "ouput.regex" = "%1$s %2$s %3$s %4$s %5$s") STORED AS TEXTFILE LOCATION '/data/logdata'; My query: ======= select threadname from logdata; I am get the following exception. Any help.. *Job running in-process (local Hadoop)* *Hadoop job information for null: number of mappers: 1; number of reducers: 0* *2012-08-03 11:16:44,532 null map = 0%, reduce = 0%* *Ended Job = job_1343884647410_0012 with errors* *Error during job, obtaining debugging information...* *Examining task ID: task_1343884647410_0012_m_000000 (and more) from job job_1343884647410_0012* *Exception in thread "Thread-18" java.lang.IllegalArgumentException: Does not contain a valid host:port authority: local* * at org.apache.hadoop.net.NetUtils.createSocketAddr(NetUtils.java:206)* * at org.apache.hadoop.net.NetUtils.createSocketAddr(NetUtils.java:158)* * at org.apache.hadoop.net.NetUtils.createSocketAddr(NetUtils.java:147)* * at org.apache.hadoop.hive.ql.exec.JobTrackerURLResolver.getURL(JobTrackerURLResolver.java:42) * * at org.apache.hadoop.hive.ql.exec.JobDebugger.showJobFailDebugInfo(JobDebugger.java:198) * * at org.apache.hadoop.hive.ql.exec.JobDebugger.run(JobDebugger.java:83)* * at java.lang.Thread.run(Thread.java:662)* *Execution failed with exit status: 2* *Obtaining error information* * * *Task failed!* *Task ID:* * Stage-1* * * *Logs:* * * */tmp/root/hive.log* *FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask* -- Thanks, Khadar