[HIVE-3405] UDF initcap to obtain a string with the first letter of each word in uppercase other letters in lowercase

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.1, 0.9.0, 0.9.1, 0.10.0, 0.11.0, 0.13.0, 0.14.0, 0.14.1, 0.15.0
• Fix Version/s: 1.1.0
• Component/s: UDF
• Labels: patch
• Release Note: Returns string, with the first letter of each word in uppercase, all other letters in lowercase.
• Assignee: Alexander Pivovarov
• Reporter: Archana Nair
• Created: 23/Aug/12 04:28
• Updated: 12/Feb/15 23:40
• Resolved: 12/Jan/15 19:06

Description

Hive current releases lacks a INITCAP function which returns String with first letter of the word in uppercase.INITCAP returns String, with the first letter of each word in uppercase, all other letters in same case. Words are delimited by white space.This will be useful report generation.