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

Insert with custom separator not supported for non-local directory

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.12.0, 1.0.0
    • 1.2.0
    • None
    • None

    Description

      https://issues.apache.org/jira/browse/HIVE-3682 is great but non local directory don't seem to be supported:

      insert overwrite directory '/tmp/test-02'
      row format delimited
      FIELDS TERMINATED BY ':'
      select description FROM sample_07
      
      Error while compiling statement: FAILED: ParseException line 2:0 cannot recognize input near 'row' 'format' 'delimited' in select clause
      

      This works (with 'local'):

      insert overwrite local directory '/tmp/test-02'
      row format delimited
      FIELDS TERMINATED BY ':'
      select code, description FROM sample_07
      

      Attachments

        1. HIVE-5672.1.patch
          14 kB
          Nemon Lou
        2. HIVE-5672.2.patch
          45 kB
          Nemon Lou
        3. HIVE-5672.3.patch
          14 kB
          Nemon Lou
        4. HIVE-5672.4.patch
          14 kB
          Nemon Lou
        5. HIVE-5672.5.patch.tar.gz
          9 kB
          Nemon Lou
        6. HIVE-5672.5.patch
          45 kB
          Nemon Lou
        7. HIVE-5672.6.patch.tar.gz
          9 kB
          Nemon Lou
        8. HIVE-5672.6.patch
          45 kB
          Nemon Lou
        9. HIVE-5672.7.patch.tar.gz
          9 kB
          Nemon Lou
        10. HIVE-5672.7.patch
          45 kB
          Nemon Lou
        11. HIVE-5672.8.patch.tar.gz
          9 kB
          Nemon Lou
        12. HIVE-5672.8.patch
          46 kB
          Nemon Lou

        Issue Links

          Activity

            People

              nemon Nemon Lou
              romainr Romain Rigaux
              Votes:
              5 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: