Support Questions

Find answers, ask questions, and share your expertise

HDP 2.5 & zeppelin 0.6.0 problem

Explorer

when i create new mysql interpreter, and create a new notebook to test, there is something wrong like this

"(the paragraph is

%jdbc

use spider;

show tables;

)"

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show tables' at line 2 class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:526) com.mysql.jdbc.Util.handleNewInstance(Util.java:425) com.mysql.jdbc.Util.getInstance(Util.java:408) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:356) org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442) org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94) org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341) org.apache.zeppelin.scheduler.Job.run(Job.java:176) org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162) java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) java.util.concurrent.FutureTask.run(FutureTask.java:262) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:745)

1 REPLY 1

It was a known issue in HDP-2.5 that multiline sql statements were not supported. It has been fixed in HDP-2.6