https://community.cloudera.com/t5/Support-Questions/how-to-split-name-based-on-special-character-in-hive/m-p/242007#M203810 <P>If the input is text data, its better to write a java utility which reads line by line, applies all the rules &amp; re-writes it as four column as per conversion required. Then load that new file into hive to query it.<BR />It will be cumbursome to do it in sql, as it needs another case statement inside case statement to validate the length of the split.</P> Mon, 14 Jan 2019 11:57:32 GMT nramanaiah 2019-01-14T11:57:32Z