I am trying to scoop import Date column from oracle database to Avro format. Below is the sample on how I am executing.
My options file content
--target-dir /.. / --delete-target-dir --as-avrodatafile --query Select chg_ts from abc --map-column-java chg_ts=String
My scoop import contains
After doing the above steps I am still getting the date as "type" : [ "null", "long" ] in avro file and takes Bigint in Hive.
Please guide me if I am missing something here.