For some reason that we don't need to go into here, we want to find cases where a driver has the same last_name as a passenger or the same first name as a passenger. Here's the obvious way to write this query:

This gives you some idea of the productivity level you can achieve with PostgreSQL compared with Hive. Everything in Hive seems to be a big drama. With Hive you have to keep trying things, re-reading the documentation, rummage around on the community pages. Eventually you get something that is right, if you're lucky. PostgreSQL is particularly good, but most of the established real relational databases are much closer to PostgreSQL in productivity and miles ahead of Hive.