[IMPALA-2251] Impala allows creation of text tables with same row and field delimiter

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2
• Fix Version/s: Impala 2.3.0
• Assignee: Tim Armstrong
• Reporter: Tim Armstrong
• Created: 25/Aug/15 23:43
• Updated: 15/Nov/15 20:15
• Resolved: 26/Aug/15 16:06

Description

It is possible to create text tables with nonsensical formats such as identical row and column delimiters. This is less obvious when using the default for one delimiter and non-default for another. This should be straightforward to detect and report to the user.

A straightforward repro is:

create table if not exists broken_table (c1 string,c2 string) row format delimited lines terminated by '^A' stored as textfile;
truncate broken_table;
insert into broken_table values ("a", "b");
select * from broken_table;

Where ^A is ascii character 1.

This results in:

Query: select * from broken_table
+----+------+
| c1 | c2   |
+----+------+
| a  | NULL |
| b  | NULL |
+----+------+