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)
