# Cannot query ARRAY columns using Arrow Flight JDBC Driver **URL:** \ **Category:** Uncategorized\ **Created:** [November 18, 2025, 11:45am UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263 "2025-11-18T11:45:44Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![mez](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mez/32/6597_2.png) [@mez](https://community.dremio.com/u/mez)\ **Post date:** [November 18, 2025, 11:45am UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263/1 "2025-11-18T11:45:44Z")
When using 3rd-party SQL tools with the Apache Arrow Flight JDBC driver, like _DBeaver_ or _Alation Compose_ for example, I see consistent error messages indicating the driver does not support columns with data type defined as ARRAY. Here’s DBeaver’s result when querying an ARRAY column using the sql “SELECT loc FROM Samples.samples.dremio.com.zips.json” in Dremio - error is “IndexOutOfBoundsException”: ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/6c0124285b890d5897d5d36fa75612894eb12657.jpeg) When querying a different column (also defined as an ARRAY) in Alation’s “Compose” sql tool, we see the error “DataTables warning: table id=DataTables\_Table\_0 - Requested unknown parameter ‘22’ for row 0, column 22”. This SQL tool uses the same Arrow driver. After some digging, it seems like the [arrow driver does not support the Array column type](https://docs.dremio.com/current/client-applications/drivers/arrow-flight-sql-jdbc-driver/#supported-data-types-and-set-methods). The ask: 1. I would really like to see array support added to the Arrow driver. So would my clients. 2. I would love to hear of any workarounds in the meantime. A question: - Since the Arrow Flight driver is built and maintained by Apache, how can users and partners request features and influence the roadmap? Thanks. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [November 23, 2025, 5:05am UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263/2 "2025-11-23T05:05:27Z")
@mez Goof find, I am able to reproduce the issue but a few other struct columns work, while a different LIST column failed. Let me check this and get back to you ---
**Author:** ![mez](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mez/32/6597_2.png) [@mez](https://community.dremio.com/u/mez)\ **Post date:** [November 24, 2025, 12:57pm UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263/3 "2025-11-24T12:57:45Z")
Thanks @balaji.ramaswamy I really appreciate you looking into this! ---
**Author:** ![mez](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mez/32/6597_2.png) [@mez](https://community.dremio.com/u/mez)\ **Post date:** [January 15, 2026, 3:48pm UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263/4 "2026-01-15T15:48:09Z")
@balaji.ramaswamy Happy new year! Did your checks come up with anything? Perhaps driver support for arrays is on the roadmap this year? 🙏🤞 ---
**Author:** ![Helder\_Gregorio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/helder_gregorio/32/6196_2.png) [@Helder\_Gregorio](https://community.dremio.com/u/Helder_Gregorio)\ **Post date:** [January 19, 2026, 3:11pm UTC](https://community.dremio.com/t/cannot-query-array-columns-using-arrow-flight-jdbc-driver/13263/5 "2026-01-19T15:11:29Z")
Hi @mez, This is an issue with the arrow flight jdbc driver. The driver was not respecting the JDBC spec. I’ve already committed a fix to the community [GH-964: Fix IndexOutOfBoundsException in Array.getResultSet() for JDBC clients by xborder · Pull Request #965 · apache/arrow-java · GitHub](https://github.com/apache/arrow-java/pull/965).