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

Hive should escape fields terminator when use textfile format

    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

          People

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

            Dates

              Created:
              Updated: