You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-user@hadoop.apache.org by Yanbo Liang <yb...@gmail.com> on 2015/06/16 10:18:57 UTC

Re: Hive update functionality for External tables

I have also try to use these functionality but it did not work well for
external table.
It has many restricts for the underlying file of the table which will be
update/delete such as supporting AcidOutputFormat, is bucked etc. It
support only ORC as the file format until now and the table show also be
created with 'transactional'='true'.



2015-05-28 21:22 GMT+08:00 Raghavendra Chandra <
raghavchandra.learning@gmail.com>:

> Hi All,
>
> With the version 0.14 Hive supports Update functionality.
>
> I have tried updating a internal table and it works just like RDBMS Update
> command( though it takes more time to update).
>
> Please let me know if it is possible to UPDATE the EXTERNAL TABLES IN HIVE
> .
>
> Eagerly waiting for the response.
>
> Thanks and regards,
> Raghav Chandra
>