According to https://issues.apache.org/jira/browse/HIVE-1378 Hive returns strings for complex types. I couldn’t find anything else on the subject, has there been any more work done in later versions of Hive to return actual objects in the JDBC driver? In NiFi we can have records/results/rows with complex types, but when we translate a Hive ResultSet into fields, complex types like arrays simply become Strings when IMO they’d be more useful as actual arrays, for downstream transformations etc.
Thank you in advance, Matt