I found the cause and it is working now! What I found is that, in beeline it accepts ";" at the end of the query, but it throws an exception in zeppelin.
Cheers, Gene On Fri, Apr 24, 2015 at 10:50 PM, Gene Wang <[email protected]> wrote: > Thanks moon, > yes, I missed the 'Interpreter binding' part, but now the issue is I am > getting a different error now. > I can do this query from beeline: beeline> !connect > jdbc:hive2://dev-app2:10000, where a spark-cassandra-jdbc server is running. > > ======== > > ERROR [2015-04-24 21:40:03,074] ({pool-2-thread-2} > HiveInterpreter.java[executeSql]:157) - Can not run select * from > report_short_history_report limit 3; > > org.apache.hive.service.cli.HiveSQLException: > org.apache.spark.sql.hive.HiveQl$ParseException: Failed to parse: select * > from report_short_history_report limit 3; > > ======== > > On Fri, Apr 24, 2015 at 3:58 PM, moon soo Lee <[email protected]> wrote: > >> Hi, >> >> If your zeppelin-site.xml has HiveInterpreter, there're two things to >> check. >> >> First, make sure you have created HiveInterpreter setting in >> 'Interpreter' menu. >> And then check if your notebook have selected that hive interpreter >> setting. You can see >> 'Interpreter Binding' screen when you click small 'gear' icon on upper >> right corner of your noteobok. >> >> Hope this helps. >> >> Thanks, >> moon >> >> On Sat, Apr 25, 2015 at 3:09 AM Gene Wang <[email protected]> wrote: >> >>> Hi, >>> >>> I have just built zeppelin with Spark 1.2, Hadoop 2.0.0 from latest git >>> checkout https://github.com/apache/incubator-zeppelin, the built was >>> done on ubuntu 14.4, then I copied zeppelin-site.xml.template >>> <https://github.com/apache/incubator-zeppelin/blob/master/conf/zeppelin-site.xml.template> >>> to zeppelin-site.xml >>> <https://github.com/apache/incubator-zeppelin/blob/master/conf/zeppelin-site.xml.template>, >>> which has org.apache.zeppelin.hive.HiveInterpreter, which enabled me >>> to select hive as interpreter, but after restart and run %hive queries, the >>> log shows "Interpreter hive not found", I turned on debug for the the >>> log still not seeing much more info. >>> Any suggestions or ideas? >>> >>> Thanks, >>> Gene >>> =========== >>> 1) error: >>> Interpreter hive not found >>> org.apache.zeppelin.notebook.Note.run(Note.java:263) >>> org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:531) >>> org.apache.zeppelin.socket.NotebookServer.onMessage(NotebookServer.java:119) >>> org.java_websocket.server.WebSocketServer.onWebsocketMessage(WebSocketServer.java:469) >>> org.java_websocket.WebSocketImpl.decodeFrames(WebSocketImpl.java:368) >>> org.java_websocket.WebSocketImpl.decode(WebSocketImpl.java:157) >>> org.java_websocket.server.WebSocketServer$WebSocketWorker.run(WebSocketServer.java:657) >>> >>> 2) properties in zeppelin-site.xml >>> <property> <name>zeppelin.interpreters</name> >>> <value>org.apache.zeppelin.spark.SparkInterpreter,org.apache.zeppelin.spark.PySparkInterpreter,org.apache.zeppelin.spark.SparkSqlInterpreter,org.apache.zeppelin.spark.DepInterpreter,org.apache.zeppelin.markdown.Markdown,org.apache.zeppelin.angular.AngularInterpreter,org.apache.zeppelin.shell.ShellInterpreter,org.apache.zeppelin.hive.HiveInterpreter</value> >>> <description>Comma separated interpreter configurations. First interpreter >>> become a default</description></property> >>> >> >
