(CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (%1 * %1) (%1 * %1) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE 0 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE 0 END) FLOOR(TIMESTAMPADD(DAY, %1, DATE '1900-01-01') TO DAY) CAST(%1 AS DATE) CAST(%1 AS DATE) FLOOR(TIMESTAMPADD(DAY, %1, TIMESTAMP '1900-01-01 00:00:00') TO DAY) CAST(%1 AS TIMESTAMP) CAST(%1 AS TIMESTAMP) (CASE WHEN %1 THEN 1.0 WHEN NOT %1 THEN 0.0 ELSE NULL END) CAST(%1 AS FLOAT) CAST(%1 AS FLOAT) CAST(%1 AS FLOAT) (CASE WHEN %1 THEN 1 WHEN NOT %1 THEN 0 ELSE NULL END) CAST(%1 AS BIGINT) CAST(%1 AS BIGINT) CAST(%1 AS BIGINT) (CASE WHEN %1 THEN '1' WHEN NOT %1 THEN '0' ELSE NULL END) CAST(%1 AS VARCHAR) CAST(%1 AS VARCHAR) CAST(%1 AS VARCHAR) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) (CASE WHEN %1 IS NOT NULL THEN %1 ELSE %2 END) ((%1 AND %2) OR ((NOT %1) AND %3)) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE NULL END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE NULL END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE NULL END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE NULL END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE NULL END) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) (%1 IS NULL) (%1 IS NULL) (%1 IS NULL) (%1 IS NULL) AVG(%1) %1 AVG(CAST(%1 AS DOUBLE)) %1 COUNT(%1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(%1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(%1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(%1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 SUM(%1) %1 SUM(%1) %1 (NOT %1) (%1 AND NOT %2 OR NOT %1 AND %2) (%1 <> %2) (%1 <> %2) (%1 <> %2) MOD(%1, %2) MOD(%1, %2) (%1 AND %2) (%1 * %2) (%1 * %2) (%1 + %2) (%1 + %2) (%1 || %2) TIMESTAMPADD(SECOND, CAST((%2 * 86400) AS BIGINT), %1) TIMESTAMPADD(DAY, %2, %1) (0 - %1) (%1 - %2) (0 - %1) (%1 - %2) TIMESTAMPADD(SECOND, CAST((%2 * -86400) AS BIGINT), %1) TIMESTAMPADD(DAY, %2 * -1, %1) TIMESTAMPDIFF(DAY, %2, %1) (%1 / %2) (%1 < %2) (%1 < %2) (%1 < %2) (%1 <= %2) (%1 <= %2) (%1 <= %2) (%1 = %2) (%1 = %2) (%1 = %2) (%1 = %2) (%1 > %2) (%1 > %2) (%1 > %2) (%1 >= %2) (%1 >= %2) (%1 >= %2) (%1 OR %2) (POSITION(%2 IN %1) > 0) POSITION(%2 IN %1 FROM (CHAR_LENGTH(%1) - CHAR_LENGTH(%2) + 1)) = (CHAR_LENGTH(%1) - CHAR_LENGTH(%2) + 1) POSITION(%2 IN %1) POSITION(%2 IN %1 FROM %3) POSITION(%2 IN %1 FROM CAST((%3 - MOD(%3, 1)) AS BIGINT)) LEFT(%1, %2) LEFT(%1, CAST((%2 - MOD(%2, 1)) AS BIGINT)) CHAR_LENGTH(%1) LOWER(%1) SUBSTRING(%1, %2) SUBSTRING(%1, CAST((%2 - MOD(%2, 1)) AS BIGINT)) SUBSTRING(%1, %2, %3) SUBSTRING( %1, CAST((%2 - MOD(%2, 1)) AS BIGINT), CAST((%3 - MOD(%3, 1)) AS BIGINT)) RIGHT(%1, %2) RIGHT(%1, CAST((%2 - MOD(%2, 1)) AS BIGINT)) POSITION(%2 IN %1) = 1 UPPER(%1) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) DAYOFMONTH(%1) MONTH(%1) WEEK(%1) YEAR(%1) QUARTER(%1) EXTRACT(ISOYEAR FROM %1) EXTRACT(ISODOW FROM %1) CURRENT_DATE CURRENT_TIMESTAMP (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) TIMESTAMPADD(%1, %2, %3) TIMESTAMPDIFF(%1, %2, %3) CAST(EXTRACT(%1 FROM %2) AS VARCHAR) CAST(YEAR(%2) AS VARCHAR) CAST(QUARTER(%2) AS VARCHAR) MONTHNAME(%2) CAST(DAYOFYEAR(%2) AS VARCHAR) CAST(DAYOFMONTH(%2) AS VARCHAR) DAYNAME(%2) CAST(WEEK(%2) AS VARCHAR) CAST(HOUR(%2) AS VARCHAR) CAST(MINUTE(%2) AS VARCHAR) CAST(SECOND(%2) AS VARCHAR) EXTRACT(%1 FROM %2) YEAR(%2) QUARTER(%2) MONTH(%2) DAYOFYEAR(%2) DAYOFMONTH(%2) DAYOFWEEK(%2) WEEK(%2) HOUR(%2) MINUTE(%2) SECOND(%2) FLOOR(%2 TO %1)