[SPARK-14402] initcap UDF doesn't match Hive/Oracle behavior in lowercasing rest of string

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: SQL
• Labels: releasenotes
• Target Version/s: 2.0.0
• Assignee: Dongjoon Hyun
• Reporter: Dongjoon Hyun
• Created: 05/Apr/16 09:19
• Updated: 08/Apr/16 12:02
• Resolved: 08/Apr/16 12:02

Description

Current, SparkSQL `initCap` is using `toTitleCase` function. However, `UTF8String.toTitleCase` implementation changes only the first letter and just copy the other letters: e.g. sParK --> SParK. (This is the correct expected implementation of `toTitleCase`.)

So, The main goal of this issue provides the correct `initCap`.

Issue Links

• links to: [Github] Pull Request #12175 (dongjoon-hyun)
• links to: [Github] Pull Request #12192 (jaceklaskowski)