[
https://issues.apache.org/jira/browse/IMPALA-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu updated IMPALA-9480:
------------------------
Component/s: Frontend
Affects Version/s: Impala 3.3.0
Description:
I am using impala 3.3.0 version to connect to hive 3.1.0, and can connect hive
metadata normally. But the execution of the query prompts the following error
{code:java}
CREATE Table test_orc1 (
id INT,
name STRING
)
CLUSTERED BY (id) INTO 5 BUCKETS
STORED AS ORC
TBLPROPERTIES("transactional"="true", "transactional_properties"="insert_only")
;
[vm1:21000] ods> select * from test_orc3;
Query: select * from test_orc3
Query submitted at: 2020-03-09 23:39:32 (Coordinator: http://vm1:25000)
ERROR: AnalysisException: Operations not supported. Table ods.test_orc3 access
type is: NONE
{code}
The error looks like a permission issue, but I don't know where to set the
permission
I executed the insert statement and got an error
{code:java}
CREATE Table test_orc2 (
> id INT,
> name STRING
> )
> STORED AS ORC
> TBLPROPERTIES("transactional"="true",
"transactional_properties"="insert_only")
> ;
Query: insert into test_orc2 values(1,"a")
Query submitted at: 2020-03-09 23:59:49 (Coordinator: http://vm1:25000)
ERROR: IllegalStateException: Unsupported TableSink format(s): ORC
{code}
Impala 3.3.0 seems to support ACID Insert_only to insert data. Why does my
environment report an error and how do I set this up?
Environment:
hdp 3.1.1
hive 3.1.0
impala 3.3.0
> Impala 3.3.0 query access type
> -------------------------------
>
> Key: IMPALA-9480
> URL: https://issues.apache.org/jira/browse/IMPALA-9480
> Project: IMPALA
> Issue Type: Question
> Components: Frontend
> Affects Versions: Impala 3.3.0
> Environment: hdp 3.1.1
> hive 3.1.0
> impala 3.3.0
> Reporter: liu
> Priority: Major
>
> I am using impala 3.3.0 version to connect to hive 3.1.0, and can connect
> hive metadata normally. But the execution of the query prompts the following
> error
> {code:java}
> CREATE Table test_orc1 (
> id INT,
> name STRING
> )
> CLUSTERED BY (id) INTO 5 BUCKETS
> STORED AS ORC
> TBLPROPERTIES("transactional"="true",
> "transactional_properties"="insert_only")
> ;
> [vm1:21000] ods> select * from test_orc3;
> Query: select * from test_orc3
> Query submitted at: 2020-03-09 23:39:32 (Coordinator: http://vm1:25000)
> ERROR: AnalysisException: Operations not supported. Table ods.test_orc3
> access type is: NONE
>
> {code}
> The error looks like a permission issue, but I don't know where to set the
> permission
>
> I executed the insert statement and got an error
> {code:java}
> CREATE Table test_orc2 (
> > id INT,
> > name STRING
> > )
> > STORED AS ORC
> > TBLPROPERTIES("transactional"="true",
> "transactional_properties"="insert_only")
> > ;
> Query: insert into test_orc2 values(1,"a")
> Query submitted at: 2020-03-09 23:59:49 (Coordinator: http://vm1:25000)
> ERROR: IllegalStateException: Unsupported TableSink format(s): ORC
> {code}
> Impala 3.3.0 seems to support ACID Insert_only to insert data. Why does my
> environment report an error and how do I set this up?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
