KNOWLEDGE BASE

Unable to Run Extract When Using Nested SPLIT() on Arrays with Amazon EMR Hive


Published: 28 Nov 2016
Last Modified Date: 29 Nov 2016

Issue

When using nested SPLIT() on arrays with an Amazon EMR (Amazon Elastic MapReduce) Hive data source, large queries are created and they take a very long time to process.

Environment

  • Tableau Desktop 10.0.1
  • Amazon Elastic MapReduce

Resolution

Using the explode() function in the Hive as a saved view or in a custom SQL statement will create a new row for each value in the array. This eliminates the need to use the SPLIT() function at all.
Did this article resolve the issue?