Support Questions
Find answers, ask questions, and share your expertise

how config hplsql on hdp 2.6

how config hplsql on hdp 2.6

Contributor

I have error : [hive@host bin]$ ./hplsql -e "select * from database.name" SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.6.0.3-8/hive2/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.6.0.3-8/hadoop/lib/slf4j-log4j12-1.7.10.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.apache.logging.slf4j.Log4jLoggerFactory] Unhandled exception in HPL/SQL java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: Could not establish connection to jdbc:hive2://localhost:10000: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default}) at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:211)

2 REPLIES 2

Re: how config hplsql on hdp 2.6

Rising Star

Hi Dmitro,

I think you have not given the hive connection path.

replace localhost:10000 with your hive cluster path.

thanks,

Rishit Shah

Re: how config hplsql on hdp 2.6

@Dmitro Vasilenko

Adding to Rishit's reply, make sure HADOOP_CLASSPATH and HIVE_HOME are set properly.