Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26729 Add new UDFs to process Array type of data
  3. HIVE-26754

Implement array_distinct UDF to return an array after removing duplicates in it

    XMLWordPrintableJSON

Details

    Description

      array_distinct(array(obj1, obj2,...)) - The function returns an array of the same type as the input argument where all duplicate values have been removed.

      Example:
      > SELECT array_distinct(array('b', 'd', 'd', 'a')) FROM src LIMIT 1;
      ['a', 'b', 'c']

      Attachments

        Issue Links

          Activity

            People

              tarak271 Taraka Rama Rao Lethavadla
              tarak271 Taraka Rama Rao Lethavadla
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5.5h
                  5.5h