Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-16083

Hive should escape fields terminator when use textfile format

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: In Progress
    • Trivial
    • Resolution: Unresolved
    • 2.1.1
    • None
    • File Formats
    • None

    Description

      Create table with comon as fields terminator and insert data contains comon:

      create table test_1(id int,name string) row format delimited fields terminated by ',' stored as textfile;
      insert into table test_1 values (1,'a,b,c');
      
      select * from test_1;
      +------------+--------------+--+
      | test_1.id  | test_1.name  |
      +------------+--------------+--+
      | 1          | a            |
      +------------+--------------+--+
      4 rows selected (0.363 seconds)
      

      May need to escape the fields terminator ?

      Attachments

        Activity

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

          People

            ilpane Anoop S Nair Assign to me
            winston.chill Winston Churchill

            Dates

              Created:
              Updated:

              Slack

                Issue deployment