Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in batch job writing to Hive

Hello all,

 

I am trying to insert some rows in a table in Hive using big data batch job(map reduce)  with tJDBCOutput.2.PNGjob.PNG

However, I am facing the following error:

Running job: job_1527425158191_0398
map 0% reduce 0%
Task Id : attempt_1527425158191_0398_m_000000_0, Status : FAILED

Error: java.lang.ClassNotFoundException: org.apache.hive.service.cli.thrift.TCLIService$Iface
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)



To see the whole post, download it here
Labels (4)
1 Reply
Anonymous
Not applicable
Author

Hey guys, I was able to fix this issue - all those jars had to be added :


0683p000009Lupf.png

But then I got another error: Method dbrecordwriter.write not supported. Here some guys are experiencing a similar error: https://stackoverflow.com/questions/34067686/spark-1-5-1-not-working-with-hive-jdbc-1-2-0 

It is explicitly not implemented in the hive jdbc library branch-1.2 .