What is the best approach to convert a JSON to AVRO preserving the source datatypes.
My source JSON has a field with timestamp (value would look like 2017-01-26T00:00:00-05:00) which I need to eventually insert to a hive table with column type timestamp.
When I infer the schema, I get String for the timestamp field. Is there some pre-formatting that I can do on the timestamp field so that it gets inferred as timestamp field.
Current flow is as below -
JSON>>AVRO(infer/manually add schema)>>Streaming Insert to hive
Thanks @Timothy Spann The Avro version is 1.7.7 (looking at the pom.xml).
Is there a timestamp type in avro 1.7.7? I guess not. I could see the logicalType timestamp-* in 1.8
Should I assume that the timestamp would not work.