[jira] [Created] (RANGER-5487) Ranger Hive service functionality, including connection testing and resource search functionality.

["Aleksander Nek (Jira)" <ji...@apache.org>]

Aleksander Nek created RANGER-5487:
--------------------------------------

             Summary: Ranger Hive service functionality, including connection testing and resource search functionality.
                 Key: RANGER-5487
                 URL: https://issues.apache.org/jira/browse/RANGER-5487
             Project: Ranger
          Issue Type: Bug
          Components: Ranger
            Reporter: Aleksander Nek


Validate ranger hive service test connection and resourcelookup functionality as well

Hive     4.0.1
Ranger     2.6.0

These versions should be compatible according to Bigtop 3.4.0
https://cwiki.apache.org/confluence/display/BIGTOP/Bigtop+3.4.0+Release

But I see this in the logs in hive-server2.err logs:

 
{noformat}
POSTHOOK: type: SHOWDATABASES
POSTHOOK: query: show databases like "*"{noformat}
 


There is a mention in the Hive document  (https://hive.apache.org/docs/latest/language/languagemanual-ddl/#show-databases)
{panel:title=Show Databases}
SHOW (DATABASES|SCHEMAS) [LIKE 'identifier_with_wildcards'];


SHOW DATABASES or SHOW SCHEMAS lists all of the databases defined in the metastore. The uses of SCHEMAS and DATABASES are interchangeable – they mean the same thing.

The optional LIKE clause allows the list of databases to be filtered using a regular expression. Wildcards in the regular expression can only be ‘’ for any character(s) or ‘|’ for a choice. Examples are ’employees’, ’emp’, ’emp*|*ees’, all of which will match the database named ’employees’.

Version information: SHOW DATABASES
Starting from 4.0.0 we accept only SQL type like expressions containing ‘%’ for any character(s), and ‘_’ for a single character. Examples are ’employees’, ’emp%’, ’emplo_ees’, all of which will match the database named ’employees’.
{panel}
 


Could you please tell me if the versions are compatible and if so, how to make Ranger get SHOWDATABASES correctly?

Have you checked the functionality of the Ranger Hive service, as well as the functionality of checking the connection and searching for resources?
https://issues.apache.org/jira/browse/RANGER-4952?focusedCommentId=17894106&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-17894106



--
This message was sent by Atlassian Jira
(v8.20.10#820010)