The Impala Query Language and Built-in Functions - Learning Cloudera Impala - page 68

The following statement will return all the names that start with Jo and can
be two or more characters long. In this Impala statement, the result will in-
clude John, Joe, Jo, and Johnson.
SELECT DISTINCT(names) from names_list
WHERE names LIKE 'Jo%';