[
https://issues.apache.org/jira/browse/PIG-5079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15786126#comment-15786126
]
Artem Ervits edited comment on PIG-5079 at 12/29/16 9:04 PM:
-------------------------------------------------------------
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.
[~daijy] any thoughts?
was (Author: dbist13):
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)
