Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13554 [Umbrella] SQL:2011 compliance
  3. HIVE-13555

Add nullif udf

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.3.0
    • UDF
    • None

    Description

      nullif(exp1, exp2) is shorthand for: case when exp1 = exp2 then null else exp1

      Attachments

        1. HIVE-13555.2.patch
          18 kB
          Zoltan Haindrich
        2. HIVE-13555.2.patch
          18 kB
          Zoltan Haindrich
        3. HIVE-13555.1.patch
          16 kB
          Zoltan Haindrich

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5469 support nullif

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

          Web Link reviewboard

          Activity

            People

              kgyrtkirk Zoltan Haindrich
              ashutoshc Ashutosh Chauhan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: