Unable to run query- Insert into with 'Nan' value in SQL Editor. Getting the error.

NeerajSharma
Databricks Partner

Unable to run query- Insert into with 'Nan' value in SQL Editor.

Query :-

Insert into ABC with values('xyz',123,Nan);

Error :-

org.apache.spark.sql.execution.datasources.v2.DataSourceV2Relation cannot be cast to org.apache.spark.sql.execution.datasources.LogicalRelation