4. "SQL-Like": Benefits And Drawbacks

HiveQL's similarity to SQL is both a benefit and a hazard.

On the one hand, HiveQL supports a lot of familiar operations: SELECT, GROUP BY, LIMIT, UNION, some support for subqueries.

On the other hand...or plethora of hands...

If you keep these distinctions in mind, you'll be fine. Otherwise, you may spend some time being confused.