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
