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

Create md5 UDF

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.3.0, 2.0.0
    • UDF
    • None

    Description

      MD5(str)
      Calculates an MD5 128-bit checksum for the string. The value is returned as a string of 32 hex digits, or NULL if the argument was NULL. The return value can, for example, be used as a hash key.
      Example:

      SELECT MD5('udf_md5');
      'ce62ef0d2d27dc37b6d488b92f4b24fd'
      

      online md5 generator: http://www.md5.cz/

      MySQL has md5 function: https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_md5
      PostgreSQL also has md5 function: http://www.postgresql.org/docs/9.1/static/functions-string.html

      Attachments

        1. HIVE-10485.1.patch
          9 kB
          Alexander Pivovarov
        2. HIVE-10485.2.patch
          10 kB
          Alexander Pivovarov
        3. HIVE-10485.3.patch
          10 kB
          Alexander Pivovarov

        Issue Links

          Activity

            People

              apivovarov Alexander Pivovarov
              apivovarov Alexander Pivovarov
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: