from logs:
java.sql.SQLException: No suitable driver found for
jdbc:hive2://<host>:port/default
at java.sql.DriverManager.getConnection……
Error message in notebook:
No suitable driver found for jdbc:hive2://<host>:port/default
Interpreter config:
common.max_count 1000
default.driver org.apache.hive.jdbc.HiveDriver
default.password <blank>
default.url jdbc:hive2://<host>:port/default
default.user <blank>
In my installation (release 0.5.6 official tgz file) the lib directory does not
contain any hive jars.
> On Jun 9, 2016, at 7:22 PM, Jongyoul Lee <[email protected]> wrote:
>
> Hi Mohit,
>
> Could you please show me your settings of interpreter tab and detail error
> messages?
>
> JL
>
> On Thu, Jun 9, 2016 at 10:31 PM, Mohit Jaggi <[email protected]
> <mailto:[email protected]>> wrote:
> Same error except it includes the url in the error message now
>
> Sent from my iPhone
>
> On Jun 9, 2016, at 6:06 PM, Hyung Sung Shim <[email protected]
> <mailto:[email protected]>> wrote:
>
>> Hi.
>> Did you also set up the "default.url" value in the Hive interpreter setting?
>>
>> [0]
>> http://zeppelin.apache.org/docs/0.5.6-incubating/interpreter/hive.html
>> <http://zeppelin.apache.org/docs/0.5.6-incubating/interpreter/hive.html>
>>
>> 2016-06-09 18:28 GMT+09:00 Mohit Jaggi <[email protected]
>> <mailto:[email protected]>>:
>> Hi,
>> I am using 0.5.6 to connect to Hive. I have configured Hive in remote
>> metastore with local database mode and am running the metastore server. My
>> hive-site.xml has hive.metastore.uris = thrift://<host>:10000. This file has
>> been copied to zeppelin/conf and I even restarted zeppelin (do I have to?).
>> But the following command fails
>>
>> %hive show tables
>> No suitable driver found for
>>
>> I tried to add the hive.metastore.uris param via the interpreters config UI
>> but can’t get the above to work. It works from hive’s CLI and from Spark.
>> Any help is much appreciated!
>>
>> Mohit.
>>
>
>
>
> --
> 이종열, Jongyoul Lee, 李宗烈
> http://madeng.net <http://madeng.net/>