A number of enhancements were made to processors like QueryDatabaseTable to allow for such things as:
- Splitting result sets into multiple flow files (i.e. Max Rows Per Flowfile property)
- Max number of splits/rows returned (Max fragments)
- Normalizing names to be Avro-compatible
The RDBMS processors also now support Avro logical types, but the version of Avro needed by the current version of Hive (1.2.1) is Avro 1.7.7, which does not support logical types.
These enhancements were made to JdbcCommon, but not to HiveJdbcCommon (the Hive version of the JDBC utils class). Since Hive queries can return even larger result sets than traditional RDBMS, these properties/enhancements are at least as valuable to have for SelectHiveQL.