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)
