Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: UDF
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: