Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-10074

Hash Functions in BeamSQL

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: P2
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Not applicable
    • Component/s: dsl-sql
    • Labels:
      None

      Description

      I would like to propose hash functions (implemented as UDFs):
      Optionally we can also add for below functions variants which return hex string instead of bytes.

      1. MD5
        Calculates an MD5 128-bit checksum of string or bytes and returns it as a bytes
      SELECT MD5("Some String") as md5;
      
      1. SHA1
        Calculates a SHA-1 hash value of string or bytes and returns it as a bytes.
      SELECT SHA1("Some String") as sha1;
      
      1. SHA256
        Calculates a SHA-256 hash value of string or bytes and returns it as a bytes
      SELECT SHA256("Some String") as sha256;
      
      1. SHA512
        Calculates a SHA-512 hash value of string or bytes and returns it as a bytes.
      SELECT SHA512("Some String") as sha512;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                darshanjani Darshan Jani
                Reporter:
                darshanjani Darshan Jani
              • 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 - 40m
                  40m