Hi Guys, I Hive .13 for this conversion: select cast('2999-12-31 23:59:59' as timestamp) I get: 1830-11-23 00:50:51.580896768 up to around year 2199 it works fine, the work around is to convert the string to int and then back to timestamp: from_unixtime(unix_timestamp('2999-12-31 23:59:59.000000')
But why is this issue happening in the first place? Thanks,