Hive
  1. Hive
  2. HIVE-669

SELECT TRANSFORM / MAP / REDUCE to support optional ROW FORMAT

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      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.

        Issue Links

          Activity

          Zheng Shao created issue -
          Zheng Shao made changes -
          Field Original Value New Value
          Link This issue relates to HIVE-51 [ HIVE-51 ]
          Zheng Shao made changes -
          Link This issue is blocked by HIVE-411 [ HIVE-411 ]
          Zheng Shao made changes -
          Link This issue is blocked by HIVE-411 [ HIVE-411 ]
          Zheng Shao made changes -
          Link This issue blocks HIVE-411 [ HIVE-411 ]
          Zheng Shao made changes -
          Link This issue is related to HIVE-634 [ HIVE-634 ]
          Zheng Shao made changes -
          Link This issue duplicates HIVE-708 [ HIVE-708 ]
          Zheng Shao made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Zheng Shao made changes -
          Link This issue duplicates HIVE-743 [ HIVE-743 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Zheng Shao
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development