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
          45 kB
          Nemon Lou
        6. HIVE-5672.5.patch.tar.gz
          9 kB
          Nemon Lou
        7. HIVE-5672.6.patch
          45 kB
          Nemon Lou
        8. HIVE-5672.6.patch.tar.gz
          9 kB
          Nemon Lou
        9. HIVE-5672.7.patch
          45 kB
          Nemon Lou
        10. HIVE-5672.7.patch.tar.gz
          9 kB
          Nemon Lou
        11. HIVE-5672.8.patch
          46 kB
          Nemon Lou
        12. HIVE-5672.8.patch.tar.gz
          9 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