13

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

ADJ
  • 4,892
  • 10
  • 50
  • 83
  • You might use the method `unix_timestamp(timestamp datetime)` to convert the 2 `timestamp` values into `bigint`, then do the subtraction ? – Mincong Huang Mar 07 '16 at 20:38

1 Answers1

25

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

Harper Koo
  • 597
  • 5
  • 14