You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "liu (Jira)" <ji...@apache.org> on 2022/03/30 17:35:00 UTC
[jira] [Updated] (IMPALA-11212) Operations not supported. Table test.t1 access type is: NONE
[ https://issues.apache.org/jira/browse/IMPALA-11212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu updated IMPALA-11212:
-------------------------
Description:
I can successfully create a hive table using impala
{code:java}
[gpmaster:21050] test> create table t1 (a string);
Query: create table t1 (a string)
+-------------------------+
| summary |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.42s
[gpmaster:21050] test> show tables;
Query: show tables
+------+
| name |
+------+
| t1 |
+------+
Fetched 1 row(s) in 0.01s
{code}
But I failed to access this hive table
{code:java}
[gpmaster:21050] test> select * from t1;
Query: select * from t1
Query submitted at: 2022-03-31 00:27:11 (Coordinator: http://gpmaster:25000)
ERROR: AnalysisException: Operations not supported. Table test.t1 access type is: NONE {code}
The error looks like a permission issue, but I don't know where to set the permission
was:
I can successfully create a table using impala
{code:java}
[gpmaster:21050] test> create table t1 (a string);
Query: create table t1 (a string)
+-------------------------+
| summary |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.42s
[gpmaster:21050] test> show tables;
Query: show tables
+------+
| name |
+------+
| t1 |
+------+
Fetched 1 row(s) in 0.01s
{code}
But I failed to access this table
{code:java}
[gpmaster:21050] test> select * from t1;
Query: select * from t1
Query submitted at: 2022-03-31 00:27:11 (Coordinator: http://gpmaster:25000)
ERROR: AnalysisException: Operations not supported. Table test.t1 access type is: NONE {code}
The error looks like a permission issue, but I don't know where to set the permission
> Operations not supported. Table test.t1 access type is: NONE
> -------------------------------------------------------------
>
> Key: IMPALA-11212
> URL: https://issues.apache.org/jira/browse/IMPALA-11212
> Project: IMPALA
> Issue Type: Question
> Components: Catalog
> Affects Versions: Impala 4.0.0
> Environment: hdp 3.1.1
> hive 4.0
> impala 4.0
> Reporter: liu
> Priority: Major
> Fix For: Impala 4.0.0
>
>
> I can successfully create a hive table using impala
> {code:java}
> [gpmaster:21050] test> create table t1 (a string);
> Query: create table t1 (a string)
> +-------------------------+
> | summary |
> +-------------------------+
> | Table has been created. |
> +-------------------------+
> Fetched 1 row(s) in 0.42s
> [gpmaster:21050] test> show tables;
> Query: show tables
> +------+
> | name |
> +------+
> | t1 |
> +------+
> Fetched 1 row(s) in 0.01s
> {code}
> But I failed to access this hive table
> {code:java}
> [gpmaster:21050] test> select * from t1;
> Query: select * from t1
> Query submitted at: 2022-03-31 00:27:11 (Coordinator: http://gpmaster:25000)
> ERROR: AnalysisException: Operations not supported. Table test.t1 access type is: NONE {code}
> The error looks like a permission issue, but I don't know where to set the permission
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org