write access to the Hive wiki

[Luangsay Sourygna]

Hi,

Could you please give access to my user (sourygna) ?

Thanks,

Sourygna

Re: Re: How to use HPL/SQL connect with impala and Hive

[Dmitry Tolpeko]

Looks like you are trying to connect not through HiveServer2.

You should use:


  hplsql.conn.default
  hive2conn



  hplsql.conn.hive2conn

org.apache.hive.jdbc.HiveDriver;jdbc:hive2://:1;;


Thanks,
Dmitry

On Thu, Nov 23, 2017 at 10:32 AM, 梁凯  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:1
> 2017-11-23 14:42:56,689 INFO  [main] jdbc.Utils (Utils.java:parseURL(383))
> - Resolved authority: datanode221:1
>
>
> 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.(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"  写道：
>
> >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, 梁凯  wrote:
>
>> Hello，
>> I'm a Hadoop