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 2020/02/23 07:02:00 UTC

[jira] [Comment Edited] (IMPALA-9391) Impala 3.3.0 can't support Transactional (ACID) tables

    [ https://issues.apache.org/jira/browse/IMPALA-9391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17042816#comment-17042816 ] 

liu edited comment on IMPALA-9391 at 2/23/20 7:01 AM:
------------------------------------------------------

[~joemcdonnell]  Thank you for your answer. Later I also found that hive3 needs to be compiled. The compilation is successful. The impalad catalogd statestored service can be started normally, but it cannot be synchronized to the metadata of hive 2. Does Impala 3.3.0 compile according to hive3 and still support hive2 and support Aicd features?


was (Author: zx778899):
[~joemcdonnell]  Thank you for your answer. Later, I also found that hive3 needs to be compiled. The compilation is successful. The impalad catalogd statestored service can be started normally, but it cannot be synchronized to the metadata of hive 2. Does Impala 3.3.0 compile according to hive3? Does it support the Aicd feature?

> Impala 3.3.0  can't support Transactional (ACID) tables
> -------------------------------------------------------
>
>                 Key: IMPALA-9391
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9391
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 3.3.0
>         Environment: hdp : CDH-6.2.1  
> impala: Apache-impala-3.3.0
>            Reporter: liu
>            Priority: Critical
>         Attachments: 112233.jpg
>
>
> IMPALA-8813  has already support  Create, Insert, and read Insert-only ACID tables
> but,I created the hive table like this
> {code:java}
> CREATE TABLE test_orc9 (
> id INT,
> name STRING
> )
> CLUSTERED BY (id)  INTO 5 BUCKETS
> STORED AS ORC
> TBLPROPERTIES("transactional"="true","transactional_properties"="insert_only","compress.mode"="SNAPPY")
> ;
> {code}
> Query sql: select * from test_orc9
> Error: AnalysisException: Table ods.test_orc9 not supported. Transactional (ACID) tables are only supported for read
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org