[
https://issues.apache.org/jira/browse/RANGER-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anupam Rai updated RANGER-3895:
-------------------------------
Description:
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://********> 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=-6b9d-480b-b2c9-12b28c96c7f6); Time
taken: 0.023 seconds
INFO : Executing command(queryId=-6b9d-480b-b2c9-12b28c96c7f6): show databases
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=-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
+------------------+
| databaseName|
+------------------+
| default|
|information_schema|
| sys|
| test*****|
+------------------+ {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
was:
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
> 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
> Priority: Major
>
> 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://********> 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=-6b9d-480b-b2c9-12b28c96c7f6);
> Time taken: 0.023 seconds
> INFO : Executing command(queryId=-6b9d-480b-b2c9-12b28c96c7f6): show databases
> INFO : Starting task [Stage-0:DDL] in serial mode
> INFO : Completed executing command(queryId=-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
> +------------------+
> | databaseName|
> +------------------+
> | default|
> |information_schema|
> | sys|
> | test*****|
> +------------------+ {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)
