<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Impala failures after LDAP integration in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Impala-failures-after-LDAP-integration/m-p/86470#M35739</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have an HDFS-Hive-Impala regression script that works fine on my kerberized &amp;amp; sentry protected CDH cluster.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Now, I enabled LDAP authentication on HDFS (LdapGroupsMapping), Hive and Impala and the regression script passes HDFS and Hive but fails on the SELECT-INSERT-CREATE Impala actions:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Failure 1 &amp;amp; 2 (similar error for select and insert):&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Query: select * from customer.cons limit 10
ERROR: AnalysisException: Failed to load metadata for table: 'customer.cons'
CAUSED BY: TableLoadingException: Failed to load file metadata for 1 paths for table customer.cons. Table's file metadata could be partially loaded. Check the Catalog server log for more details.&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Failure 2:&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Query: create table customer.test_141226 (id int)
ERROR: ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore: 

CAUSED BY: MetaException: Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=impala, access=WRITE, inode="/user/hive/warehouse/customer.db":hive:hive:drwxrwx--t&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Note 1: Hive and Impala share the exact the same queries on the regression script. The latter seems like an impersonation problem, but why does it appear now and not before LDAP?&lt;/P&gt;
&lt;P&gt;Note 2: services principals are localy (KDC) while user principals on AD.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you,&lt;/P&gt;
&lt;P&gt;Gerasimos&lt;/P&gt;</description>
    <pubDate>Fri, 16 Sep 2022 14:09:31 GMT</pubDate>
    <dc:creator>gerasimos</dc:creator>
    <dc:date>2022-09-16T14:09:31Z</dc:date>
    <item>
      <title>Impala failures after LDAP integration</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Impala-failures-after-LDAP-integration/m-p/86470#M35739</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have an HDFS-Hive-Impala regression script that works fine on my kerberized &amp;amp; sentry protected CDH cluster.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Now, I enabled LDAP authentication on HDFS (LdapGroupsMapping), Hive and Impala and the regression script passes HDFS and Hive but fails on the SELECT-INSERT-CREATE Impala actions:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Failure 1 &amp;amp; 2 (similar error for select and insert):&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Query: select * from customer.cons limit 10
ERROR: AnalysisException: Failed to load metadata for table: 'customer.cons'
CAUSED BY: TableLoadingException: Failed to load file metadata for 1 paths for table customer.cons. Table's file metadata could be partially loaded. Check the Catalog server log for more details.&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Failure 2:&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Query: create table customer.test_141226 (id int)
ERROR: ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore: 

CAUSED BY: MetaException: Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=impala, access=WRITE, inode="/user/hive/warehouse/customer.db":hive:hive:drwxrwx--t&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Note 1: Hive and Impala share the exact the same queries on the regression script. The latter seems like an impersonation problem, but why does it appear now and not before LDAP?&lt;/P&gt;
&lt;P&gt;Note 2: services principals are localy (KDC) while user principals on AD.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you,&lt;/P&gt;
&lt;P&gt;Gerasimos&lt;/P&gt;</description>
      <pubDate>Fri, 16 Sep 2022 14:09:31 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Impala-failures-after-LDAP-integration/m-p/86470#M35739</guid>
      <dc:creator>gerasimos</dc:creator>
      <dc:date>2022-09-16T14:09:31Z</dc:date>
    </item>
    <item>
      <title>Re: Impala failures after LDAP integration</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Impala-failures-after-LDAP-integration/m-p/86487#M35740</link>
      <description>&lt;P&gt;I managed to fix this by&amp;nbsp;configuring CompositeGroupMapping instead of LdapGroupMapping.&lt;/P&gt;</description>
      <pubDate>Thu, 14 Feb 2019 20:54:36 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Impala-failures-after-LDAP-integration/m-p/86487#M35740</guid>
      <dc:creator>gerasimos</dc:creator>
      <dc:date>2019-02-14T20:54:36Z</dc:date>
    </item>
  </channel>
</rss>

