[
https://issues.apache.org/jira/browse/IMPALA-9391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu updated IMPALA-9391:
------------------------
Description:
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
was:
IMPALA-8813 is already support Create, Insert, and read Insert-only ACID
tables
but,I'm Create hive table like
{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
> 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]
