[
https://issues.apache.org/jira/browse/RANGER-5487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aleksander Nek updated RANGER-5487:
-----------------------------------
Description:
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
was:
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
> 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)
