hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Null Representation in Hive tables
Date Wed, 23 Dec 2015 17:16:25 GMT
In text formats the null is accepted as \N.

On Wed, Dec 23, 2015 at 12:00 PM, mahender bigdata <
Mahender.BigData@outlook.com> wrote:

> Hi,
>
> Is there any possibility of mentioning both*
> "serialization.null.format"=""  and  **"serialization.null.format"="\000"
> *has table properties, currently we are creating external table, where
> there is chance of having data with empty string or \000,  As a  work
> around, we have created 2 external tables, one with "serialization.null.format"=""
> has table property and another with "serialization.null.format"="\000"
> where we insert data from external table 1 to table 2. Is there way to
> reduce to single step having mentioning both *"serialization.null.format"=""
> and  **"serialization.null.format"="\000"* in the same table property.
>
> Thanks,
> Mahender
>

Mime
View raw message