Why limit 10 is sometimes slow in Distributed SQL Engines?

When moving from traditional databases to distributed ones — in my case, the Hive database — I used to assume this query: