avro-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jegan <jeganbas...@gmail.com>
Subject Fwd: Handling empty string in avro file
Date Tue, 22 Mar 2016 02:42:13 GMT
Hi All,

I am using avro file format to load the data in to hive and source system
is Teradata.  In the source i have a both NULL and empty string. But when
it landed in the hive its storing both as NULL only. For example

{
  "type" : "record",
  "name" : "Personal",
  "fields" : [ {
    "name" : "Id",
    "type" : [ "null", "int" ]
  }, {
    "name" : "name",
    "type" : [ "null", "string" ]
  }, {
    "name" : "age",
    "type" : [ "null", "int" ]
  }, {
    "name" : "zipcode",
    "type" : [ "null", "int" ]         --> have tried as "type" :int,
"default" : ""
  }]
}

Since integer value is empty in source, by above one comes as null as
defined i tried give "type" : int as well and comes as NULL.

Is there any way where i can get the empty string as it is in source.
Because in my landing hive table should contain both NULL and emptystring
and it has a different meaning for us . Your help would be appreciable.

Thank you

Regards,
Jegan

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message