[
https://issues.apache.org/jira/browse/HIVE-11112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Damien Carol updated HIVE-11112:
--------------------------------
Description:
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:
{code:sql}
CREATE TABLE person_lat1 (name STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH
SERDEPROPERTIES ('serialization.encoding'='ISO8859_1');
{code}
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:
{noformat}
Müller,Thomas
Jørgensen,Jørgen
Peña,Andrés
Nåm,Fæk
{noformat}
3. Execute {{SELECT * FROM person_lat1}}
Result - The following output appears:
{noformat}
+-------------------+--+
| person_lat1.name |
+-------------------+--+
| Müller,Thomas |
| Jørgensen,Jørgen |
| Peña,Andrésørgen |
| Nåm,Fækdrésørgen |
+-------------------+--+
{noformat}
was:
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:
CREATE TABLE person_lat1 (name STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH
SERDEPROPERTIES ('serialization.encoding'='ISO8859_1');
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:
Müller,Thomas
Jørgensen,Jørgen
Peña,Andrés
Nåm,Fæk
3. Execute SELECT * FROM person_lat1
Result - The following output appears:
+-------------------+--+
| person_lat1.name |
+-------------------+--+
| Müller,Thomas |
| Jørgensen,Jørgen |
| Peña,Andrésørgen |
| Nåm,Fækdrésørgen |
+-------------------+--+
> ISO-8859-1 text output has fragments of previous longer rows appended
> ---------------------------------------------------------------------
>
> Key: HIVE-11112
> URL: https://issues.apache.org/jira/browse/HIVE-11112
> Project: Hive
> Issue Type: Bug
> Components: Serializers/Deserializers
> Affects Versions: 1.2.0
> Reporter: Yongzhi Chen
> Assignee: Yongzhi Chen
> Attachments: HIVE-11112.1.patch
>
>
> 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:
> {code:sql}
> CREATE TABLE person_lat1 (name STRING)
> ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH
> SERDEPROPERTIES ('serialization.encoding'='ISO8859_1');
> {code}
> 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:
> {noformat}
> Müller,Thomas
> Jørgensen,Jørgen
> Peña,Andrés
> Nåm,Fæk
> {noformat}
> 3. Execute {{SELECT * FROM person_lat1}}
> Result - The following output appears:
> {noformat}
> +-------------------+--+
> | person_lat1.name |
> +-------------------+--+
> | Müller,Thomas |
> | Jørgensen,Jørgen |
> | Peña,Andrésørgen |
> | Nåm,Fækdrésørgen |
> +-------------------+--+
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
