Package org.apache.drill.exec.udfs
package org.apache.drill.exec.udfs
-
ClassDescriptionThis function exists to help the user understand the inner schemata of maps It is NOT recursive (yet).AES_DECRYPT() decrypts the encrypted string crypt_str using the key string key_str and returns the original cleartext string.aes_encrypt()/ aes_decrypt(): implement encryption and decryption of data using the official AES (Advanced Encryption Standard) algorithm, previously known as "Rijndael." AES_ENCRYPT() encrypts the string str using the key string key_str and returns a binary string containing the encrypted output.This class returns the md2 digest of a given input string.This function returns the MD5 digest of a given input string.sha(
) / sha1( ): Calculates an SHA-1 160-bit checksum for the string, as described in RFC 3174 (Secure Hash Algorithm). sha2() / sha256( ): Calculates an SHA-2 256-bit checksum for the string. This function returns the SHA384 digest of a given input string.This function returns the SHA512 digest of a given input string.Specifies the time grouping to be used with the nearest date functionThis function takes two arguments, an input date object, and an interval and returns the previous date that is the first date in that period.This function takes three arguments, an input date string, an input date format string, and an interval and returns the previous date that is the first date in that period.This function retunrs the number of IP addresses in the input CIDR block.This function returns the broadcast address of a given CIDR block.This function gets the numerically highest IP address in an input CIDR block.This function converts an IPv4 address into a BigInt.This function converts a BigInt IPv4 into dotted decimal notation.This function takes two arguments, an input IPv4 and a CIDR, and returns true if the IP is in the given CIDR blockThis function returns true if a given IPv4 address is private, false if not.Returns true if the input string is a valid IP addressReturns true if the input string is a valid IPv4 addressReturns true if the input string is a valid IP addressThis function gets the numerically lowest IP address in an input CIDR block.This function gets the netmask of the input CIDR block.This function decodes URL strings.This function encodes URL strings.The Caverphone function is a phonetic matching function.The Caverphone function is a phonetic matching function.Encodes a string into a Cologne Phonetic value.Encodes a string into a Daitch-Mokotoff Soundex value.Implements the Double Metaphone phonetic algorithm (https://en.wikipedia.org/wiki/Metaphone), and calculates a given string's Double Metaphone value.Match Rating Approach Phonetic Algorithm Developed by Western Airlines in 1977.Implements the Metaphone phonetic algorithm (https://en.wikipedia.org/wiki/Metaphone), and calculates a given string's Metaphone value.The New York State Identification and Intelligence System Phonetic Code, commonly known as NYSIIS, is a phonetic algorithm devised in 1970 as part of the New York State Identification and Intelligence System (now a part of the New York State Division of Criminal Justice Services).Encodes a string into a Refined Soundex value.Encodes a string into a Soundex value.This function calculates the cosine distance between two strings.This function calculates the cosine distance between two strings.The hamming distance between two strings of equal length is the number of positions at which the corresponding symbols are different.Measures the Jaccard distance of two sets of character sequence.A similarity algorithm indicating the percentage of matched characters between two character sequences.An algorithm for measuring the difference between two character sequences.The Longest common subsequence algorithm returns the length of the longest subsequence that two strings have in common.This function calculates the Shannon Entropy of a given string of text, normed for the string length.Punctuation pattern is useful for comparing log entries.This function calculates the Shannon Entropy of a given string of text.This function is used for facilitating time series analysis by creating buckets of time intervals.This function is used for facilitating time series analysis by creating buckets of time intervals.This function is used for facilitating time series analysis by creating buckets of time intervals.This function is used for facilitating time series analysis by creating buckets of time intervals.