Error parsing date from SQLite with PySpark
Solution 1:
Finally the solution that worked is to use the option customSchema to read the fields as String.
df = spark.read.format('jdbc') \
.options(driver='org.sqlite.JDBC', dbtable='table_name',
url='jdbc:sqlite:/path/to/database.db')\
.option("customSchema", "column1 STRING, column2 STRING")\
.load()