Re: Fill Dropdownlist with sql result

I don’t think there is a way to accomplish this using JDBC or PSQL interpreter. https://zeppelin.apache.org/docs/0.7.3/manual/dynamicform.html This can be accomplished using spark interpreter where you can programatically create d

Re: Drill Down

Happy to share some thoughts here. I did not find an easy way to do this for postgres/psql or other interpreters. Here is what I did using the spark interpreter. I am not doing drill down via html links, but via select/drop drown list. Hopefully you can do something for links. Here is the ang

Re: zeppelin memory usage

Running in a VM we’ve noticed Zeppelin consume lot of memory and have encountered out-of-memory and GC issues - with a couple of users. In our case, I attributed it to the use-case: Spark interpreter connecting to a Postgres DB to load few tables into data frames which had large number of rows

Re: Passing variables from %pyspark to %sh

hat feature to share results between paragraphs and > different interpreters. I think this would be one of major features in a next > release. > > On Thu, Jan 12, 2017 at 10:30 PM, t p <mailto:tauis2...@gmail.com>> wrote: > Is it possible to have similar support to exchang

Re: Passing variables from %pyspark to %sh

Is it possible to have similar support to exchange checkbox/dropdown variables and can variables be exchanged with other interpreters like PSQL (e.g. variable set by spark/pyspark and accessible in another para which is running PSQL interpreter). I’m interested in doing this and I’d like to kn

Intermittent failures when running SQL using %spark.sql

I see intermittent failures which disappear if I hit the play button multiple times when I run SQL using %spark.sql. Example of error below. Note that if I invoke the same query using using spark.sql() API and then invoke z.show(), everything works fine. Have others noticed this? Version 0.6.2

Re: PostgreSQL JDBC Connections

xports to CSV will look identical. > On Jan 5, 2017, at 5:30 PM, Benjamin Kim wrote: > > We are using the JDBC interpreter. The business analysts only know SQL and > run ad-hoc queries for their report exports to CSV. > > Cheers, > Ben > > >> On Jan 5, 2017, at 2:

Re: PostgreSQL JDBC Connections

Are you using JDBC or the PSQL interpreter? I had encountered something similar while using the PSQL interpreter and I had to restart Zeppelin. My experience using PSQL (Postgresql, HAWK) was not as good as using spark/scala wrappers (JDBC data source) to connect via JDBC and then register tem

sql interpreter output as input to a dynamic form

Using psql/postgres interpreter, I’d like to: - Store the result of a query into a form/variable in one paragraph - Use that form/variable as an input to drive the results/visualization of the second paragraph The documentation here outlines how one can use forms in queries, however it does not

Re: line graph after psql query

value? > On Dec 14, 2016, at 5:14 PM, t p wrote: > > I’m using the plotting features of the table display system. I’m using the > postgres/psql interpreter. I noticed a few issues and I’m hoping that someone > can point me in the right direction to resolve these issues: >

line graph after psql query

I’m using the plotting features of the table display system. I’m using the postgres/psql interpreter. I noticed a few issues and I’m hoping that someone can point me in the right direction to resolve these issues: 1) I’m unable to display a value on y-axis (number field) as is (it forces me to