View the original community article here
Last tested: Feb 7, 2018
You may be getting this error because Looker's SQL Runner is unable to return Arrays in the query results. If the column is a type Array and is in the Select statement, users may encounter the error Java::JavaLang::ClassCastException:
When using arrays, it may be necessary to UNNEST or convert Array to String. A couple functions that can solve for this error are:
Google BigQuery
UNNEST
The UNNEST operator takes an ARRAY and returns a table, with one row for each element in the ARRAY. You can also use UNNEST outside of the FROM clause with the IN operator.
Converting Arrays to Strings
The ARRAY_TO_STRING() function allows you to convert an ARRAY<STRING> to a single STRING value or an ARRAY<BYTES> to a single BYTES value where the resulting value is the ordered concatenation of the array elements.
See Google Documentation here for more information:
https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays
This content is subject to limited support.