The CData ODBC Driver for Apache Hive supports joins of a nested array with its parent document and joins of multiple collections.