[
https://issues.apache.org/jira/browse/SENTRY-1270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15612966#comment-15612966
]
Sravya Tirukkovalur commented on SENTRY-1270:
---------------------------------------------
This is a trivial patch but would be useful for debugging. [~lskuff] and
[~hahao] Can you take a quick look, so that we can close on this?
Thanks,
> Improve error handling - Database with malformed URI causes NPE in HMS plugin
> during DDL
> ----------------------------------------------------------------------------------------
>
> Key: SENTRY-1270
> URL: https://issues.apache.org/jira/browse/SENTRY-1270
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.7.0
> Reporter: Lenni Kuff
> Assignee: Sravya Tirukkovalur
> Attachments: SENTRY-1270.0.patch, SENTRY-1270.1.patch
>
>
> Exception:
> {code}
> Caused by: java.lang.NullPointerException
> at
> org.apache.sentry.hdfs.MetastorePlugin.applyLocal(MetastorePlugin.java:336)
> at
> org.apache.sentry.hdfs.MetastorePlugin.processUpdate(MetastorePlugin.java:364)
> at
> org.apache.sentry.hdfs.MetastorePlugin.notifySentryAndApplyLocal(MetastorePlugin.java:341)
> at
> org.apache.sentry.hdfs.MetastorePlugin.renameAuthzObject(MetastorePlugin.java:292)
> at
> org.apache.sentry.binding.metastore.SentryMetastorePostEventListener.renameSentryTablePrivilege(SentryMetastorePostEventListener.java:336)
> at
> org.apache.sentry.binding.metastore.SentryMetastorePostEventListener.onAlterTable(SentryMetastorePostEventListener.java:194)
> at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.alter_table_core(HiveMetaStore.java:3439)
> ... 21 more
> {code}
> When looking in the HMS database we found:
> {code}
> SELECT "NAME", "DB_LOCATION_URI" FROM "DBS" WHERE NOT "DB_LOCATION_URI" LIKE
> 'hdfs://%/%';
> NAME | DB_LOCATION_URI
> -----------+--------------------
> db_name | hdfs://nameservice1
> (1 row)
> {code}
> Fixed by manually updating the HMS DB:
> {code}
> UPDATE DBS
> SET DB_LOCATION_URI='hdfs://nameservice1/user/hive/warehouse/db_name.db'
> WHERE DB_ID=12345;
> {code}
> We should handle this more gracefully in Sentry.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
