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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Impala 3.3.0
• Component/s: Backend
• Environment: hdp : CDH-6.2.1 ; impala: Apache-impala-3.3.0
• Flags: Important
• External issue URL: https://issues.apache.org/jira/browse/IMPALA-8813
• Target Version: Impala 3.3.0
• Epic Color: ghx-label-11
• Assignee: Unassigned
• Reporter: liu
• Created: 16/Feb/20 16:14
• Updated: 09/Mar/20 16:15
• Resolved: 09/Mar/20 16:15

Description

IMPALA-8813  has already support  Create, Insert, and read Insert-only ACID tables

but,I created the hive table like this

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")
;

Query sql: select * from test_orc9

Error: AnalysisException: Table ods.test_orc9 not supported. Transactional (ACID) tables are only supported for read