Re: Using Zeppelin as a Visualisation tool for my SQL backend system

Thanks Venkat. I couldn't find JDBC Interpreter on default installation(out-of box installation). Is JDBC interpreter support exist by default? In order to get JDBC interpreter on Zeppelin GUI, Do I need to add any config to zeppelin-site.xml ? zeppelin.interpreters ??? Please let me k

Re: Using Zeppelin as a Visualisation tool for my SQL backend system

For more information I installed Zeppelin binary. On Thu, Apr 21, 2016 at 3:43 PM, Naresh Kancharla < naresh.kancha...@gmail.com> wrote: > Thanks Venkat. > > I couldn't find JDBC Interpreter on default installation(out-of box > installation). > Is JDBC interpreter support exist by default? > > In

Re: Using Zeppelin as a Visualisation tool for my SQL backend system

Hi Naresh, AFAIK JDBC interpreter isn't included in any binary versions yet. The JDBC docs that Venkat linked is for Zeppelin 0.6.0 SNAPSHOT. So If you want to use JDBC interpreter, you have to build from source. Here is Zeppelin github repository: https://github.com/apache/incubator-zeppelin Plea

RE: Using Zeppelin as a Visualisation tool for my SQL backend system

Hi Naresh, You can try the current psql (PostgresSQL) interpreter in the 0.5.x binaries. You can set the postgresql.driver.name and postgresql.url properties to the jdbc driver/url for your SQL engine. I have tried this and made it work for the Apache Trafodion SQL engine. Here is an exam

Re: Using Zeppelin as a Visualisation tool for my SQL backend system

I tried with interpreter psql it didn't work. I used below configuration using SQL Workbench to connect to Redshift *SQL Workbench configuration* (successfully connected) DriverName: com.amazon.redshift.jdbc41.Driver (AWS Redshift JDBC Driver. Downloaded jar for the same) UR

Re: Using Zeppelin as a Visualisation tool for my SQL backend system

Thanks Ahyoung. I followed bellow approach. I couldn't find JDBC interpreter in available interpreter list. I ran REST API to check same and JDBC not found. Attached REST API response. GET http://localhost:8080/api/interpreter Source code i could able to find JDBCInterpreter.Java and it has r

RE: Using Zeppelin as a Visualisation tool for my SQL backend system

You can copy your Redshift driver jar to the “lib” sub-folder under zeppelin install. Make sure the user account which is running zeppelin has read access to this jar file. *From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] *Sent:* Thursday, April 21, 2016 10:20 AM *To:* users@zeppelin

Re: Reg: Using Zeppelin as a Visualisation tool for my SQL backend system

Hi Naresh, You can use JDBCInterpreter for what you want to do. It needs jdbc_url only, and Zeppelin convert your result into table automatically. Hope this help, Regards, J On Thu, Apr 21, 2016 at 3:29 PM, Naresh Kancharla < naresh.kancha...@gmail.com> wrote: > Hi All, > > I came to know abou

Re: Reg: Using Zeppelin as a Visualisation tool for my SQL backend system

This worked. Thanks a lot. I took 0.6.0 source and compiled to get JDBC Interpreter. only field to change is url name. Thanks, Naresh. On Fri, Apr 22, 2016 at 6:21 AM, Jongyoul Lee wrote: > Hi Naresh, > > You can use JDBCInterpreter for what you want to do. It needs jdbc_url > only, and Zepp

Re: Using Zeppelin as a Visualisation tool for my SQL backend system

Thanks Venkat & Ahyoung it worked On Thu, Apr 21, 2016 at 10:59 PM, Venkat Muthuswamy < venkat.muthusw...@esgyn.com> wrote: > You can copy your Redshift driver jar to the “lib” sub-folder under > zeppelin install. Make sure the user account which is running zeppelin has > read access to this jar