Apache Drill Character Function | Notes |
ASCII | |
BIT_LENGTH | |
BTRIM | |
CHARACTER_LENGTH | |
CONCAT | |
DIFFERENCE | |
INITCAP | |
INSTR | |
ISUTF8 | |
LENGTH | |
LOCATE | |
LOWER | |
LPAD | |
LTRIM | |
OCTET_LENTH | |
QUOTE_IDENT | |
QUOTE_LITERAL | |
REPEAT | |
REPLACE | |
RPAD | |
RTRIM | |
SOUNDEX | |
SPACE | |
STRPOS | |
POSITION | |
SUBSTR | |
SUBSTRING | |
TRIM | |
TRIMBOTH | |
TRIMLEADING | |
TRIMTRAILING | |
UPPER |