[
https://issues.apache.org/jira/browse/SPARK-15348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16957679#comment-16957679
]
Zhaoyang Qin edited comment on SPARK-15348 at 10/23/19 9:15 AM:
----------------------------------------------------------------
[~asomani] when i use the following codes：`
{{scala> spark.sql("create table test.cars using HiveAcid options ('table'
'test.acidtbl')")}}`,
i got an AnalysisException(HiveException) :
`org.apache.spark.sql.AnalysisException:
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Table
test.cars failed strict managed table checks due to the following reason: Table
is marked as a managed table but is not transactional.);`
Any help for this?
Also, this cluster is HDP3.0 based,the Spark ver2.3.1 & hive 3.0.0.
was (Author: kelvin.fe):
[~asomani] when i use the following codes：`
{{scala> spark.sql("create table test.cars using HiveAcid options ('table'
'test.acidtbl')")}}`,
i got a AnalysisException(HiveException) :
`org.apache.spark.sql.AnalysisException:
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Table
test.cars failed strict managed table checks due to the following reason: Table
is marked as a managed table but is not transactional.);`
Any help for this?
Also, this cluster is HDP3.0 based,the Spark ver2.3.1 & hive 3.0.0.
> Hive ACID
> ---------
>
> Key: SPARK-15348
> URL: https://issues.apache.org/jira/browse/SPARK-15348
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 1.6.3, 2.0.2, 2.1.2, 2.2.0, 2.3.0
> Reporter: Ran Haim
> Priority: Major
>
> Spark does not support any feature of hive's transnational tables,
> you cannot use spark to delete/update a table and it also has problems
> reading the aggregated data when no compaction was done.
> Also it seems that compaction is not supported - alter table ... partition
> .... COMPACT 'major'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
