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 <f1she...@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? >
