hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: How to remove Hive table property?
Date Tue, 23 Aug 2016 12:12:59 GMT
Has table got data in it?

Can you create a new table WITHOUT serialization.null.format and
INSERT/SELECT from old to new, drop old and rename new to old.

If the data is already there then the setting will apply to new rows only.
That may be acceptable.

HTH

Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com


*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.



On 23 August 2016 at 12:42, Igor Kuzmenko <f1sherox@gmail.com> wrote:

> I've created a Hive table with property "serialization.null.format"="null"
> to interpret string "null' as null. Now it's unnecessary for me. How can I
> remove it?
>
> Alter table properties page
> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTableProperties>
explain
> how to set new value, but I need completely remove it.
>
> Or setting "serialization.null.format"=null  is a correct way to do that?
>

Mime
View raw message