How to calculate seconds between two timestamps in Impala? How to calculate seconds between two timestamps in Impala? hadoop hadoop

How to calculate seconds between two timestamps in Impala?


unix_timestamp(finish_time)-unix_timestamp(start_time) will give you the seconds between them.