[jira] [Commented] (PIG-5079) HCatalog - overwrite

["Artem Ervits (JIRA)" <ji...@apache.org>]

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

Artem Ervits commented on PIG-5079:
-----------------------------------

according to https://issues.apache.org/jira/browse/HIVE-6897 append is default behavior and overwrite should be disabled by setting table to immutable = true. My experience is documented in https://community.hortonworks.com/questions/72032/hcatstorer-is-not-overwriting-a-hive-table-or-how.html
it's best to use a temporary table to achieve the requirement in this jira.

> HCatalog - overwrite
> --------------------
>
>                 Key: PIG-5079
>                 URL: https://issues.apache.org/jira/browse/PIG-5079
>             Project: Pig
>          Issue Type: Improvement
>          Components: build, data
>    Affects Versions: 0.15.0
>            Reporter: Praveen PentaReddy
>            Priority: Minor
>
> In HCatalog, i am using hive table and doing transformation and after completing the transformation i want to overwrite the data back to the same hive table.however, while writing back the data to the same table, the transformed data is getting appended rather not getting overwrite.
> It would be good if we have option like overwrite so that if need we can use overwrite or append as we have this kind of feature in hive while importing the data into a hive table.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)