The docs for the Impala function initcap() state:
Purpose: Returns the input string with the first letter capitalized.
But what this function actually does is: Returns the input string with the first letter of every word capitalized and every other letter lowercase. This sentence in the docs should be corrected to reflect this.
To confirm that Impala's behavior is as I describe, run a simple Impala query like:
SELECT initcap("i gOt mY HorSeS in tHe bacK");
The result will be:
"I Got My Horses In The Back"