Zeppelin using the Hive Interpreter

This Zeppelin is the official 0.5.6 version, may be in the incubation stage, there may be some bug it.

Configuration

CP zeppelin-env. sh. Template zeppelin-env. SH

VI zeppelin-env. SH

Add to:

Export java_home=/usr/lib/jvm/java-1.8. 0-openjdk-1.8. 0.65-3. B17.axs7.ppc64leexport hadoop_conf_dir=/etc/hadoop/conf

Start Zepplein

.. /bin/zeppelin-daemon. SH start

Visit http://localhost:8080

Modify Hive Interpreter

Remember to modify the point on the right restart, restart the interpreter.

Inquire

This is a reflection of this bug.

One

Corresponding interpreter log:

Cat zeppelin-interpreter-hive--ldd-1. Log

INFO [ .- One- on Ten: .: -,238] ({pool-2-thread-8} Hiveinterpreter.java[interpret]:326)-Propertykey:default, SQL command:'SELECT * from Hehe.haha'INFO [ .- One- on Ten: .: -,328] ({pool-2-thread-8} schedulerfactory.java[jobfinished]:135)-Job remoteinterpretjob_1478009213237 finished by scheduler org.apache.zeppelin.hive.HiveInterpreter197014835

Two

Log:

INFO [ .- One- on Ten: ,: the,412] ({pool-2-thread- the} Hiveinterpreter.java[interpret]:326)-PropertyKey: *, SQL command:'ect COUNT (*) from Hehe.haha'ERROR [ .- One- on Ten: ,: the,412] ({pool-2-thread- the} Job.java[run]:182) -Job failedorg.apache.zeppelin.interpreter.InterpreterException:java.lang.NullPointerException at Org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret (Classloaderinterpreter.java: A) at Org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret (Lazyopeninterpreter.java: the) at Org.apache.zeppelin.interpreter.remote.remoteinterpreterserver$interpretjob.jobrun ( Remoteinterpreterserver.java: -) at Org.apache.zeppelin.scheduler.Job.run (Job.java:169)

Three

Log:

INFO [ .- One- on Ten: One: -, -] ({pool-2-thread-5} Hiveinterpreter.java[interpret]:326)-Propertykey:default, SQL command:'Select COUNT (*) from Hehe.haha'INFO [ .- One- on Ten: One: -,568] ({pool-2-thread-5} schedulerfactory.java[jobfinished]:135)-Job remoteinterpretjob_1478009477499 finished by scheduler org.apache.zeppelin.hive.HiveInterpreter197014835

Conclusion : The official said%hive (${prefix}), if not the default prefix, but from the above can be seen, the first time without default, select * Can query, but select COUNT (*) will be error, As can be seen from the log, it identified the count (*) in parentheses in the * Propertykey,select statement parsing has also changed, resulting in the Java null pointer exception, but from the third can be seen, plus default,hive interpreter parsing and become normal. Feeling is a bug.

In general, you can use the hive interpreter. As the use of Zeppelin at that time or 0.5.6, after four months or so has been out of 3 versions, the latest version 0.6.2, more powerful. Follow up and explore its wonders.

Zeppelin using the Hive Interpreter