[jira] [Created] (ZEPPELIN-1494) Bind JDBC result to a dataset on the zeppelin context

["Nathan Scully (JIRA)" <ji...@apache.org>]

Nathan Scully created ZEPPELIN-1494:
---------------------------------------

             Summary: Bind JDBC result to a dataset on the zeppelin context
                 Key: ZEPPELIN-1494
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1494
             Project: Zeppelin
          Issue Type: Improvement
            Reporter: Nathan Scully


There doesn't seem to be an easy way to leverage the JDBC interpreter to offload the work to a database then use the result in the following paragraph. I would like an easy way for a team to write SQL using a predefined connection against our database then use python to work with the results.

E.g.
{code}
%jdbc(dataset='mytableresult')
SELECT 1 FROM mytable;
{code}
Then access it:
{code}
%python
df =z.datasets('mytableresult)
{code}

The only other way I could see this working is using pyspark and the sqlc.read.jdbc but having to remember the URLs and driver etc is impractical unless they could be accessed as properties from the main context. Eg:
{code}
%pyspark
jdbcDF = sqlc.read.format("jdbc").options(z.interpreters.jdbc()).load()
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)