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
