問題描述
我正在嘗試使用 Zeppelin(Windows 10 上的 v 0.7.0 java 1.8；與 docker<相同)/a> v .0.7.1) 用于查詢 Oracle 數據庫的 JDBC 解釋器.
I am trying to use Zeppelin (v 0.7.0 java 1.8 on Windows 10; same with docker v .0.7.1) JDBC interpreter to query Oracle Database.
到目前為止，我已經找到了諸如 example 之類的論文.我嘗試使用 jdbc 解釋器:
So far I've found papers like example. I try to use jdbc interpreter with:
common.max_count=100
default.driver=oracle.jdbc.pool.OracleDataSource
default.password:$password
default.user=$my_user_name
default.url=jdbc:oracle:thin:@$host:1521/$service_name>
zeppelin.jdbc.concurrent.max_connection=10
zeppelin.jdbc.concurrent.use=true
連接看起來已成功建立*，但即使是最簡單的查詢(如sql% select 1 from dual)也會永遠運行.
Connection looks to be established successfully*, but even simplest query (like sql% select 1 from dual) runs for ever.
有人知道/知道要添加什么嗎?
Does anyone knows/have a clue on what is to be added?
我在終端看到的 - 重復行
what I see in terminal - repeating lines
sKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbcDEBUG [2017-06-15 16:03:28,203] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbcDEBUG [2017-06-15 16:03:28,204] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbcDEBUG [2017-06-15 16:03:28,204] ({Thread-90} InterpreterFactory.java[getInterpreterSessionKey]:1244) - 解釋器會話密鑰:shared_session，注意:2CMEC9SS4，用戶:匿名，解釋器設置名稱:jdbcDEBUG [2017-06-15 16:03:28,205] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbcDEBUG [2017-06-15 16:03:28,205] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc
sKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc DEBUG [2017-06-15 16:03:28,203] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc DEBUG [2017-06-15 16:03:28,204] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc DEBUG [2017-06-15 16:03:28,204] ({Thread-90} InterpreterFactory.java[getInterpreterSessionKey]:1244) - Interpreter session key: shared_session, for note: 2CMEC9SS4, user: anonymous, InterpreterSetting Name: jdbc DEBUG [2017-06-15 16:03:28,205] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc DEBUG [2017-06-15 16:03:28,205] ({Thread-90} InterpreterSetting.java[getInterpreterProcessKey]:143) - getInterpreterProcessKey: shared_process for InterpreterSetting Id: 2CMBZV4T1, Name: jdbc
與此同時，我在使用帶有 Scala 的 spark 解釋器而不是 jdbc 相同的驅動程序時沒有問題.
In the same time I don't have an issue using spark interpretor with scala over jdbc same driver.
- 至少當我提供錯誤的密碼時，它會打印出有意義的響應
推薦答案
您確定查詢正在運行嗎?
Are you sure a query is running?
selec 1 from dual
不是有效的 SQL.
在 gv$session 中檢查 Oracle 端的查詢.如果它正在運行，它就會在那里.
Check on Oracle side in gv$session for your query. If it is running, it will be there.
這篇關于Zeppelin Oracle SQL 查詢優先運行的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！