Drill Down

[murexconsultant]

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.

[murexconsultant]

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

[MurexConsultant]

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

[MurexConsultant]

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