I am trying to use a mysql jdbc jar in zeppelin and cli and getting errors b%dep z.load("/var/lib/ambari-server/resources/mysql-connector-java-5.1.17.jar") val url="jdbc:mysql://localhost:3306/hive" val prop = new java.util.Properties prop.setProperty("user","root") prop.setProperty("password","****") val people = sqlContext.read.jdbc(url,"version",prop) But getting an exception : java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/hive at java.sql.DriverManager.getConnection(DriverManager.java:596) at java.sql.DriverManager.getConnection(DriverManager.java:187) I tried doing this using the CLI by registering like in this blog: http://hortonworks.com/hadoop/zeppelin/#section_3 When you have a jar on the node where Zeppelin is running, the following approach can be useful: Add spark.files property at SPARK_HOME/conf/spark-defaults.conf; for example:spark.files /path/to/my.jar This is my spark-defaults.conf, that i modified using ambari spark.driver.extraJavaOptions -Dhdp.version=2.3.2.0-2950 spark.files /var/lib/ambari-server/resources/mysql-connector-java-5.1.17.jar spark.history.kerberos.keytab none When I run the same code I am getting the same error as above: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/hive The jar file does exist in that path:/var/lib/ambari-server/resources/mysql-connector-java-5.1.17.jar [root@sandbox conf]# find / -iname "mysql-connector-java*" /usr/hdp/2.3.2.0-2950/sqoop/lib/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/hive/lib/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/hbase/lib/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/knox/ext/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/hadoop/lib/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/hadoop-yarn/lib/mysql-connector-java.jar /usr/hdp/2.3.2.0-2950/ranger-admin/ews/lib/mysql-connector-java.jar /usr/share/java/mysql-connector-java-5.1.17.jar /usr/share/java/mysql-connector-java-5.1.31-bin.jar /usr/share/java/mysql-connector-java.jar /var/lib/ambari-server/resources/mysql-connector-java-5.1.17.jar /var/lib/ambari-agent/tmp/mysql-connector-java.jar /etc/maven/fragments/mysql-connector-java ... View more

Is it possible to clone the zeppelin interpreter with all settings programmatically(REST?) or using UI(I did not see that as an option). I created a new one manually but wanted to check if there was a better way?. I want to have 2 or more interpreters setup pointing @ different versions of spark 1.4 and 1.5. But i can easily see this extending to other components. ... View more

Is there any differences to load new 3rd party packages using cli or zeppelin if I am using zeppelin as the notebook. 1)cli: spark-shell --packages com.databricks:spark-csv_2.11:1.1.0 or using 2) zeppelin: // add artifact recursively except comma separated GroupID:ArtifactId list z.load("groupId:artifactId:version").exclude("groupId:artifactId,groupId:artifactId, ...") ... View more