Databricks Community

ClintHall

In unity catalog, I have a connection to a SQL Server database. When I try to filter by a datetime column using a datetime with fractional seconds, Databricks gives me this error:Job aborted due to stage failure: com.microsoft.sqlserver.jdbc.SQLServe...

ClintHall

Thanks, @Isi. Very helpful. It would be nice if Lakehouse federation would do this for us (the same way that it knows SQL Server uses ISNULL where Spark SQl uses NVL). Is there a way to bring it the dev's attention?

Databricks Community

User Stats

User Activity

Error filtering by datetime Lakehouse Federated SQL Server table

Re: Error filtering by datetime Lakehouse Federated SQL Server table