New Contributor
Posts: 1
Registered: ‎05-09-2017

Unable to connect to hive tables via excel using cloudera hive odbc

I am new to big data stuff and I am trying to access hive tables existing in Cloudera from excel. I think I am doing some mistakes in Apache Hive DSN setup settings in windows.

In the authentication section, I don't know what to select for "Mechanism". There are many options available


I am getting the error as mentioned in the image attached. I also attached my hive-config.xml. Maybe I am missing something in the file. Please let me know. 

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>


  <!-- Hive Configuration can either be stored in this file or in the hadoop configuration files  -->
  <!-- that are implied by Hadoop setup variables.                                                -->
  <!-- Aside from Hadoop setup variables - this file is provided as a convenience so that Hive    -->
  <!-- users do not have to edit hadoop configuration files (that may be managed as a centralized -->
  <!-- resource).                                                                                 -->

  <!-- Hive Execution Parameters -->

    <description>JDBC connect string for a JDBC metastore</description>
    <description>Driver class name for a JDBC metastore</description>



    <description>This is the WAR file with the jsp content for Hive Web Interface</description>



    <description>IP address (or fully-qualified domain name) and port of the metastore host</description>