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

Hash Functions in BeamSQL

Details

    • New Feature
    • Status: Resolved
    • P2
    • Resolution: Fixed
    • None
    • 2.28.0
    • dsl-sql
    • 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

              darshanjani Darshan Jani
              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