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

Impala Incorrectly Handles Newlines

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

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Not A Problem
    • Impala 1.1.1
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            theory_impala_af54 David E. Wheeler
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment