[
https://issues.apache.org/jira/browse/HIVE-11219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14621173#comment-14621173
]
Johndee Burks commented on HIVE-11219:
--------------------------------------
Also I can make this change, how do I get rights to edit the page? I propose
something like this:
If a table is to be used in ACID writes (insert, update, delete) then the table
property "transactional" must be set on that table to "true", starting with
Hive 0.14.0. Without this value, inserts will be done in the old style;
updates and deletes will be prohibited. However, this does not apply to Hive
0.13.0. An example DDL is below:
{code}
CREATE TABLE transactme(
key int,
id int)
CLUSTERED BY (
id)
INTO 3 BUCKETS
STORED AS orc
TBLPROPERTIES ('transactional'='true')
{code}
> Transactional documentation is unclear
> --------------------------------------
>
> Key: HIVE-11219
> URL: https://issues.apache.org/jira/browse/HIVE-11219
> Project: Hive
> Issue Type: Improvement
> Components: Transactions
> Reporter: Johndee Burks
> Assignee: Johndee Burks
> Priority: Minor
>
> At the
> [this|https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions]
> link the following is said.
> "If a table is to be used in ACID writes (insert, update, delete) then the
> table property "transactional" must be set on that table, starting with Hive
> 0.14.0. Without this value, inserts will be done in the old style; updates
> and deletes will be prohibited. However, this does not apply to Hive 0.13.0."
> It does not tell you what the value of transactional should be. I think we
> should say it needs to be true and we should show an example DDL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
