Re: Null Representation in Hive tables

Your best bet is take the serde you s re using and copy it and change the code to accept bith null types On Sunday, December 27, 2015, mahender bigdata wrote: > Can any one update on this > > On 12/23/2015 9:37 AM, mahender bigdata wrote: > > Our Files are not text

Re: Null Representation in Hive tables

> Your best bet is take the serde you s re using and copy it and change >the code to accept bith null types Or use a view with an IF(). For instance, I like the ease of generating groovy UDFs inline for quick-n-dirty state machines. We now do column pruning into views, so if you do not select

Re: Null Representation in Hive tables

In text formats the null is accepted as \N. On Wed, Dec 23, 2015 at 12:00 PM, mahender bigdata < mahender.bigd...@outlook.com> wrote: > Hi, > > Is there any possibility of mentioning both* > "serialization.null.format"="" and **"serialization.null.format"="\000" > *has table properties,

Null Representation in Hive tables

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

Re: Null Representation in Hive tables

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