Repository navigation
DatabricksArray.getResultSet() is not implemented #1737
Description
Is your feature request related to a problem? Please describe.
DatabricksArray.getResultSet() is not supported, all 4 implementations throw DatabricksSQLFeatureNotSupportedException("getResultSet() not implemented").
Describe the solution you'd like
DatabricksArray.getResultSet() should return a ResultSet with one row for each element. Other JDBC drivers like Postgres and ClickHouse support this.
Databricks:
String connStr = "jdbc:databricks://<DATABRICKS_HOST>:443/";
try (Connection con = DriverManager.getConnection(connStr, props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ARRAY['a', 'b', 'c']")) {
rs.next();
Array array = rs.getArray(1);
ResultSet elements = array.getResultSet(); // throws here
while (elements.next()) {
System.out.println(elements.getLong(1) + " -> " + elements.getString(2));
}
}Exception in thread "main" java.sql.SQLFeatureNotSupportedException: getResultSet not supported
at io.trino.jdbc.TrinoArray.getResultSet(TrinoArray.java:89)
at Main.main(Main.java:16)
Postgres:
String connStr = "jdbc:postgresql://localhost:5432/postgres";
try (Connection con = DriverManager.getConnection(connStr, "user", "password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ARRAY['a', 'b', 'c']")) {
rs.next();
Array array = rs.getArray(1);
ResultSet elements = array.getResultSet();
while (elements.next()) {
System.out.println(elements.getLong(1) + " -> " + elements.getString(2));
}
}1 -> a
2 -> b
3 -> c
Describe alternatives or workarounds you've considered
You can work around by calling getArray and doing some ugly casting.
Additional context
N/A
Activity
peco-engineer-bot commentedon Oct 22, 2026
🤖 engineer-bot opened a fix PR: #1739
Review before merge.
Implement DatabricksArray.getResultSet() (databricks#1739)