sql end point and jdbc driver

190857
New Contributor II

When we try and connect to a sql warehouse endpoint with the databricks jdbc driver our query is failing if we use first_value().  We've rewritten the query to use limit 1, but we would like to understand if this is a gap in the simba/databricks driver or in the sql warehouse endpoint/databricks.

 

190857
New Contributor II

A sample error message when using first_value() is:

An error occurred while calling o132.csv. [Databricks][JDBC](10140) Error converting value to BigDecimal.