Randy Gelhausen created ZEPPELIN-1459:
-----------------------------------------
Summary: Zeppelin JDBC URL properties mangled
Key: ZEPPELIN-1459
URL: https://issues.apache.org/jira/browse/ZEPPELIN-1459
Project: Zeppelin
Issue Type: Bug
Components: Interpreters
Reporter: Randy Gelhausen
I'm using Phoenix's thin client which needs to include a property at the end of
the JDBC URL.
I can set the driver up correctly in the Interpreter menu, and the first
paragraph runs successfully:
%jdbc(phoenix) select count(*) from system.catalog
But any paragraphs beyond the first fail with "No suitable driver found errors."
I added debug statements to dump the interpreter properties and found that
between paragraph 1 and 2, the "serialization=PROTOBUF" value at the end of
phoenix.url gets split into its own phoenix property.
select count(*) from system.catalog'
INFO [2016-09-19 12:15:45,558] ({pool-2-thread-2}
JDBCInterpreter.java[interpret]:462) - PropertyKey: phoenix, SQL command:
'select count(*) from system.catalog'
INFO [2016-09-19 12:15:45,561] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:217) - PROPS: {user=phoenixuser,
url=jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF,
password=, hbase.client.retries.number=1,
driver=org.apache.calcite.avatica.remote.Driver}
INFO [2016-09-19 12:15:45,561] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:218) -
org.apache.calcite.avatica.remote.Driver
INFO [2016-09-19 12:15:45,575] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:223) - URL:
jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF, EMPTY AUTH
INFO [2016-09-19 12:15:45,745] ({pool-2-thread-2}
SqlCompleter.java[getSqlKeywordsCompletions]:142) - JDBC
DriverName:/phoenix-remote-jdbc-driver-sql.keywords
INFO [2016-09-19 12:15:45,916] ({pool-2-thread-2}
SchedulerFactory.java[jobFinished]:137) - Job remoteInterpretJob_1474301745528
finished by scheduler org.apache.zeppelin.jdbc.JDBCInterpreter2049516896
INFO [2016-09-19 12:15:58,598] ({pool-2-thread-2}
SchedulerFactory.java[jobStarted]:131) - Job remoteInterpretJob_1474301758598
started by scheduler org.apache.zeppelin.jdbc.JDBCInterpreter2049516896
INFO [2016-09-19 12:15:58,598] ({pool-2-thread-2}
JDBCInterpreter.java[interpret]:453) - Run SQL command '(phoenix)
select * from system.catalog'
INFO [2016-09-19 12:15:58,598] ({pool-2-thread-2}
JDBCInterpreter.java[interpret]:462) - PropertyKey: phoenix, SQL command:
'select * from system.catalog'
INFO [2016-09-19 12:15:58,599] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:217) - PROPS: {serialization=PROTOBUF,
user=phoenixuser, url=http://localhost:8765, password=,
hbase.client.retries.number=1, driver=org.apache.calcite.avatica.remote.Driver}
INFO [2016-09-19 12:15:58,599] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:218) -
org.apache.calcite.avatica.remote.Driver
INFO [2016-09-19 12:15:58,599] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:223) - URL: http://localhost:8765, EMPTY
AUTH
ERROR [2016-09-19 12:15:58,600] ({pool-2-thread-2}
JDBCInterpreter.java[executeSql]:432) - Cannot run select * from system.catalog
java.sql.SQLException: No suitable driver found for http://localhost:8765
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
