You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: