> SELECT any_value(col, true) FROM VALUES (NULL), (5), (20) AS tab(col) Īpprox_count_distinct(expr) - Returns the estimated cardinality by HyperLogLog++. > SELECT any_value(col) FROM VALUES (NULL), (5), (20) AS tab(col) If isIgnoreNull is true, returns only non-null values.Įxamples: > SELECT any_value(col) FROM VALUES (10), (5), (20) AS tab(col) > SELECT any(col) FROM VALUES (false), (false), (NULL) AS tab(col) Īny_value(expr) - Returns some value of expr for a group of rows. > SELECT any(col) FROM VALUES (NULL), (true), (false) AS tab(col) > SELECT aggregate(array(1, 2, 3), 0, (acc, x) -> acc + x, acc -> acc * 10) Īny(expr) - Returns true if at least one value of expr is true.Įxamples: > SELECT any(col) FROM VALUES (true), (false), (false) AS tab(col) Into the final result by applying a finish function.Įxamples: > SELECT aggregate(array(1, 2, 3), 0, (acc, x) -> acc + x) > SELECT base64(aes_encrypt('Spark SQL', '1234567890abcdef', 'ECB', 'PKCS')) Īggregate(expr, start, merge, finish) - Applies a binary operator to an initial state and allĮlements in the array, and reduces this to a single state. key - The passphrase to use to encrypt the data.> SELECT aes_decrypt(unbase64('3lmwu+Mw0H3fi5NDvcu9lg='), '1234567890abcdef', 'ECB', 'PKCS') Īes_encrypt(expr, key]) - Returns an encrypted value of expr using AES in given mode with the specified padding. padding - Specifies how to pad messages whose length is not a multiple of the block size.mode - Specifies which block cipher mode should be used to decrypt messages.key - The passphrase to use to decrypt the data.Supported combinations of ( mode, padding) are ('ECB', 'PKCS') and ('GCM', 'NONE'). Key lengths of 16, 24 and 32 bits are supported. arc cosine) of expr, as if computed byĪcosh(expr) - Returns inverse hyperbolic cosine of expr.Īdd_months(start_date, num_months) - Returns the date that is num_months after start_date.Īes_decrypt(expr, key]) - Returns a decrypted value of expr using AES in mode with padding. > SELECT abs(INTERVAL -'1-1' YEAR TO MONTH) Īcos(expr) - Returns the inverse cosine (a.k.a. > SELECT to_date(' 04:17:52') >= to_date(' 04:17:52') Įxpr1 ^ expr2 - Returns the result of bitwise exclusive OR of expr1 and expr2.Ībs(expr) - Returns the absolute value of the numeric or interval value. > SELECT to_date(' 04:17:52') > to_date(' 04:17:52') Įxpr1 >= expr2 - Returns true if expr1 is greater than or equal to expr2. For complex types such array/struct, the data types of fields must For example, map type is not orderable, so it Map type is not supported.įor complex types such array/struct, the data types of fields must be orderable.Įxpr1 = expr2 - Returns true if expr1 equals expr2, or false otherwise.Įxpr1 > expr2 - Returns true if expr1 is greater than expr2.Īnd must be a type that can be ordered. expr1, expr2 - the two expressions must be same type or can be casted to a common type,Īnd must be a type that can be used in equality comparison.SELECT 1 SELECT 1.1 SELECT to_date(' 04:17:52') SELECT to_date(' 04:17:52') SELECT 1 SELECT 2 SELECT 1.0 SELECT to_date(' 04:17:52') SELECT to_date(' 04:17:52') SELECT 1 Įxpr1 expr2 - Returns same result as the EQUAL(=) operator for non-null operands,īut returns true if both are null, false if one of the them is null. It always performs floating point division. The data types of fields must be orderable.Įxpr1 % expr2 - Returns the remainder after expr1/ expr2.Įxpr1 & expr2 - Returns the result of bitwise AND of expr1 and expr2.Įxpr1 / expr2 - Returns expr1/ expr2. expr1, expr2 - the two expressions must be same type or can be casted toĪ common type, and must be a type that can be used in equality comparison.Expr1 != expr2 - Returns true if expr1 is not equal to expr2, or false otherwise.
0 Comments
Leave a Reply. |