Source
Python and Java support for serverless tasks
Serverless tasks can invoke the following object types and functions: user - defined functions (UDFs) and stored procedures written in Python, Java, and Scala.
JDBC driver with -Dhttp.nonProxyHosts=* set throws java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
ISSUE: When using the JDBC driver's diagnostics feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1, if the -Dhttp.nonProxyHosts=* JVM argument is set, the following exception can occur on some Java versions: java.lang.RuntimeException: java.lang.St…
JDBC driver throws javax.naming.CommunicationException: DNS error (Root exception: java.net.SocketTimeoutException)
ISSUE: The following exception occurs on macOS (aarch64) when using the JDBC driver’s diagnostic feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1: javax.naming.CommunicationException: DNS error [Root exception is java.net.SocketTimeoutException];…
JDBC Driver Compatibility Issue With JDK 16 and Later: Exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager
CAUSE: The failure is directly caused by one of the JDBC driver's dependencies, Apache Arrow, when attempting to use reflection in order to access a private member of the java.
Java UDF is not keeping the timezone offset information when using Timestamp data type
ISSUE: When Timestamp data is being used in a Java UDF, the timezone information (offset) will be dropped, as can be seen from the following example:Example: CREATE OR REPLACE FUNCTION "JAVA_REFLECT_TIMESTAMP_TZ"("I" TIMESTAMP_TZ) RETURNS…
Java UDF handler examples
The following statements create and call an in - line Java UDF. This code returns the VARCHAR passed to it. This function is declared with the optional CALLED ON NULL INPUT clause to indicate that the function is called even if the value of…