Re: Null Representation in Hive tables
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 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
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 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.bigd...@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 >> > > > > -- Sorry this was sent from mobile. Will do less grammar and spell check than usual.
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 that column it should not run the UDF unecessarily. Most of the times I use a CTE, I really wish there was a "CREATE TEMPORARY VIEW" for me to avoid prefixing all queries. Cheers, Gopal