Re: Null Representation in Hive tables

2015-12-27 Thread mahender bigdata
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

Re: Null Representation in Hive tables

2015-12-27 Thread Edward Capriolo
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 Files, they are csv and dat. A

Re: Null Representation in Hive tables

2015-12-27 Thread Gopal Vijayaraghavan
> 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 t