nagarajudevu
New Contributor II

i am getting the following error when working in Databricks free edition newly logged in

the code i wrote :

from pyspark.sql.functions import *
data = "workspace.default.asl.csv"
df = spark.read.format("csv").option("header","true").option("inferSchemaccc","true").option("delimiter", ',').load()
res = df
res.sh
 
when i ran the above code i am getting below error:
[UNABLE_TO_INFER_SCHEMA] Unable to infer schema for CSV. It must be specified manually. SQLSTATE: 42KD9
 
please give a solution to slove this