The CData Cmdlets PowerShell Module for Apache Hive supports joins of a nested array with its parent document and joins of multiple collections.