HangyuanLiu commented on issue #3325: orc file issue when load data to doris(version:0.12.0-rc03) URL: https://github.com/apache/incubator-doris/issues/3325#issuecomment-614391820 > > the timestamp of '2000-12-07 12:09:54' is 976162194。Why timestamp is negative？ > > oh, i only type a example , the negtive like this: (1960-12-03 00:00:00.0 -->-286531200 ) > > 1|-2209017600 | 1900-01-01 00:00:00.0 > 2 | -156844800 | 1965-01-12 00:00:00.0 > 3 | -286531200 | 1960-12-03 00:00:00.0 > 4 | -462700800 | 1955-05-05 00:00:00.0 > 5 | -46512000 | 1968-07-12 00:00:00.0 > 6 | -390211200 | 1957-08-21 00:00:00.0 > 7 | -235814400 | 1962-07-13 00:00:00.0 > 8 | -132825600 | 1965-10-17 00:00:00.0 > 9 | -186393600 | 1964-02-05 00:00:00.0 > 10 | -2180073943 | 1900-12-02 00:00:00.0 > 11 | -2204265943 | 1900-02-25 00:00:00.0 Because the from_unixtime function currently does not support datetime earlier than 1970, it results in a time error. This problem will be solved soon, currently blocked by a pre-PR #3300
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
