Creating new table with subsequent rename seems good for me. Thanks for advice, Mich.
On Tue, Aug 23, 2016 at 3:12 PM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > 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? >> > >