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

Insert with custom separator not supported for non-local directory

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment