You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Attila Magyar (JIRA)" <ji...@apache.org> on 2019/06/12 09:32:00 UTC

[jira] [Comment Edited] (HIVE-21666) Bad behavior with 'insert_only' property on non-transactional table

    [ https://issues.apache.org/jira/browse/HIVE-21666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16861940#comment-16861940 ] 

Attila Magyar edited comment on HIVE-21666 at 6/12/19 9:31 AM:
---------------------------------------------------------------

[~tlipcon], yeah, thanks, I was able to reproduce it by setting the following properties:

{code:java}
Create Tables as ACID Insert Only = false
Create Tables as Full ACI = false
metastore.strict.managed.tables = false;{code}

However it looks this has been already fixed as part of HIVE-20343 (see [SemanticAnalyzer.java|https://github.com/apache/hive/commit/4ba12f2f47fb3318a139dc64efd7c0eabfca7a4c#diff-f2040374293a91cbcc6594ee571b20e4R13005]). This patch only exists on the master branch.

[~ashutoshc], Do you think we should be backport this back to the 3.x line?

cc: [~Rajkumar Singh], [~sershe]


was (Author: amagyar):
[~tlipcon], yeah, thanks, I was able to reproduce it by setting the following properties:

{code:java}
Create Tables as ACID Insert Only = false
Create Tables as Full ACI = false
metastore.strict.managed.tables = false;{code}

However it looks this has been already fixed as part of HIVE-20343 (see [SemanticAnalyzer.java|https://github.com/apache/hive/commit/4ba12f2f47fb3318a139dc64efd7c0eabfca7a4c#diff-f2040374293a91cbcc6594ee571b20e4]). This patch only exists on the master branch.

[~ashutoshc], Do you think we should be backport this back to the 3.x line?

cc: [~Rajkumar Singh], [~sershe]

> Bad behavior with 'insert_only' property on non-transactional table
> -------------------------------------------------------------------
>
>                 Key: HIVE-21666
>                 URL: https://issues.apache.org/jira/browse/HIVE-21666
>             Project: Hive
>          Issue Type: Bug
>          Components: Transactions
>            Reporter: Todd Lipcon
>            Assignee: Attila Magyar
>            Priority: Major
>
> I created a table with 'transactional_properties'='insert_only' but didn't specify 'transactional'='TRUE'. I was able to insert into this table, but when I tried to query it, I got a NumberFormatException since it appears the insert path used a non-transactional layout while the read path expected one.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)