# Spark Array Support - Flight JDBC Connector

**URL:** <https://community.dremio.com/t/spark-array-support-flight-jdbc-connector/11402>\
**Category:** Dremio University\
**Created:** [January 17, 2024, 11:54am UTC](https://community.dremio.com/t/spark-array-support-flight-jdbc-connector/11402 "2024-01-17T11:54:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexarl](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@Alexarl](https://community.dremio.com/u/Alexarl)\
**Post date:** [January 17, 2024, 11:54am UTC](https://community.dremio.com/t/spark-array-support-flight-jdbc-connector/11402/1 "2024-01-17T11:54:42Z")

</div>

We use on-prem installation of 23.2.2-202307280452300417-9276e770, Enterprise Edition.  
Recently we tried to connect to Dremio via flight-sql-jdbc-driver-10.0.0.jar from [Dremio JDBC Drivers](https://www.dremio.com/drivers/jdbc/), using iceberg-spark-runtime-3.4\_2.12-1.4.3.

In generally it works (for primitive types including timestamps), but we get an exception if we try to access ARRAY columns.  
The error:  
org.apache.spark.SparkSQLException: [UNRECOGNIZED\_SQL\_TYPE] Unrecognized SQL type - name: ARRAY, id: ARRAY.

Anyone has any idea how this problem could be fixed ?

---

<div class="post-metadata">

**Author:** ![bogdan.coman](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@bogdan.coman](https://community.dremio.com/u/bogdan.coman)\
**Post date:** [January 17, 2024, 10:02pm UTC](https://community.dremio.com/t/spark-array-support-flight-jdbc-connector/11402/2 "2024-01-17T22:02:15Z")

</div>

Hi @Alexarl

I don’t believe that connector was written by Dremio. However, I see in the code of that connector that the corresponding for array in Arrow is list: [spark-flight-connector/README.md at 46ce7b6559705d0828f7e5b863495908563718f4 · qwshen/spark-flight-connector · GitHub](https://github.com/qwshen/spark-flight-connector/blob/46ce7b6559705d0828f7e5b863495908563718f4/README.md?plain=1#L267)

Hopefully that helps, otherwise I suggest you get in touch with qwshen.

Thanks, Bogdan
