[
https://issues.apache.org/jira/browse/RANGER-5487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18057550#comment-18057550
]
Aleksander Nek commented on RANGER-5487:
----------------------------------------
[https://github.com/apache/ranger/blob/master/hive-agent/src/main/java/org/apache/ranger/services/hive/client/HiveResourceMgr.java#L114C25-L114C45]
{code:java}
// get the DBList for given Input
databaseName += "*";{code}
> 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
> Priority: Major
>
> 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)
