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:21 PM, t p <tauis2...@gmail.com> wrote: > > 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 > temp tables. This approach allowed me to work with dynamic forms in a more > meaningful way e.g. use SQL results to create a new drop down to drive the > next page etc… > > > >> On Jan 5, 2017, at 12:57 PM, Benjamin Kim <bbuil...@gmail.com> wrote: >> >> We are getting “out of shared memory” errors when multiple users are running >> SQL queries against our PostgreSQL DB either simultaneously or throughout >> the day. When this happens, Zeppelin 0.6.0 becomes unresponsive for any more >> SQL queries. It looks like this is being caused by too many locks being >> taken and not released, transactions never closing, and/or connections never >> closing. Has anyone encountered Zeppelin 0.6.0 such an issue as this? If so, >> is there a solution for it? >> >> Thanks, >> Ben >