CODEWITHSUNDEEP
sqlhadoophiveimpala
ADJ
ADJ

Reputation: 5282

How to calculate seconds between two timestamps in Impala?

I do not see an Impala function to subtract two datestamps and return seconds (or minutes) between the two. http://www.cloudera.com/documentation/archive/impala/2-x/2-0-x/topics/impala_datetime_functions.html

Upvotes: 15

Views: 23215

Answers (1)

Harper Koo
Harper Koo

Reputation: 627

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

Upvotes: 27

Related Questions