Unable to use Hive Interpretter

[๏̯͡๏ <ÐΞ€ρ@Ҝ>, de...@gmail.com]

I am able to run hive command from command prompt and able to connect to my
production cluster. Now i want to try Hive interpreter


Settings:

I mapped the values to below settings from hive-site.xml

common.max_count  1000
default.driver  com.mysql.jdbc.Driver
default.password
*default.url jdbc:mysql://host.vip.com:3306/HDB
<http://host.vip.com:3306/HDB>*
default.user  hive

Fields referred were:
<name>javax.jdo.option.ConnectionURL</name>
<name>javax.jdo.option.ConnectionDriverName</name>
<name>javax.jdo.option.ConnectionUserName</name>
<name>javax.jdo.option.ConnectionPassword</name>


Question
1. How do i get it working ?
2. Why should i provide these settings manually ? IF i can simply specify
the location of hive-site.xml.

Appreciate your time.


Logs
====

ERROR [2016-04-28 16:37:07,492] ({pool-2-thread-3}
HiveInterpreter.java[executeSql]:294) - Cannot run show tables;

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

at java.lang.ClassLoader.loadClass(ClassLoader.java:425)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)

at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:191)

at
org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)

at
org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)

at
org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)

at
org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)

at
org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)

at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)

at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:300)

at org.apache.zeppelin.scheduler.Job.run(Job.java:169)

at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:157)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

 INFO [2016-04-28 16:37:07,500] ({pool-2-thread-3}
SchedulerFactory.java[jobFinished]:135) - Job
remoteInterpretJob_1461886627489 finished by scheduler
org.apache.zeppelin.hive.HiveInterpreter533686947