Databricks Community

AsfandQ · 06-18-2022

Hello,I am trying to write Delta files for some CSV data. When I docsv_dataframe.write.format("delta").save("/path/to/table.delta")I get: AnalysisException: Found invalid character(s) among " ,;{}()\n\t=" in the column names of yourschema.Having look...

AsfandQ · 06-18-2022

Thanks that worked. I can now query it with SQL. Can you explain why is it that I have to do saveAsTable with path set in an option? I thought calling `save()` was the way to do this kind of operation.

AsfandQ · 06-18-2022

Thanks @Hemant Kumar, I tried exactly what you said, the below is a copy/paste (with sanitized names):table_bronze.write.format("delta").option("delta.columnMapping.mode", "name").save("/path/to/table.delta")I got the same error. Is there a bug?

Databricks Community

User Stats

User Activity

Delta tables: Cannot set default column mapping mode to "name" in Python for delta tables

Re: Delta tables: Cannot set default column mapping mode to "name" in Python for delta tables

Re: Delta tables: Cannot set default column mapping mode to "name" in Python for delta tables