Anupam Rai created RANGER-3895:
----------------------------------
Summary: Hive : Show database/table is not giving any result from
beeline
Key: RANGER-3895
URL: https://issues.apache.org/jira/browse/RANGER-3895
Project: Ranger
Issue Type: Bug
Components: Ranger
Reporter: Anupam Rai
Show database/table is not giving any result from beeline
Steps to reproduce :
cm_hive : All access for user
cm_hdfs : Access to all path for user
Hit query on beeline :
{code:java}
0: jdbc:hive2://quasar-nxmfwf-1.quasar-nxmfwf> show databases;
INFO : Compiling
command(queryId=hive_20220824053200_90698f18-6b9d-480b-b2c9-12b28c96c7f6): show
databases
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema:
Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from
deserializer)], properties:null)
INFO : Completed compiling
command(queryId=hive_20220824053200_90698f18-6b9d-480b-b2c9-12b28c96c7f6); Time
taken: 0.023 seconds
INFO : Executing
command(queryId=hive_20220824053200_90698f18-6b9d-480b-b2c9-12b28c96c7f6): show
databases
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=hive_20220824053200_90698f18-6b9d-480b-b2c9-12b28c96c7f6); Time
taken: 0.006 seconds
INFO : OK
+----------------+
| database_name |
+----------------+
+----------------+ {code}
Try same using spark Db
{code:java}
scala> spark.sql("show databases").show()
22/08/24 05:35:39 WARN conf.HiveConf: HiveConf of name hive.masking.algo does
not exist
Hive Session ID = 5e7e8200-84d1-48bf-9174-6c72797a168a
+------------------+
| databaseName|
+------------------+
| default|
|information_schema|
| sys|
| testdb_tagspolicy|
+------------------+ {code}
Getting proper result from spark DB while beeline doesnot show any database /
tables
Expected result : Users should be able to get all table details
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
