Hi @Retired_mod 

many thanks for your response. I followed your proposed steps to resolve the issue

1. We use the latest released driver version which is 2.6.36: https://www.databricks.com/spark/jdbc-drivers-archive 
2. yes. this is indeed the issue: not an ARRAY is returned but a VARCHAR type
3. Unfortunately with explicitely defining the result name does not change the resulting type. I don´t see that the expected data type is specified with adding AS result_value
4. Unfortunately nothing changed

Does the underlying Simba Driver support complex types such as ARRAY?