unable to query the external hive table in which data is being parsed using regex -
i being able fire select * kind of queries not select col1....type of queries. throws following exception
error during job, obtaining debugging information... examining task id: task_201305021530_0007_m_000002 (and more) job job_201305021530_0007 exception in thread "thread-90" java.lang.runtimeexception: error while reading task log url @ org.apache.hadoop.hive.ql.exec.errors.tasklogprocessor.getstacktraces(tasklogprocessor.java:240) @ org.apache.hadoop.hive.ql.exec.jobdebugger.showjobfaildebuginfo(jobdebugger.java:227) @ org.apache.hadoop.hive.ql.exec.jobdebugger.run(jobdebugger.java:92) @ java.lang.thread.run(thread.java:722) caused by: java.net.unknownhostexception: avishkar-vb @ java.net.abstractplainsocketimpl.connect(abstractplainsocketimpl.java:178) @ java.net.sockssocketimpl.connect(sockssocketimpl.java:391) @ java.net.socket.connect(socket.java:579) @ java.net.socket.connect(socket.java:528) @ sun.net.networkclient.doconnect(networkclient.java:180) @ sun.net.www.http.httpclient.openserver(httpclient.java:378) @ sun.net.www.http.httpclient.openserver(httpclient.java:473) @ sun.net.www.http.httpclient.<init>(httpclient.java:203) @ sun.net.www.http.httpclient.new(httpclient.java:290) @ sun.net.www.http.httpclient.new(httpclient.java:306) @ sun.net.www.protocol.http.httpurlconnection.getnewhttpclient(httpurlconnection.java:995) @ sun.net.www.protocol.http.httpurlconnection.plainconnect(httpurlconnection.java:931) @ sun.net.www.protocol.http.httpurlconnection.connect(httpurlconnection.java:849) @ sun.net.www.protocol.http.httpurlconnection.getinputstream(httpurlconnection.java:1299) @ java.net.url.openstream(url.java:1037) @ org.apache.hadoop.hive.ql.exec.errors.tasklogprocessor.getstacktraces(tasklogprocessor.java:192) ... 3 more failed: execution error, return code 2 org.apache.hadoop.hive.ql.exec.mapredtask mapreduce jobs launched:
@ankur found solution problem. need add path of hive-contrib-..*.jar in classpath. or can add path in hive cli before fire query :
add jar /home/hadoop/hive/lib/hive-contrib-0.8.1.jar; (mind version of hive)
Comments
Post a Comment