[IMPALA-658] Impala Incorrectly Handles Newlines

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: Impala 1.1.1
• Component/s: Backend
• Labels: correctness downgraded text
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: David E. Wheeler
• Created: 07/Nov/13 06:17
• Updated: 31/Oct/18 17:59
• Resolved: 13/Jun/17 15:23

Description

Impala incorrectly stores a string value with newlines as multiple rows, rather than a single row with newlines:

[example.com:21000] > create table try (text string);
Query: create table try (text string)
[example.com:21000] > insert into try values ('foo
                    > bar
                    > baz');
Query: insert into try values ('foo
bar
baz')
Inserted 1 rows in 2.46s
[example.com:21000] > select * from try;
Query: select * from try
Query finished, fetching results ...
+------+
| text |
+------+
| foo  |
| bar  |
| baz  |
+------+
Returned 3 row(s) in 0.42s

As you can see, it thinks it inserted one row, but when you select from the table, it returns three rows. I had a look at the text file generated for this table, and it looks like this:

foo
bar
baz

So I think newlines are not properly escaped for storage in the text file.

Issue Links

• is duplicated by: IMPALA-1184 impala-shell converts newlines to spaces in multi-line literals