@MelanieTU I did a few tests and indeed there is a strange problem when transferring data directly from SQLite to (local) Spark. If the string contains some special characters then there seems to be a problem, also if the string is being manipulated by a SQL/View Code (like adding a character).
Transfer via download to KNIME and if you exclude special cases like TIMESTAMPS (which is another matter in SQLite) then it does work.
@ScottF it seems there might be a problem with the implementation or the Spark version/driver. I don’t know if this would also happen in a ‘real’ spark environment. For the Local Big Data environment this is just annoying but I do not think it will hinder real production.
@MelanieTU if you must, the workaround would be to download the data to KNIME and then load it into Spark (or Hive).
