How can I create a Table from a CSV file with first column with data in dictionary format (JSON like)?
I have a csv file with the first column containing data in dictionary form (keys: value). [see below] I tried to create a table by uploading the csv file directly to databricks but the file can't be read. Is there a way for me to flatten or conver...
- 15853 Views
- 1 replies
- 0 kudos
Latest Reply
This is apparently a known issue, databricks has their own csv format handler which can handle this https://github.com/databricks/spark-csv SQL API CSV data source for Spark can infer data types: CREATE TABLE cars USING com.databricks.spark.csv OP...
- 0 kudos