Example Analysis of Impala failure to execute SQL after Sentry is enabled

This article mainly shows you the "enable Sentry Impala after the implementation of SQL failure example analysis", the content is easy to understand, clear, hope to help you solve the doubt, the following let the editor lead you to study and learn "enable Sentry Impala implementation of SQL failure example analysis" this article.

Problem recurrence

Test environment:

1.RedHat7.2

2.CM and CDH version 6.2.0

3. The cluster enables Kerberos and Sentry services are enabled

Fayson is given the CREATE/REFRESH/SELECT permission of the test library in the test environment.

Use the fayson user to access Impala and build the table on the command line. When executing the following SQL statement, you are prompted that you do not have INSERT permission.

Create table test_b stored as parquet as select * from test

two

Solution.

The above problems encountered in Impala can be solved by splitting the above SQL statement into the following ways:

Create table test_c like test stored as parquet

Insert overwrite test_c select * from test

In Hive, you can directly use the above SQL statement to execute without making corresponding modifications.

Create table test_b stored as parquet as select * from test

The above is all the contents of the article "sample Analysis of Impala failure to execute SQL after enabling Sentry". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!