https://community.cloudera.com/t5/Support-Questions/HDP-3-1-Hive-Connectivity-Issue/m-p/285161#M211639 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/55994">@eswarloges</a>&nbsp;</P><P>From HDP 3.x onwards, to work with hive databases you should use the HiveWarehouseConnector library /usr/hdp/current/hive_warehouse_connector/hive-warehouse-connector-assembly-1.0.0.3.0.0.0-1634.jar as show in the below example</P><P><STRONG>spark-shell --conf spark.sql.hive.hiveserver2.jdbc.url="jdbc:hive2://FQDN or IP:10000/" spark.datasource.hive.warehouse.load.staging.dir="/staging_dir" spark.hadoop.hive.zookeeper.quorum="zk_Quorum_ip's:2181" --jars /usr/hdp/current/hive_warehouse_connector/hive-warehouse-connector-assembly-1.0.0.3.0.0.0-1634.jar</STRONG><BR /><STRONG>val hive = com.hortonworks.spark.sql.hive.llap.HiveWarehouseBuilder.session(spark).build()</STRONG><BR /><STRONG>hive.showDatabases().show(100, false)</STRONG></P><P>Could you try that and revert</P> Mon, 09 Dec 2019 18:14:36 GMT Shelton 2019-12-09T18:14:36Z