Can you check your script works in native hive environment? On Fri, May 19, 2017 at 10:20 AM, Meier, Alexander < alexander.me...@t-systems-dmc.com> wrote:
> Hi list > > I’m trying to get a Hive interpreter correctly running on a CDH 5.7 > Cluster with Spark 1.6. Simple queries are running fine, but as soon as a > query needs a MapRed tasks in order to complete, the query fails with: > > java.sql.SQLException: Error while processing statement: FAILED: Execution > Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask > at org.apache.hive.jdbc.HiveStatement.execute( > HiveStatement.java:279) > at org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291) > at org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291) > at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql( > JDBCInterpreter.java:580) > at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret( > JDBCInterpreter.java:692) > at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret( > LazyOpenInterpreter.java:95) > at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$ > InterpretJob.jobRun(RemoteInterpreterServer.java:490) > at org.apache.zeppelin.scheduler.Job.run(Job.java:175) > at org.apache.zeppelin.scheduler.FIFOScheduler$1.run( > FIFOScheduler.java:139) > at java.util.concurrent.Executors$RunnableAdapter. > call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > etc… > > I’ve got the interpreter set up as follows: > > Properties > name value > default.driver org.apache.hive.jdbc. > HiveDriver > default.url > jdbc:hive2://[hostname]:10000 > hive.driver org.apache.hive.jdbc. > HiveDriver > hive.url > jdbc:hive2://[hostname]:10000 > zeppelin.interpreter.localRepo /opt/zeppelin/local-repo/2CJ4XM2Z4 > > Dependencies > artifact > /opt/cloudera/parcels/CDH/lib/hive/lib/hive-jdbc.jar > /opt/cloudera/parcels/CDH/lib/hive/lib/hive-service.jar > /opt/cloudera/parcels/CDH/lib/hadoop/client/hadoop-common.jar > /opt/cloudera/parcels/CDH/lib/hive/lib/hive-common.jar > /opt/cloudera/parcels/CDH/lib/hive/lib/hive-metastore.jar > > > Unfortunately I haven’t found any help googling around… anyone here with > some helpful input? > > Best regards and many thanks in advance, > Alex -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net