[
https://issues.apache.org/jira/browse/RANGER-3845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal updated RANGER-3845:
------------------------------------
Labels: Trino (was: )
> trino query `CREATE TABLE ... AS ...` got access denied
> -------------------------------------------------------
>
> Key: RANGER-3845
> URL: https://issues.apache.org/jira/browse/RANGER-3845
> Project: Ranger
> Issue Type: Bug
> Components: plugins
> Affects Versions: 2.3.0
> Reporter: Yufan Ho
> Priority: Major
> Labels: Trino
>
> Got permission denied when executing a `CREATE TABLE .. AS SELECT ..`
> statement.
> But if it was split into two statements - `CREATE TABLE ..` and `INSERT INTO
> ..` - both statements will success.
> logs
> {code:java}
> trino:tmp> create table test as select 1 as a;
> Query 20220729_093308_02076_gznsx failed: Access Denied: Cannot create table
> hive.tmp.test
> trino:tmp> create table test (a int);
> CREATE TABLE
> trino:tmp> insert into test select 1;
> INSERT: 1 row
> Query 20220729_093357_02089_gznsx, FINISHED, 16 nodes
> Splits: 94 total, 94 done (100.00%)
> 0.61 [0 rows, 0B] [0 rows/s, 0B/s]
> {code}
> Environment:
> Ranger 2.3.0 admin-server
> Trino 370 with ranger-2.3.0-trino-plugin installed
> Granted all permissions to public group, including all 4 levels (catalog,
> schema, table, column)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
