Zeppelin Oracle SQL查询先行运行 [英] Zeppelin Oracle SQL query runs forewer

查看:254
本文介绍了Zeppelin Oracle SQL查询先行运行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试使用Zeppelin(Windows 10上的v 0.7.0 Java 1.8;与 docker 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.

到目前为止,我已经找到了示例之类的论文.我尝试将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:InterpreterSetting的共享进程ID:2CMBZV4T1,名称:jdbc DEBUG [2017-06-15 16:03:28,203]({Thread-90} InterpreterSetting.java [getInterpreterProcessKey]:143)-getInterpreterProcessKey:用于InterpreterSetting的shared_process ID:2CMBZV4T1,名称:jdbc DEBUG [2017-06-15 16:03:28,204]({Thread-90} InterpreterSetting.java [getInterpreterProcessKey]:143)-getInterpreterProcessKey:用于InterpreterSetting的shared_process ID:2CMBZV4T1,名称:jdbc DEBUG [2017-06-15 16:03:28,204]({Thread-90} InterpreterFactory.java [getInterpreterSessionKey]:1244)-解释器会话密钥:shared_session,请注意:2CMEC9SS4,用户:匿名,InterpreterSetting名称:jdbc DEBUG [2017-06-15 16:03:28,205]({Thread-90} InterpreterSetting.java [getInterpreterProcessKey]:143)-getInterpreterProcessKey:用于InterpreterSetting的shared_process ID:2CMBZV4T1,名称:jdbc DEBUG [2017-06-15 16:03:28,205]({Thread-90} InterpreterSetting.java [getInterpreterProcessKey]:143)-getInterpreterProcessKey:用于InterpreterSetting的shared_process ID:2CMBZV4T1,名称: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

与此同时,在jdbc相同的驱动程序上使用带有Scala的Spark解释器时,我没有任何问题.

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查询先行运行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆