Active is either brand new threads like this one (at the time of posting this comment) or older threads with lots of actual activity in terms of comments and upvotes.
Hot is generally more consistent in showing threads from within the last 24 hours, including threads with smaller amounts of activity.