Turns out that dividing by 1000 solves the issue: CAST(tp.time_stamp/1000 AS timestamp) which outputs the correct date and time. I still find it odd that datetime from mysql gets stored as TIMESTAMP_MILLIS --> int64 in parquet and bigint for the field in impala which can't be converted back to datetime without an extra step, but, things work now...
... View more
