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.

Convert string to double java