[jira] [Created] (ZEPPELIN-3716) Passing parameters from one paragraph to another

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

Dmitriy created ZEPPELIN-3716:
---------------------------------

             Summary: Passing parameters from one paragraph to another
                 Key: ZEPPELIN-3716
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-3716
             Project: Zeppelin
          Issue Type: Improvement
            Reporter: Dmitriy


(this is my first ticket, feel free to find wrong things in it and update).

We haven't found a solution for a problem on SOF ([https://stackoverflow.com/questions/51783199/apache-zeppelin-passing-parameters-between-different-interpreters] ), so I propose to have a new feature in Zeppelin.

It will help a lot to have a capability to pass one paragraph's result to another paragraph as the values of the dropdown list. Example:

I'm building a dashboard in Apache Zeppelin using org.postgresql.Driver to connect to Greenplum database. Usually I use something like:

{{where country_title like '${country=UK,UK|USA|Canada|%}' }}

to pass parameters into my query. But I have a long list of other parameters (like "towns") which I also need to pass to my query. And they are different for different _country_title_ values. I can use something like:

{{select towns from towns_by_country where country_title like '${country=UK,UK|USA|Canada|%}' }}

to get a list of towns. How can I use it as a parameter in drop-down menu (WITH '%', of course).

We can use _z.angularBind_ or _z.put_ & _z.get_ , of course. But they work in _%spark_ interpreters, not in custom interpreters. And custom interpreters for connecting with DBs are easy and fun to use in Zeppelin.

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)