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

SELECT TRANSFORM / MAP / REDUCE to support optional ROW FORMAT

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • Serializers/Deserializers
    • None

    Description

      We should allow TRANSFORM / MAP/ REDUCE to accept optional ROW FORMAT:

      SELECT TRANSFORM(a, b, c)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
USING 'mypython.py'
AS (d STRING, e INT, f DOUBLE)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'

      Also, we should allow optional type information in the "AS" clause.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. HIVE-411 Interaction of AS clause (from a TRANSFORM-USING-AS) with non-column formatted output

          • Major - Major loss of function.
          • Open
          duplicates

          New Feature - A new feature of the product, which has yet to be developed. HIVE-708 Add TypedBytes SerDe for transform

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-743 let user specify serde for custom scripts

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-634 ctrl-A is the only output delimiter used, regardless of the Hive table structure

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-51 Generate and accept JSON as the input-output format from mappers and reducers

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              zshao Zheng Shao
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: