Re: ClassNotFoundException when using %jdbc(hive)
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 wrote: > Hi, > > Did you solve it by installing JDK? > > On Thu, Oct 13, 2016 at 8:44 PM, Xi Shen wrote: > > Turns out I need JDK, but I only install JRE... > > On Wed, Oct 12, 2016 at 3:25 PM Xi Shen 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 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)
Hi, Did you solve it by installing JDK? On Thu, Oct 13, 2016 at 8:44 PM, Xi Shen wrote: > Turns out I need JDK, but I only install JRE... > > On Wed, Oct 12, 2016 at 3:25 PM Xi Shen 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 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)
Turns out I need JDK, but I only install JRE... On Wed, Oct 12, 2016 at 3:25 PM Xi Shen 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 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)
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 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.
Re: ClassNotFoundException when using %jdbc(hive)
Hi, Can you attach jdbc interpreter's log file? On Wed, Oct 12, 2016 at 2:02 PM, Xi Shen 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