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

Insert with custom separator not supported for non-local directory

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.12.0, 1.0.0
    • Fix Version/s: 1.2.0
    • Component/s: None
    • Labels:
      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.8.patch
          46 kB
          Nemon Lou
        2. HIVE-5672.8.patch.tar.gz
          9 kB
          Nemon Lou
        3. HIVE-5672.7.patch
          45 kB
          Nemon Lou
        4. HIVE-5672.7.patch.tar.gz
          9 kB
          Nemon Lou
        5. HIVE-5672.6.patch
          45 kB
          Nemon Lou
        6. HIVE-5672.6.patch.tar.gz
          9 kB
          Nemon Lou
        7. HIVE-5672.5.patch
          45 kB
          Nemon Lou
        8. HIVE-5672.5.patch.tar.gz
          9 kB
          Nemon Lou
        9. HIVE-5672.4.patch
          14 kB
          Nemon Lou
        10. HIVE-5672.3.patch
          14 kB
          Nemon Lou
        11. HIVE-5672.2.patch
          45 kB
          Nemon Lou
        12. HIVE-5672.1.patch
          14 kB
          Nemon Lou

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: