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

Add DATE, TIMESTAMP, DECIMAL, CHAR, VARCHAR types support in HCat

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

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.12.0
    • 0.13.0
    • HCatalog
    • None

    Description

      Hive 0.12 added support for new data types. Pig 0.12 added some as well. HCat should handle these as well. Also note that CHAR was added recently.

      Also allow user to specify a parameter in Pig like so HCatStorer('','', '-onOutOfRangeValue Throw') to control what happens when Pig's value is out of range for target Hive column. Valid values for the option are Throw and Null. Throw - make the runtime raise an exception, Null, which is the default, means NULL is written to target column and a message to that effect is emitted to the log. Only 1 message per column/data type is sent to the log.

      See attached HCat-Pig Type Mapping Hive 0.13.pdf for exact mappings.

      Attachments

        1. HIVE-5814.5.patch
          141 kB
          Eugene Koifman
        2. HIVE-5814.4.patch
          140 kB
          Eugene Koifman
        3. HIVE-5814.3.patch
          140 kB
          Eugene Koifman
        4. HCat-Pig Type Mapping Hive 0.13.pdf
          48 kB
          Eugene Koifman
        5. HIVE-5814.2.patch
          110 kB
          Eugene Koifman

        Issue Links

        Activity

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

          People

            ekoifman Eugene Koifman Assign to me
            ekoifman Eugene Koifman
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment