Description
Thanks for your work.
It seems have a problem with timestamp or i've not used correctly your jar
for testing i have got this file
hello|1|2003-03-05 18:09:28.0
world|2|2006-03-05 17:09:28.0
Use the jar like this :
java -jar csv-to-orc.jar -i hello.csv -o hello.orc -s 'structbonjour:string,num:int,create_date:timestamp' -sep '|' -skipcount 0
Dump the orc file :
$ hive --orcfiledump -d -t /user/hdp/test/hello.orc
2017-12-07 09:49:58,366 INFO [main] orc.RecordReaderImpl: Reader schema not provided -- using file schema structbonjour:string,num:int,create_date:timestamp
{"bonjour":"hello","num":1,"create_date":"1970-01-01 01:00:00"}
{"bonjour":"world","num":2,"create_date":"1970-01-01 01:00:00"}
the timstamp is set to linux time. it is the behavior of your jar ?
I have excepted to retreive the timestamp of csv file.
regards