Hive lets you use SQL on Hadoop, but tuning SQL on a distributed system is different. Here are 12 tips to help your effort fly Hive is not an RDBMS, but it pretends to be one most of the time. It ...

Hive provides three types of UDFs (user-defined functions) that can be used within queries for custom processing. For example, let’s say you want to do a query that’s not part of the built-in SQL.