Databricks Community

giuseppe_esq · 2 weeks ago

Hi all,

When I try to execute the script (as per the screenshot below), in a Notebook cell, I get an error message. I am using Databricks Free Edition, and am not sure if the error relates to the compute cluster that I am using?

Any guidance would be greatly appreciated.

Thanks

Giuseppe

nayan_wylde · 2 weeks ago

@giuseppe_esq

Can you please copy the entire error message and paste here.

giuseppe_esq · 2 weeks ago

Yep, as requested.

Thanks

brycejune · 2 weeks ago

Free Edition clusters often come with restricted resources and certain features may not be supported. You may want to review your cluster settings, check compatibility with your script, and consider whether upgrading to a paid tier is necessary for your use case.

Sidhant07 · 2 weeks ago

Hi @giuseppe_esq ,

Can you please share the DBR version, cluster configurations and log4 file containing the error stact trace to further review?

giuseppe_esq · 2 weeks ago

Hi,

Thanks for your reply.

Apologies if I am sending the incorrect information. I am in the process of learning databricks, and adding content to my personal blog.

DBR Version

Cluster Configurations

From the Compute menu, this is the only cluster available in the Databricks Free Edition:

From the Workspace Notebook, I also tried to attach the General Compute option, though this didn't resolve the issue either:

Log4j File

I have attached the Log4j File, for the time I executed the following query, that errored:

## Incrementally (or stream) data using Auto Loader
(spark.
readStream
.format("cloudFiles")
.option("cloudFiles.format", "csv")
.option("header", "true")
.option("sep", ",")
.option("inferSchema", "true")
.option("cloudFiles.schemaLocation", f"{checkpoint_file_location}")
.load("/Volumes/workspace/python_auto_loader/csv_staging")
.writeStream
.option("checkpointLocation", f"{checkpoint_file_location}")
.trigger(once=True)
.toTable("workspace.python_auto_loader.python_csv_autoloader")
)

If you require any additional information, please message me again.

Thank you for your help.

Giuseppe