Drill Down
I am trying to create a drill down in Zeppelin on some data. Taking the bank data in the example I have this paragraph: %sql select concat('%html ',job,''), sum(balance),avg(balance) from bank group by job order by job Which displays the data I want. But was trying to get the next paragraph to update when I click on each of the links - say retired: %sql select marital, sum(balance) from bank where job='${type=sevices}' group by marital i.e. I wanted the variable type be updated and then the paragraph run when someone clicks on each link in the previous paragraph. I can see if I use %angular I should be able to do this. But that does not work in the cell of a table. And cannot get the tag to work - tried a few on-click etc... Is this possible? Guess other approach would be to not return a table but an %angular and do all the formatting with in that? Any tips or clues would be helpful. Thanks
Other paragraphs do not wait for %sh paragraphs to finish.
I often have notebooks that have a %sh as the 1st paragraph. This scps some file from another server, and then a number of spark or sparksql paragraphs are after that. If I click on the run-all paragraphs at the top of the notebook the 1st %sh paragraph kicks off as expected, but the 2nd %spark notebook starts too at the same time. The others go into pending state and then start once the spark one has completed. Is this a bug? Or am I doing something wrong? Thanks
Accessing Zeppelin Data from JDBC/Thrift server
I was wanting to access data from a JDBC client using SQL. I can access data fine from Zeppelin and have the Thrift server running. I can access/create data from the JDBC client via Thrift. But Zeppelin and Thrift are running as a different application, so I can not see data from Zeppelin in Thrift - even global_temp is not visible across applications. Is there any simple way round this? Thanks
Re: Accessing Zeppelin Data from JDBC/Thrift server
Issue is when I connect using JDBC via Thrift server I can not see data I created in Zeppelin is the issue. If I connect to Thrift from multiple clients they can all see each others data fine. Thank for the help. On 12/05/2017 19:13:08, Jeff Zhang wrote: I didn't quite understand your problem. Are you sure you are connecting to the same thrift server that you create data via jdbc client ? And do you use the same user to access it ? MurexConsultant mailto:murexconsult...@googlemail.com]>于2017年5月12日周五 上午11:08写道: I was wanting to access data from a JDBC client using SQL. I can access data fine from Zeppelin and have the Thrift server running. I can access/create data from the JDBC client via Thrift. But Zeppelin and Thrift are running as a different application, so I can not see data from Zeppelin in Thrift - even global_temp is not visible across applications. Is there any simple way round this? Thanks