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

Hive should escape fields terminator when use textfile format

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 2.1.1
    • Fix Version/s: None
    • Component/s: File Formats
    • Labels:
      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

            People

            • Assignee:
              ilpane Anoop S Nair
              Reporter:
              winston.chill Winston Churchill
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: