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

skip.header.line.count causes values to be skipped when performing insert values

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.0.0, 1.2.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Target Version/s:

      Description

      When inserting values in to tables with TBLPROPERTIES ("skip.header.line.count"="1") the first value listed is also skipped.

      create table test (row int, name string) TBLPROPERTIES ("skip.header.line.count"="1");
      load data local inpath '/root/data' into table test;
      insert into table test values (1, 'a'), (2, 'b'), (3, 'c');

      (1, 'a') isn't inserted into the table.

        Attachments

        1. data
          0.1 kB
          Wenbo Wang
        2. HIVE-10176.1.patch
          2 kB
          Vladyslav Pavlenko
        3. HIVE-10176.2.patch
          2 kB
          Vladyslav Pavlenko
        4. HIVE-10176.3.patch
          3 kB
          Vladyslav Pavlenko
        5. HIVE-10176.4.patch
          3 kB
          Vladyslav Pavlenko
        6. HIVE-10176.5.patch
          17 kB
          Vladyslav Pavlenko
        7. HIVE-10176.6.patch
          15 kB
          Vladyslav Pavlenko
        8. HIVE-10176.7.patch
          17 kB
          Vladyslav Pavlenko
        9. HIVE-10176.8.patch
          32 kB
          Vladyslav Pavlenko
        10. HIVE-10176.9.patch
          32 kB
          Vladyslav Pavlenko
        11. HIVE-10176.10.patch
          32 kB
          Vladyslav Pavlenko
        12. HIVE-10176.11.patch
          32 kB
          Vladyslav Pavlenko
        13. HIVE-10176.12.patch
          38 kB
          Vladyslav Pavlenko
        14. HIVE-10176.13.patch
          38 kB
          Vladyslav Pavlenko
        15. HIVE-10176.14.patch
          39 kB
          Vladyslav Pavlenko
        16. HIVE-10176.15.patch
          40 kB
          Ashutosh Chauhan
        17. HIVE-10176.16.patch
          41 kB
          Vladyslav Pavlenko

          Activity

            People

            • Assignee:
              lmephistol Vladyslav Pavlenko
              Reporter:
              wwenbow Wenbo Wang
            • Votes:
              4 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated: