title: Unable to start Hive on Windows 10: Error applying authorization policy on hive configuration
body: <p>I'm trying to install Hive on Windows 10.  When attempting to start Hive I receive the following error:</p>
  
  <blockquote>
    <p>Error applying authorization policy on hive configuration: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient</p>
  </blockquote>
  
  <p>I'm using Derby as my backend for Hive.  Here is my hive-site.xml file:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;?xml-stylesheet type="text/xsl" href="configuration.xsl"?&gt;
  &lt;configuration&gt;
  &lt;property&gt;
      &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
      &lt;value&gt;jdbc:derby://localhost:1527/metastore_db;create=true&lt;/value&gt;
      &lt;description&gt;JDBC connect string for a JDBC metastore&lt;/description&gt;
  &lt;/property&gt;
  &lt;property&gt;
      &lt;name&gt;javax.jdo.option.ConnectionDriverName&lt;/name&gt;
      &lt;value&gt;org.apache.derby.jdbc.ClientDriver&lt;/value&gt;
      &lt;description&gt;Driver class name for a JDBC metastore&lt;/description&gt;
  &lt;/property&gt;
  &lt;property&gt;
      &lt;name&gt;hive.server2.enable.impersonation&lt;/name&gt;
      &lt;description&gt;Enable user impersonation for HiveServer2&lt;/description&gt;
      &lt;value&gt;true&lt;/value&gt;
  &lt;/property&gt;
  &lt;property&gt;
      &lt;name&gt;hive.server2.authentication&lt;/name&gt;
      &lt;value&gt;NONE&lt;/value&gt;
      &lt;description&gt;
        Client authentication types.
          NONE: no authentication check
          LDAP: LDAP/AD based authentication
          KERBEROS: Kerberos/GSSAPI authentication
          CUSTOM: Custom authentication provider
                  (Use with property hive.server2.custom.authentication.class)
      &lt;/description&gt;
  &lt;/property&gt;
  &lt;property&gt;
      &lt;name&gt;datanucleus.autoCreateTables&lt;/name&gt;
      &lt;value&gt;True&lt;/value&gt;
  &lt;/property&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>I first start networkServer:</p>
  
  <pre><code>d:\Hadoop-2.8.1\sbin&gt;startNetworkServer -h 0.0.0.0
  Fri Feb 09 08:57:01 EST 2018 : Security manager installed using the Basic server security policy.
  Fri Feb 09 08:57:01 EST 2018 : Apache Derby Network Server - 10.14.1.0 - (1808820) started and ready to accept connections on port 1527
  </code></pre>
  
  <p>Then run start-all.cmd:</p>
  
  <pre><code>d:\Hadoop-2.8.1\sbin&gt;start-all.cmd
  </code></pre>
  
  <p>Check NetworkServerControl:</p>
  
  <pre><code>d:\Hadoop-2.8.1\sbin&gt;jps -m
  12532 ResourceManager
  7156 NetworkServerControl start -h 0.0.0.0
  20504 Jps -m
  27336 DataNode
  22604 NodeManager
  492 NameNode
  </code></pre>
  
  <p>Finally, I try to start Hive and that is when I receive the error:</p>
  
  <pre><code>d:\Hadoop-2.8.1\sbin&gt;hive
  </code></pre>
  
  <p>I notice in the hive's bin directory there is no metastore_db created:</p>
  
  <pre><code>Directory of d:\Hadoop-2.8.1\hive2_1\bin
  
  02/06/2018  01:48 PM    &lt;DIR&gt;          .
  02/06/2018  01:48 PM    &lt;DIR&gt;          ..
  11/28/2016  04:32 PM             1,261 beeline
  11/28/2016  04:32 PM             2,553 beeline.cmd
  02/06/2018  01:48 PM    &lt;DIR&gt;          ext
  11/28/2016  04:35 PM             8,692 hive
  11/28/2016  04:32 PM             1,584 hive-config.cmd
  02/09/2018  08:20 AM             1,900 hive-config.sh
  11/28/2016  04:32 PM             8,823 hive.cmd
  11/28/2016  04:32 PM               885 hiveserver2
  11/28/2016  04:32 PM             1,030 hplsql
  11/28/2016  04:32 PM             2,278 hplsql.cmd
  11/28/2016  04:32 PM               832 metatool
  11/28/2016  04:32 PM               884 schematool
                11 File(s)         30,722 bytes
                 3 Dir(s)  427,455,606,784 bytes free
  </code></pre>
  
  <p>Anyone see where I'm going wrong?</p>