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 file. > > > > *From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] > *Sent:* Thursday, April 21, 2016 10:20 AM > > *To:* users@zeppelin.incubator.apache.org > *Subject:* 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) > > > > URL: jdbc:redshift:// > services-redshift.cxz0.us-west-1.redshift.amazonaws.com:5439/myservice > > > > > > *Zeppelin (Used "psql Interpreter") * > > postgresql.driver.name = com.amazon.redshift.jdbc41.Driver > > postgresql.url = jdbc:redshift://services-redshift.cxz0.us-west- > 1.redshift.amazonaws.com:5439/myservice > > > > Zeppelin Interpreter Creation Page I didn't find any page to give AWS > Redshift Driver jar path. > > Where can I give driver jar path? > > > > > > > > I couldn't able to connect. > > > > > > Thanks, > > Naresh. > > > > > > > > > > On Thu, Apr 21, 2016 at 10:02 PM, Venkat Muthuswamy < > venkat.muthusw...@esgyn.com> wrote: > > 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 example for using the psql interpreter for MySQL. > > http://thedataist.com/tutorial-using-apache-zeppelin-with-mysql/ > > > > > > Regards > > Venkat > > > > *From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] > *Sent:* Thursday, April 21, 2016 3:13 AM > *To:* users@zeppelin.incubator.apache.org > *Subject:* 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 ? > > > > <property> > > <name>zeppelin.interpreters</name> > > <value> ??? > > > > Please let me know. It would be great help. > > > > Thanks, > > Naresh. > > > > > > > > > > > > On Thu, Apr 21, 2016 at 12:09 PM, Venkat Muthuswamy < > venkat.muthusw...@esgyn.com> wrote: > > You can use the generic JDBC interpreter to connect to your SQL engine, > run the query that you typed in Zeppelin and display the results in tabular > form or in charts. > > > https://zeppelin.incubator.apache.org/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html > > > > Venkat > > > > *From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] > *Sent:* Wednesday, April 20, 2016 11:30 PM > *To:* users@zeppelin.incubator.apache.org > *Subject:* Reg: Using Zeppelin as a Visualisation tool for my SQL backend > system > > > > Hi All, > > > > I came to know about this tool from Spark meetup. > > > > I am using AWS Redshift. Redshift supports SQL queries. > > For example: I can use SQL Workbench which connects to Redshift and return > response. > > Also RedShift has Python SDK which will return data for the query using > Redshift SDK. > > > > *My Requirement:* > > I am looking for Visualisation tool for my query responses. > > > > Doubts: > > 1) Can I use Zeppelin for this ? > > > > 2) Looks like Zeppelin is used only for Spark end point. Am I right ? > > > > 3) How Can I use Zeppelin as a visualisation tool for my requirement ? > > > > > > Can I do like this? > > 1) On Zeppelin GUI user enters SQL query. > > 2) Python will connects to Redshift, executes above given query and gets > query response. > > 3) Pass this response to Zeppelin. > > 4) Can Zeppelin render this in different graph formats? > > > > > > Thanks, > > Naresh. > > > > > > > > > > > > >
