23138

Zeppelin Oracle SQL query runs forewer

Question:

I am trying to use Zeppelin (v 0.7.0 java 1.8 on Windows 10; same with <a href="https://github.com/dylanmei/docker-zeppelin" rel="nofollow">docker</a> v .0.7.1) JDBC interpreter to query Oracle Database.

So far I've found papers like <a href="http://developers-club.com/posts/269769/" rel="nofollow" title="devclub intro">example</a>. 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

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

<blockquote>

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

</blockquote>

In the same time I don't have an issue using spark interpretor with scala over jdbc same driver.

<ul><li>at least when I provide wrong password it prints meaningful response</li> </ul>

Answer1:

Are you sure a query is running?

selec 1 from dual

is not valid SQL.

Check on Oracle side in gv$session for your query. If it is running, it will be there.

Recommend

  • Apache Zeppelin: Running code automatically on startup?
  • Apache Zeppelin 0.6.1: Run Spark 2.0 Twitter Stream App
  • Is it possible to use Jupyter Notebook for AWS Glue instead of Zeppelin
  • Suddenly getting ORA-12514 error Oracle 11gr2
  • How to change aws-ec2 instance type?
  • Is there a way to create a table and some initial partitions dynamically?
  • Can't connect to Oracle using tns
  • Apache Zeppelin - Set default interpreter
  • SOAP with Attachment / MIME content
  • Iterating over a container bidirectionally
  • How to configure a timeout for an SQL query in Groovy?
  • Android NFC read Tags issue. Activity starts each time on data received
  • openssl handshake failed
  • How to resolve docker host names (/etc/hosts) in containers
  • Regex to match a string not followed by anything
  • Uncaught TypeError: $(…).select2 is not a function
  • Tomcat memory Leak
  • Why cepheus don't send int without quotes to orion?
  • Element.tagName for python not working
  • How can I speed up CURL tasks?
  • Do I need to reset a Perl hash index?
  • Display images in Django
  • How to render a blob on a canvas element?
  • Django rest serializer Breaks when data exists
  • Seeking advice on Jetty HttpClient Hang
  • Why is an OPTIONS request sent to the server?
  • Spring security and special characters
  • Can a Chrome extension content script make an jQuery AJAX request for an html file that is itself a
  • Circular dependency while pushing http interceptor
  • AngularJs get employee from factory
  • How to set the response of a form post action to a iframe source?
  • Change div Background jquery
  • need help with bizarre java.net.HttpURLConnection behavior
  • Authorize attributes not working in MVC 4
  • Observable and ngFor in Angular 2
  • How to Embed XSL into XML
  • UserPrincipal.Current returns apppool on IIS
  • Conditional In-Line CSS for IE and Others?
  • Python/Django TangoWithDjango Models and Databases
  • Net Present Value in Excel for Grouped Recurring CF