Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-658

Impala Incorrectly Handles Newlines

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Not A Problem
    • Affects Version/s: Impala 1.1.1
    • Fix Version/s: None
    • Component/s: Backend

      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.

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              theory_impala_af54 David E. Wheeler

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment