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

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -