question How to get variable value in %jdbc context in Archives of Support Questions (Read Only)

How to get variable value in %jdbc context

pankaj_singh — Mon, 11 Jul 2016 19:26:32 GMT

In zeppelin notebook, there are 2 paragraphs

In paragraph 1 - I have a python script which gets value from a rest-api call and assign it to a variable. I used z.put("var1",var) to set the variable.

In paragraph-2 , I am using %jdbc to run a sql query on a mysql table. e.g select abc from tb1 where name = '<variable>'

Question is - How can i pass var1 to the query and replace <variable> with value of var1. Any hints will be helpful

Re: How to get variable value in %jdbc context

pankaj_singh — Fri, 14 Oct 2016 22:22:56 GMT

Its currently not possible as in zeppelin 0.6.

"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 ..?"