DuckDBAppender doesn't support GEOMETRY values

[wyuxiao729]

My table structure is :

CREATE TABLE IF NOT EXISTS spatial_data ( id VARCHAR, name VARCHAR, geometry GEOMETRY )

When I created the DuckDBAppender, the following error occurred:

message: unsupported C API type: 40

I would like to know if this is caused by the GEOMETRY in the table. What types are currently supported by the DuckDBAppender? Is there a list of relevant supports? If it is not supported, will that mean I cannot perform batch data insertion through the DuckDBAppender method?

By the way, the version of duckdb_jdbc that I am currently using is 1.5.2.0

[wyuxiao729]

I have found all the data types supported by Appender in the official documentation. It's a pity that the GEOMETRY type is not supported. Are there any plans to add support for GEOMETRY in the future?

[staticlibs]

Hi, thanks for the report! Docs may be a bit outdated, almost all types are supported in Appender - list, with the notable absence of VARIANT (#643).

I've filed #672 to support GEOMETRY (as a WKB blob), going to backport it to 1.5 branch to include into 1.5.3 update.

[staticlibs]

@wyuxiao729

Just FYI, the GEOMETRY with Appender can be tried using this 1.5 snapshot:

<dependency>
    <groupId>org.duckdb</groupId>
    <artifactId>duckdb_jdbc</artifactId>
    <version>1.5.3.0-50964864-SNAPSHOT</version>
  </dependency>

  <repository>
    <id>central-snapshots</id>
    <url>https://central.sonatype.com/repository/maven-snapshots/</url>
    <snapshots><enabled>true</enabled></snapshots>
  </repository>