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

Allow other characters for LINES TERMINATED BY

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      LINES TERMINATED BY only supports newline '\n' right now.

      It would be nice to loosen this constraint and allow other characters.

      This limitation seems to be hardcoded here:
      https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java#L171

      The DDL Definition on the Hive Language manual shows this as a configurable property whereas it is not. This may lead to mileading assement of being able to choose a choice of field delimiter.

      Attachments

        1. HIVE-5999.patch
          19 kB
          Nemon Lou
        2. HIVE-5999.1.patch
          21 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
            mdominguez@cloudera.com Mariano Dominguez

            Dates

              Created:
              Updated:

              Slack

                Issue deployment