Limitations in Hive

The following list summarizes the limitations in pure Hive (connection to Hive database directly):

Reverse engineering from database processing is slow due to the absence of system tables. The required information is retrieved by manual parsing methods instead of a query language.
User-defined functions are not supported.
Retrieval of version information using the Hive command is not supported.
A few index properties, such as deferred rebuild option, idxProperties, and Null Defined As are not supported.