hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahender bigdata <Mahender.BigD...@outlook.com>
Subject Re: Null Representation in Hive tables
Date Sun, 27 Dec 2015 15:37:18 GMT
Can any one update on this

On 12/23/2015 9:37 AM, mahender bigdata wrote:
> Our Files are not text Files, they are csv and dat. Any possibility to 
> include 2 serialization.null format in table property
>
> On 12/23/2015 9:16 AM, Edward Capriolo wrote:
>> 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