Create New Table, Infer Schema gives error: Invalid column type {colSchemaType}

lauracoursera
New Contributor II

I'm doing a the course 'Distributed Computing with Spark SQL' on Coursera, and need to create a table by uploading a csv file. That seems to work at first, but as soon as I check the box for 'Infer schema' for the preview table, I get the following message:

The following errors prevented the table from rendering:

  • Invalid column type {colSchemaType} at column Call_Date
  • Invalid column type {colSchemaType} at column Watch_Date

 

The csv file I used, can be found by following this link: https://s3-us-west-2.amazonaws.com/davis-dsv1071/data/fire-calls/fire-calls-truncated-comma-no-space...

I would appreciate it very much if you can help me!