[
https://issues.apache.org/jira/browse/IMPALA-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu closed IMPALA-9480.
-----------------------
Resolution: Pending Closed
> 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 to connect to hive 3.1.0, 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_orc1;
> Query: select * from test_orc1
> Query submitted at: 2020-03-09 23:39:32 (Coordinator: http://vm1:25000)
> ERROR: AnalysisException: Operations not supported. Table ods.test_orc1
> 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.20.1#820001)
