Shishr Prakash created SENTRY-2439:
--------------------------------------
Summary: "is not match table meta grammar error" with sentry-1.7
Key: SENTRY-2439
URL: https://issues.apache.org/jira/browse/SENTRY-2439
Project: Sentry
Issue Type: Bug
Components: Sentry
Affects Versions: 1.7.0
Reporter: Shishr Prakash
[What happened]
After enabling sentry I am getting below error with DDLs like DROP table .
similar to sentry bug-1845.
[1] https://issues.apache.org/jira/browse/SENTRY-1845
====Error ===
2 rows selected (0.171 seconds)
0: jdbc:hive2://maprtest03:10000> DROP TABLE project_dev_out_hive;
Error: Error while compiling statement: FAILED: HiveAuthzPluginException class
org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthzPluginException:
this command DROP TABLE project_dev_out_hive is not match table meta grammar
(state=42000,code=40000)
======
It is not the same issue, but a similar issue for DROP TABLE command. The
Sentry regex pattern for DROP TABLE command does not seem to be supporting
backtick.
String DROP_TABLE_REGEX = "^DROP\s+" + "TABLE\s+" + "(IF\s+EXISTS\s+)?" +
"([A-Za-z0-9._]+)";
Looks like it is not fixed in the latest version as well (the same pattern is
used in the master branch as well). Hive seems to be supporting this syntax.
## Steps to Reproduce
Try dropping hive table with backticks as below
DROP TABLE `project_dev_out_hive`;
### What you expected to happen
Sentry should understand backticks and it should work for every command.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
