Hi Pankaj, Appreciate for great feedbacks.
1. What I need is one input box at the top and bind the remaining paragraphs with it I have created an issue https://issues.apache.org/jira/browse/ZEPPELIN-1363. it might be related. Zeppelin's interpreter abstraction allows any interpreter creates something like Z context. To expose Z context to user in %jdbc interpreter, we need proper syntax for it. i.e. %spark interpreter expose Z context as scala api. %pyspark interpreter expose Z context as python api. %jdbc interpreter expose Z context as ..? 2. Store query result into a spark data frame in Master branch (0.7.0-SNAPSHOT), table type result form any interpreter can be accessed by resource pool. You'll get some idea from https://www.zeppelinhub.com/viewer/notebooks/bm90ZTovL21vb24vTWFjQm9vay82NzcyNjU0NTI3YTY0YTk1YWE4NDhkMGU2Y2QzYTUzMS9ub3RlLmpzb24 3. Using basic display system with query result. Yes, you can use %html in the cell in table output. Check http://zeppelin.apache.org/docs/latest/displaysystem/basicdisplaysystem.html#table 4. Pulling some paragraphs from different notebooks. I know some 3rd party service supports this feature[1], but currently Zeppelin doesn't. I think simplest way of supporting this(or similar) feature is let z.run(PRARAGRPH_ID) api work with paragraphs not only in the same Note but also with all other notebooks. Then a master notebook can call the other paragraphs using z.run(PARAGRPH_ID) and collect graphs. 5. Authorization in dynamic form. Thanks for good suggestion. Do you mind file an issue? 6. Label overlaps Do you mind file an issue for this? 7. click visualization element invoke action. You can create custom visualization in JS inside of Zeppelin notebook and watch bind any action using angular display system [2]. But it'll be nice if there're some simpler way that can leverage build-in visualization. Thanks, moon [1] http://help.zeppelinhub.com/creating_composers [2] http://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/displaysystem/back-end-angular.html#watch-unwatch-variables On Fri, Aug 19, 2016 at 12:46 AM Pankaj Singh <pankajksingh...@gmail.com> wrote: > Hi All, > > Couple of weeks I was experimenting zeppelin to create interactive > visualization. Since the cleaned data was available in mysql database in > structured format %jdbc was the obvious choice. > > Since I wanted the dashboard to be interactive I used available dynamic > forms available by default. > > Below are couple of challenges which I faced while using %jdbc > interpreter, If it seems valid enhancement I can go and create defects for > them > > > > 1. *Something similar to z context in %jdbc interpreter* - I have a *input > box* which takes number of days as input . I have a number of > paragraph which has same *input box.* What I need is one input box at > the top and bind the remaining paragraphs with it. ? > 1. Can I use something similar to Z context here > 2. *Store query result into a spark data frame* : The second > requirement is to execute a mysql query using %jdbc and store the result as > spark data frame. Basically the requirement is to create multiple temp > table after executing a single sql query and create various type of > visualization based on those temp queries. > 3. *Using Basic Display System with query result* : Can I use %html > inside query output . The requirement is – A query output has a column > which stores url and I wish to appear as an anchor tag so that it is > clickable. > 4. *Easy way of pulling some paragraphs from different notebooks* : I > have different groups of user which need different type of visualization , > the visualization which I want to show can be same/different or mixed. Is > it possible to create a master notebook with alls the paragraph and then > create notebooks by pulling some paragraph from it. Its not copy but can be > thought as reference. > 5. *Authorization* - I have used Dynamic form ( text box), Now I want > to authorize user to modify the value in text box and execute the paragraph > but does not allow him to read/modify the sql query. Currently with the > available permission (owner/read/write) its not possible . > 6. *Default visualization* – The default visualization bar chart shows > the label horizontally. When the number of label increases say to 40-50 or > length of text of a label increases I was able to see overlaps in the label > text. Is there a way to choose particular portion of the graph and then > zoom that portion. > 7. *click on a visualization element to invoke any paragraph action* : > To make visualization sort of drill down is it possible to invocation a > different paragraph by clicking a bar chart. Its like taking input from bar > chart as an argument to next paragraph and then execute and transition to > that paragraph. > > Thanks for your inputs and help > > ~Pankaj > >
