[
https://issues.apache.org/jira/browse/IMPALA-9391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051695#comment-17051695
]
Joe McDonnell commented on IMPALA-9391:
---------------------------------------
[~zx778899] We test two configurations. One compiles against Hive 2 and runs
with a Hive 2 metastore, and Hive 2 does not support ACID. The other compiles
with Hive 3 and runs with a Hive 3 metastore, and it works with ACID. We don't
test configurations that mix versions, and Hive ACID will only work with 100%
Hive 3.
> 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: [email protected]
For additional commands, e-mail: [email protected]
