Results of 1 - 1 of about 1 for DuckDBArray (0.001 sec.)
- Run Queries 9414
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...et with getObject , which returns the following types: DuckDB type Java type returned by getObject LIST , ARRAY org.duckdb.DuckDBArray (implements java.sql.Array ) STRUCT org.duckdb.DuckDBStruct (implements java.sql.Struct ) MAP java.util.LinkedHashMap UNIO...e ENUM String try (ResultSet rs = stmt.executeQuery("SELECT [1, 2, 3] AS l, {'a': 1, 'b': 2} AS s")) { while (rs.next()) { DuckDBArray list = (DuckDBArray) rs.getObject(1); Object[] values = (Object[]) list.getArray(); DuckDBStruct struct = (DuckDBStruct) r..., getUuid(int) , getHugeint(int) , and getJsonObject(int) . DuckDBStruct.getMap() returns the struct fields keyed by name. DuckDBArray.getResultSet() exposes the list elements as an org.duckdb.DuckDBArrayResultSet , a read-only ResultSet with two columns: I... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work