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

Support CASE statement using GenericUDF

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.4.0
    • 0.4.0
    • Query Processor
    • None
    • Reviewed

    Description

      See http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html for details.

      Syntax:

      CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [<ELSE result] END
CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END

      Attachments

        1. HIVE-164.4.patch
          189 kB
          Zheng Shao
        2. HIVE-164.5.patch
          201 kB
          Zheng Shao
        3. HIVE-164.6.code-only.patch
          122 kB
          Zheng Shao
        4. HIVE-164.6.patch
          206 kB
          Zheng Shao
        5. HIVE-164.7.code-only.patch
          119 kB
          Zheng Shao
        6. HIVE-164.7.patch
          199 kB
          Zheng Shao
        7. HIVE-164.8.patch
          219 kB
          Zheng Shao

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. HIVE-45 Hive: GenericUDF and support of complex object

          • Major - Major loss of function.
          • Closed
          incorporates

          New Feature - A new feature of the product, which has yet to be developed. HIVE-258 Support IF(test, valueTrue, valueFalseOrNull)

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-441 Convert field, index, AND, OR operators to GenericUDF

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-450 CASE/WHEN to support implicit type conversion

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-405 Cleanup operator initialization

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: