Looks like you are trying to connect not through HiveServer2. You should use:
<property> <name>hplsql.conn.default</name> <value>hive2conn</value> </property> <property> <name>hplsql.conn.hive2conn</name> <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://<host>:10000;<usr>;<pwd></value> </property> Thanks, Dmitry On Thu, Nov 23, 2017 at 10:32 AM, 梁凯 <liang...@yaspeed.com> wrote: > Dear, > > Thanks for your help. I try to connect to hive1.1 ,the error output as > follows: > > ./hplsql -e "select * from wxy.test1" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in [jar:file:/opt/cloudera/ > parcels/CDH-5.13.0-1.cdh5.13.0.p0.29/jars/avro-tools-1.7.6- > cdh5.13.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in [jar:file:/opt/cloudera/ > parcels/CDH-5.13.0-1.cdh5.13.0.p0.29/jars/slf4j-log4j12-1. > 7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in [jar:file:/opt/cloudera/ > parcels/CDH-5.13.0-1.cdh5.13.0.p0.29/jars/pig-0.12.0-cdh5. > 13.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in [jar:file:/opt/cloudera/ > parcels/CDH-5.13.0-1.cdh5.13.0.p0.29/jars/slf4j-simple-1.7. > 5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > 2017-11-23 14:42:56,683 INFO [main] jdbc.Utils (Utils.java:parseURL(295)) > - Supplied authorities: datanode221:10000 > 2017-11-23 14:42:56,689 INFO [main] jdbc.Utils (Utils.java:parseURL(383)) > - Resolved authority: datanode221:10000 > > > Exception in thread "main" java.lang.IncompatibleClassChangeError: class > org.apache.hive.service.cli.thrift.TCLIService$Client has interface > org.apache.thrift.TServiceClient as super class > at java.lang.ClassLoader.defineClass1(Native Method) > at java.lang.ClassLoader.defineClass(ClassLoader.java:763) > at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) > at java.net.URLClassLoader.defineClass(URLClassLoader.java:467) > at java.net.URLClassLoader.access$100(URLClassLoader.java:73) > at java.net.URLClassLoader$1.run(URLClassLoader.java:368) > at java.net.URLClassLoader$1.run(URLClassLoader.java:362) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:361) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:170) > at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) > at java.sql.DriverManager.getConnection(DriverManager.java:664) > at java.sql.DriverManager.getConnection(DriverManager.java:247) > at org.apache.hive.hplsql.Conn.openConnection(Conn.java:209) > at org.apache.hive.hplsql.Conn.getConnection(Conn.java:162) > at org.apache.hive.hplsql.Conn.executeQuery(Conn.java:58) > at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:560) > at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:569) > at org.apache.hive.hplsql.Select.select(Select.java:75) > at org.apache.hive.hplsql.Exec.visitSelect_stmt(Exec.java:1021) > at org.apache.hive.hplsql.Exec.visitSelect_stmt(Exec.java:52) > at org.apache.hive.hplsql.HplsqlParser$Select_stmtContext.accept( > HplsqlParser.java:15050) > at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren( > AbstractParseTreeVisitor.java:70) > at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1013) > at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:52) > at org.apache.hive.hplsql.HplsqlParser$StmtContext. > accept(HplsqlParser.java:1023) > at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren( > AbstractParseTreeVisitor.java:70) > at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock( > HplsqlBaseVisitor.java:28) > at org.apache.hive.hplsql.HplsqlParser$BlockContext. > accept(HplsqlParser.java:454) > at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren( > AbstractParseTreeVisitor.java:70) > at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:920) > at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:52) > at org.apache.hive.hplsql.HplsqlParser$ProgramContext. > accept(HplsqlParser.java:395) > at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit( > AbstractParseTreeVisitor.java:42) > at org.apache.hive.hplsql.Exec.run(Exec.java:775) > at org.apache.hive.hplsql.Exec.run(Exec.java:751) > at org.apache.hive.hplsql.Hplsql.main(Hplsql.java:23) > > > > 在 2017-11-22 20:48:39,"Dmitry Tolpeko" <dmtolp...@gmail.com> 写道: > > >exeception : java.lang.incompatible class change error > > Can you please send the entire error output? > > >How to make a connection between HPL/SQL and impala > > Connection to Impala is not pre-defined yet, so you have to create a new > connection, see http://hplsql.org/connections > > Thanks, > Dmitry > > On Wed, Nov 22, 2017 at 1:09 PM, 梁凯 <liang...@yaspeed.com> wrote: > >> Hello, >> I'm a Hadoop Development Engineer, and I'm excited to find your tools, >> because it's what I've been looking for, but there are some problems with >> the installation, and I hope you can help . Thank you! >> >> Question 1: did I install HPL/SQL in hive1.1? I tried, installed it , but >> when I was going to connect to hive with HPL/SQL, It can't work >> exeception : java.lang.incompatible class change error >> Question 2: I have a impala cluster, and now want to use HPL/SQL on >> impala, How to make a connection between HPL/SQL and impala. >> >> Regards. >> >> >