[
https://issues.apache.org/jira/browse/IMPALA-9391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040413#comment-17040413
]
Joe McDonnell commented on IMPALA-9391:
---------------------------------------
To use Hive ACID tables, Impala needs to be compiled with Hive 3 support by
building with the USE_CDP_HIVE environment variable set to "true". Without
USE_CDP_HIVE=true, Impala compiles against Hive 2, which does not have Hive
ACID support. The error you are seeing is the error that Impala would throw if
it does not have Hive ACID support, so that may be the cause.
This error text is a bit deceptive. It should make it clear if Impala has been
compiled without Hive ACID support.
> 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]
