hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Attila Magyar (JIRA)" <>
Subject [jira] [Commented] (HIVE-21666) Bad behavior with 'insert_only' property on non-transactional table
Date Thu, 13 Jun 2019 07:56:00 GMT


Attila Magyar commented on HIVE-21666:

[~tlipcon], alter table goes through the same validation
> create table aaa(key int) stored as orc;
> ALTER TABLE aaa SET TBLPROPERTIES ('transactional_properties'='insert_only');
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
Cannot set 'transactional_properties' to 'insert_only' without setting 'transactional' to
'true' (state=08S01,code=1){code}

> Bad behavior with 'insert_only' property on non-transactional table
> -------------------------------------------------------------------
>                 Key: HIVE-21666
>                 URL:
>             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

This message was sent by Atlassian JIRA

View raw message