I am trying to import data into kudu tables via Talend.
In Kudu, I have 2 columns that I am using to test how to store date values: one is one type BigInt and the other of type Timestamp.
In Talend, I convert the date value into long and it saves the data correctly
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = format.parse(input_row.agencystartdate.toString());
long millis = date.getTime();
output_row.agencystartdatemillis = millis;
for example, "2007-09-04 00:00:00.0" gets saved as 1,188,849,600,000 (which when converted gived the date correctly)
When I save the same data in the the Kudu Timestamp column, the value is "14/01/1970 18:14:10" which is not good. All my dates are being saved in the year 1970.
How should I format the Date value to save it correctly in Kudu Timestamp?