Kundan Kumar Jha created HIVE-28039:
---------------------------------------
Summary: Select query is not working for partition tables for
table {owners}
Key: HIVE-28039
URL: https://issues.apache.org/jira/browse/HIVE-28039
Project: Hive
Issue Type: Bug
Components: Hive
Reporter: Kundan Kumar Jha
When giving access to a user through owner policy and tried to access the
partition table through spark and through beeline its giving error.
*Steps to reproduce:*
1. clear all the policies in ranger hive.
2. create 2 policies:
a. give hrt_21 user access to create any database.
b. create a owner policy for all access on db1.
3. Then create a database named db1 using hrt_21 as query user.
4. Then create a table inside the db1 named table1 with partition with query
like:
"create table db1.table1(id int, name string) partitioned by (city
String);"
5. Then try to query the table using spark shell as well as beeline that will
result into following errors:
On Spark shell:
Its giving the following error
{code:java}
org.apache.hadoop.hive.ql.metadata.HiveException:
NoSuchObjectException(message:Table table1 does not exist) {code}
when tried:
{code:java}
spark.sql("select * from db1.table1").show() {code}
and
{code:java}
spark.sql("select * from db1.table1 where city='partition_value'").show()
{code}
But on beeline its giving error for this
{code:java}
select * from db1.table1; {code}
But showing result following result
{code:java}
select * from db1.table1 where city='partition_value' {code}
result:
{code:java}
+----------------+------------------+------------------+
| some_table.id | some_table.name | some_table.city |
+----------------+------------------+------------------+
+----------------+------------------+------------------+ {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
