Yes, the script (i.e. The select statement) runs fine in hive cli, hue and also in spark sql ( spark sql also in zeppelin). Just not when using the hive interpreter in zeppelin.
Sent from my iPhone Am 19.05.2017 um 19:35 schrieb Jongyoul Lee <jongy...@gmail.com<mailto:jongy...@gmail.com>>: 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<mailto: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
