You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@zeppelin.apache.org by Xi Shen <da...@gmail.com> on 2016/10/12 05:02:14 UTC

ClassNotFoundException when using %jdbc(hive)

Hi,

I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
and added two artifacts:

   - org.apache.hive:hive-jdbc:2.1.0
   - org.apache.hadoop:hadoop-common:2.7.3

Then I tried this:

%jdbc(hive)
show tables

But I got this error:

org.apache.hive.jdbc.HiveDriver
class java.lang.ClassNotFoundException
java.net.URLClassLoader.findClass(URLClassLoader.java:381)
java.lang.ClassLoader.loadClass(ClassLoader.java:424)


I think the dependency configuration will pull in the hive-jdbc jar file,
so I did not put the jar file into the ./interpreter/jdbc directory. Did I
do anything wrong? Or the manual needs update?
-- 


Thanks,
David S.

Re: ClassNotFoundException when using %jdbc(hive)

Posted by Jongyoul Lee <jo...@gmail.com>.

Hi,

Can you attach jdbc interpreter's log file?

On Wed, Oct 12, 2016 at 2:02 PM, Xi Shen <da...@gmail.com> wrote:

> Hi,
>
> I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
> and added two artifacts:
>
>    - org.apache.hive:hive-jdbc:2.1.0
>    - org.apache.hadoop:hadoop-common:2.7.3
>
> Then I tried this:
>
> %jdbc(hive)
> show tables
>
> But I got this error:
>
> org.apache.hive.jdbc.HiveDriver
> class java.lang.ClassNotFoundException
> java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>
> I think the dependency configuration will pull in the hive-jdbc jar file,
> so I did not put the jar file into the ./interpreter/jdbc directory. Did I
> do anything wrong? Or the manual needs update?
> --
>
>
> Thanks,
> David S.
>



-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: ClassNotFoundException when using %jdbc(hive)

Posted by Xi Shen <da...@gmail.com>.

Yes, I think JRE is not able do pull dependencies. That's why I found the
dependency configuration did not take effect.

On Fri, Oct 14, 2016 at 2:50 PM Jongyoul Lee <jo...@gmail.com> wrote:

> Hi,
>
> Did you solve it by installing JDK?
>
> On Thu, Oct 13, 2016 at 8:44 PM, Xi Shen <da...@gmail.com> wrote:
>
> Turns out I need JDK, but I only install JRE...
>
> On Wed, Oct 12, 2016 at 3:25 PM Xi Shen <da...@gmail.com> wrote:
>
> Here's the log http://pastie.org/private/nem2pur2tl3adgbrv4hl2g
>
> I did a test. I copied the jar file to ./interpreter/jdbc, the execute the
> same command. This I got another error related to hadoop-common. I think
> the configuration in "dependency" section did not take effect at all. But
> there's no error either.
>
> Please help~
>
> On Wed, Oct 12, 2016 at 1:02 PM Xi Shen <da...@gmail.com> wrote:
>
> Hi,
>
> I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
> and added two artifacts:
>
>    - org.apache.hive:hive-jdbc:2.1.0
>    - org.apache.hadoop:hadoop-common:2.7.3
>
> Then I tried this:
>
> %jdbc(hive)
> show tables
>
> But I got this error:
>
> org.apache.hive.jdbc.HiveDriver
> class java.lang.ClassNotFoundException
> java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>
> I think the dependency configuration will pull in the hive-jdbc jar file,
> so I did not put the jar file into the ./interpreter/jdbc directory. Did I
> do anything wrong? Or the manual needs update?
> --
>
>
> Thanks,
> David S.
>
> --
>
>
> Thanks,
> David S.
>
> --
>
>
> Thanks,
> David S.
>
>
>
>
> --
> 이종열, Jongyoul Lee, 李宗烈
> http://madeng.net
>
-- 


Thanks,
David S.

Re: ClassNotFoundException when using %jdbc(hive)

Posted by Jongyoul Lee <jo...@gmail.com>.

Hi,

Did you solve it by installing JDK?

On Thu, Oct 13, 2016 at 8:44 PM, Xi Shen <da...@gmail.com> wrote:

> Turns out I need JDK, but I only install JRE...
>
> On Wed, Oct 12, 2016 at 3:25 PM Xi Shen <da...@gmail.com> wrote:
>
>> Here's the log http://pastie.org/private/nem2pur2tl3adgbrv4hl2g
>>
>> I did a test. I copied the jar file to ./interpreter/jdbc, the execute
>> the same command. This I got another error related to hadoop-common. I
>> think the configuration in "dependency" section did not take effect at all.
>> But there's no error either.
>>
>> Please help~
>>
>> On Wed, Oct 12, 2016 at 1:02 PM Xi Shen <da...@gmail.com> wrote:
>>
>> Hi,
>>
>> I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
>> and added two artifacts:
>>
>>    - org.apache.hive:hive-jdbc:2.1.0
>>    - org.apache.hadoop:hadoop-common:2.7.3
>>
>> Then I tried this:
>>
>> %jdbc(hive)
>> show tables
>>
>> But I got this error:
>>
>> org.apache.hive.jdbc.HiveDriver
>> class java.lang.ClassNotFoundException
>> java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>
>>
>> I think the dependency configuration will pull in the hive-jdbc jar file,
>> so I did not put the jar file into the ./interpreter/jdbc directory. Did I
>> do anything wrong? Or the manual needs update?
>> --
>>
>>
>> Thanks,
>> David S.
>>
>> --
>>
>>
>> Thanks,
>> David S.
>>
> --
>
>
> Thanks,
> David S.
>



-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: ClassNotFoundException when using %jdbc(hive)

Posted by Xi Shen <da...@gmail.com>.

Turns out I need JDK, but I only install JRE...

On Wed, Oct 12, 2016 at 3:25 PM Xi Shen <da...@gmail.com> wrote:

> Here's the log http://pastie.org/private/nem2pur2tl3adgbrv4hl2g
>
> I did a test. I copied the jar file to ./interpreter/jdbc, the execute the
> same command. This I got another error related to hadoop-common. I think
> the configuration in "dependency" section did not take effect at all. But
> there's no error either.
>
> Please help~
>
> On Wed, Oct 12, 2016 at 1:02 PM Xi Shen <da...@gmail.com> wrote:
>
> Hi,
>
> I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
> and added two artifacts:
>
>    - org.apache.hive:hive-jdbc:2.1.0
>    - org.apache.hadoop:hadoop-common:2.7.3
>
> Then I tried this:
>
> %jdbc(hive)
> show tables
>
> But I got this error:
>
> org.apache.hive.jdbc.HiveDriver
> class java.lang.ClassNotFoundException
> java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>
> I think the dependency configuration will pull in the hive-jdbc jar file,
> so I did not put the jar file into the ./interpreter/jdbc directory. Did I
> do anything wrong? Or the manual needs update?
> --
>
>
> Thanks,
> David S.
>
> --
>
>
> Thanks,
> David S.
>
-- 


Thanks,
David S.

Re: ClassNotFoundException when using %jdbc(hive)

Posted by Xi Shen <da...@gmail.com>.

Here's the log http://pastie.org/private/nem2pur2tl3adgbrv4hl2g

I did a test. I copied the jar file to ./interpreter/jdbc, the execute the
same command. This I got another error related to hadoop-common. I think
the configuration in "dependency" section did not take effect at all. But
there's no error either.

Please help~

On Wed, Oct 12, 2016 at 1:02 PM Xi Shen <da...@gmail.com> wrote:

Hi,

I followed https://zeppelin.apache.org/docs/0.6.1/interpreter/jdbc.html,
and added two artifacts:

   - org.apache.hive:hive-jdbc:2.1.0
   - org.apache.hadoop:hadoop-common:2.7.3

Then I tried this:

%jdbc(hive)
show tables

But I got this error:

org.apache.hive.jdbc.HiveDriver
class java.lang.ClassNotFoundException
java.net.URLClassLoader.findClass(URLClassLoader.java:381)
java.lang.ClassLoader.loadClass(ClassLoader.java:424)


I think the dependency configuration will pull in the hive-jdbc jar file,
so I did not put the jar file into the ./interpreter/jdbc directory. Did I
do anything wrong? Or the manual needs update?
-- 


Thanks,
David S.

-- 


Thanks,
David S.