search

snowflakedb / snowflake-jdbc

Snowflake JDBC Driver
Apache License 2.0
173 stars 163 forks source link

Driver failing when fetching metadata of table with a Geometry column #1195

Closed louisnow closed 1 year ago

louisnow commented 1 year ago

When running the JDBC metaData.getColumns() function we face the following error Error stacktrace

java.lang.IllegalArgumentException: No enum constant net.snowflake.client.jdbc.SnowflakeType.GEOMETRY
        at java.base/java.lang.Enum.valueOf(Unknown Source)
        at net.snowflake.client.jdbc.SnowflakeType.valueOf(SnowflakeType.java:18)
        at net.snowflake.client.jdbc.SnowflakeType.fromString(SnowflakeType.java:46)
        at net.snowflake.client.jdbc.SnowflakeUtil.extractColumnMetadata(SnowflakeUtil.java:144)
        at net.snowflake.client.jdbc.SnowflakeDatabaseMetaData$4.next(SnowflakeDatabaseMetaData.java:1717)

I can see it isn't implemented yet https://github.com/snowflakedb/snowflake-jdbc/blob/b017c93f8ae28708e57fedb4648a53260772d121/src/main/java/net/snowflake/client/jdbc/SnowflakeType.java#L18

Is this in the roadmap? Docs for Geometry type

oleg-mirzaev commented 1 year ago

i have also encountered this issue

adarsh0048 commented 1 year ago

Please let us know if and when this would get resolved. Snowflake has Geometry data type but doesn't have support in the latest drivers ?

sfc-gh-anugupta commented 1 year ago

The fix is included in February release 2.25.9