Yep, totally cool. We call it 'data catalog', it's very useful tool. If there is more people in favour of that feature I'll try to find time to contribute it to Zeppelin On Apr 8, 2015 9:06 AM, "IT CTO" <[email protected]> wrote:
> Personally I think what you are trying to achieve is a cool feature which > I love having in the product. e.g. an ability to bind to a metastore and > derive the SQL\Table list\Fields list from it as a helper util for driving > the SQL. > Eran > > On Wed, Apr 8, 2015 at 8:59 AM, Ophir Cohen <[email protected]> wrote: > >> Thanks you for your response, I'll take a look. >> >> On Wed, Apr 8, 2015 at 3:49 AM, moon soo Lee <[email protected]> wrote: >> >>> Hi, Ophir. >>> >>> I think currently there's no way to to inject variable to %sql. >>> I have created issue for it. >>> https://issues.apache.org/jira/browse/ZEPPELIN-32 and it is implemented >>> in https://github.com/apache/incubator-zeppelin/pull/27. >>> >>> Please see https://www.youtube.com/watch?v=QdjZyOkcG_w >>> https://github.com/apache/incubator-zeppelin/pull/27 has code for the >>> video in the comment. >>> >>> Thanks, >>> moon >>> >>> On Mon, Apr 6, 2015 at 3:22 AM Ophir Cohen <[email protected]> wrote: >>> >>>> Hi, >>>> I'm trying to use the %sql with variable created beforehand and it >>>> does not work. >>>> >>>> *My setup:* >>>> 1. Zeppelin that runs on top of Spark in yarn-client mode with 4 nodes. >>>> 2. Hive as the underneath layer, i.e. %sql goes to Hive metastore >>>> >>>> *This is what I want to achieve:* >>>> 1. Collect table list and present it to the user on a dropdown >>>> 2. When the user choose a table, it gets table's field list and present >>>> it in a dropdown >>>> 3. Then the user choose field a SQL query submitted something as >>>> follows: >>>> *"select * from <choose table> order by <choose filed>"* >>>> And present its results in table (same as return from %sql or %table). >>>> >>>> I encountered few problems: >>>> 1. I couldn't 'inject' pre calculate variables into %sql statement. I >>>> tried using println (that works for %table) but it does not work. >>>> 2. I tried using %table. With that I have few problems: >>>> 1. it does not work on the same box and I need to put it in the next >>>> box (and its poor UX as the user need to choose in the first box >>>> and than to run the next one to get the 'nice' table). >>>> and >>>> 2. I need to create the %table format (with tabs etc...) instead of >>>> using direct %sql. >>>> >>>> >>>> Hope I was clear... >>>> >>>> I guess the straight forward should have be a way to 'inject' variables >>>> into %sql statement. >>>> Is that possible? >>>> >>>> Thanks, >>>> Ophir >>>> >>> >> > > > -- > Eran | CTO >
