3 ms·
I’ve seen too many people write a query like where ts between txn_start and txn_end order by ts and not even realize that what they’re seeing is incomplet
by erik_seaberg 3y ago
I’ve seen too many people write a query like
where ts between txn_start and txn_end
order by ts
and not even realize that what they’re seeing is incomplete and misleading. Clock skew is very common, and we shouldn’t sweep that under the rug to promote time ordering, because people want to believe this works the way they think.
- Foobar8568 3y agoClock skews in a single node database? Actual question.
- erik_seaberg 3y agoUsually Hive or Dremel, with rows ingested from frontend instance logs. I get that it would actually work on a smaller system with a single server assigning times (or a quorum, if leader election ensures a monotonic clock).
- Foobar8568 3y agoThank you, I was just wondering if it was something I missed out on simpler systems and not distributed ones.
- erik_seaberg 3y agoNah, places I’ve worked are just choosing commodity hardware and geographically distributed systems over (very expensive) centralized ones.