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

how config hplsql on hdp 2.6


I have error : [hive@host bin]$ ./hplsql -e "select * from" SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See 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>(


Rising Star

Hi Dmitro,

I think you have not given the hive connection path.

replace localhost:10000 with your hive cluster path.


Rishit Shah

@Dmitro Vasilenko

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