If a LazySimpleSerDe table is created using ISO 8859-1 encoding, query results for a string column are incorrect for any row that was preceded by a row containing a longer string.
Example steps to reproduce:
1. Create a table using ISO 8859-1 encoding:
2. Copy an ISO-8859-1 encoded text file into the appropriate warehouse folder in HDFS. I'll attach an example file containing the following text:
3. Execute SELECT * FROM person_lat1
Result - The following output appears: