question Re: HDP 3.1 Hive Connectivity Issue in Support Questions

question Re: HDP 3.1 Hive Connectivity Issue in Support Questions https://community.cloudera.com/t5/Support-Questions/HDP-3-1-Hive-Connectivity-Issue/m-p/285233#M211697 <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/55994">@eswarloges</a> In one of your previous update you have mentioned that you have added  "the hiveserver2 jdbc url is configured in the spark config."However, looks like the error that you are getting is because the mentioned properties are not found in the spark2-defaults config which is there in your classpath. So can you please make sure that you have included the correct CLASSPATH which is pointing to correct spark-defaults which has the following properties added as mentioned in "Required properties" Section of the following Doc:  <A href="https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.0/integrating-hive/content/hive_configure_a_spark_hive_connection.html" target="_blank" rel="noopener">https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.0/integrating-hive/content/hive_configure_a_spark_hive_connection.html</A>.You must add several Spark properties through spark2-defaults in Ambari to use the Hive Warehouse Connector for accessing data in Hive.  Alternatively, configuration can be provided for each job using --conf. <UL><LI>spark.sql.hive.hiveserver2.jdbc.urlThe URL for HiveServer2 Interactive</LI><LI>spark.datasource.hive.warehouse.metastoreUriThe URI for the metastore</LI><LI>spark.datasource.hive.warehouse.load.staging.dirThe HDFS temp directory for batch writes to Hive, /tmp for example</LI><LI>spark.hadoop.hive.llap.daemon.service.hostsThe application name for LLAP service</LI><LI>spark.hadoop.hive.zookeeper.quorumThe ZooKeeper hosts used by LLAP</LI></UL>Set the values of these properties as follows:<UL><LI>spark.sql.hive.hiveserver2.jdbc.urlIn Ambari, copy the value from Services > Hive > Summary > HIVESERVER2 INTERACTIVE JDBC URL.</LI><LI>spark.datasource.hive.warehouse.metastoreUriCopy the value from hive.metastore.uris. In Hive, at the hive> prompt, enter set hive.metastore.uris and copy the output. For example, thrift://mycluster-1.com:9083.</LI><LI>spark.hadoop.hive.llap.daemon.service.hostsCopy value from Advanced hive-interactive-site > hive.llap.daemon.service.hosts.</LI><LI>spark.hadoop.hive.zookeeper.quorumCopy the value from Advanced hive-sitehive.zookeeper.quorum.</LI></UL> .  .   Tue, 10 Dec 2019 09:08:32 GMT jsensharma 2019-12-10T09:08:32Z