[ https://issues.apache.org/jira/browse/HIVE-11883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14942147#comment-14942147 ]
Lefty Leverenz commented on HIVE-11883: --------------------------------------- Doc note: The "Table Properties" section of the Hive Transactions wikidoc needs to be updated for this change, with version information. * [Hive Transactions -- Table Properties | https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties] The DDL wikidoc doesn't need any change -- it just shows lowercase "transactional" and refers to Hive Transactions for more information. (However it does need revision for HIVE-8308, which made "NO_AUTO_COMPACTION" case-insensitive in 1.1.0.) > 'transactional' table property for ACID should be case insensitive > ------------------------------------------------------------------ > > Key: HIVE-11883 > URL: https://issues.apache.org/jira/browse/HIVE-11883 > Project: Hive > Issue Type: Bug > Components: Transactions > Affects Versions: 1.0.0 > Reporter: Eugene Koifman > Assignee: Eugene Koifman > Labels: TODOC1.3 > Fix For: 1.3.0 > > Attachments: HIVE-11883.patch > > > Given: > {noformat} > CREATE TABLE mytable (col1 int, col2 string) > CLUSTERED BY (col1) INTO 2 BUCKETS > STORED AS ORC TBLPROPERTIES('TRANSACTIONAL'='TRUE'); > {noformat} > update/delete statements will fail with > {noformat} > FAILED: SemanticException [Error 10122]: Bucketized tables do not support > INSERT INTO: Table: default.mytable > {noformat} > but 'transactional' (in lower case) works fine -- This message was sent by Atlassian JIRA (v6.3.4#6332)