SNOW-1844765: java.lang.IllegalArgumentException: No enum constant java.sql.JDBCType.varchar when writing an ARRAY value

[jneira-stratio]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of JDBC driver are you using?

Version 3.20.0

2. What operating system and processor architecture are you using?

N/A, but linux

3. What version of Java are you using?

openjdk version "1.8.0_432"
OpenJDK Runtime Environment (build 1.8.0_432-8u432-gaus1-0ubuntu220.04-ga)
OpenJDK 64-Bit Server VM (build 25.432-bga, mixed mode)

4. What did you do?

• Run a test which uses spark to write in a column with type ARRAY an array of one element of type VARCHAR (or any other inner type)

5. What did you expect to see?

• The write is succesful even if the method is called with a lower case type name

  What should have happened and what happened instead?

• The code throws an error

java.lang.IllegalArgumentException: No enum constant java.sql.JDBCType.varchar
	at java.lang.Enum.valueOf(Enum.java:238)
	at java.sql.JDBCType.valueOf(JDBCType.java:34)
	at net.snowflake.client.jdbc.SnowflakeConnectionV1.createArrayOf(SnowflakeConnectionV1.java:725)
	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.$anonfun$makeSetter$15(JdbcUtils.scala:589)
	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.$anonfun$makeSetter$15$adapted(JdbcUtils.scala:586)

6. Can you set logging to DEBUG and collect the logs?

   https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors

   Before sharing any information, please be sure to review the log and remove any sensitive
   information.

I think the stacktrace is informative enough and the cause is clear:

• spark <= 3 makes the type lower case 🤷 : https://github.com/apache/spark/blob/4a418a448eab6e1007927db92ecacad6594397c8/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JdbcUtils.scala#L582-L583
• then the driver tries to get the JDBCType enum value using the string:

  snowflake-jdbc/src/main/java/net/snowflake/client/jdbc/SnowflakeConnectionV1.java

  Line 725 in 21e98c7

  return new SfSqlArray(JDBCType.valueOf(typeName).getVendorTypeNumber(), elements);

• and, surprise, there is no varchar enum value but VARCHAR

Would be it possible to make a defensive toUpperCase call before getting the JDBCType and add support for those spark versions (the current one is 3.5)?

Many thanks in advance

[sfc-gh-dszmolka]

hi - thanks for reporting this and also the analysis. we'll take a look.

[sfc-gh-dszmolka]

addressed in #2010 - under review
edit: today it was already merged :) so now it's waiting for release.

[jneira-stratio]

thanks a lot!