Hive Programming Guide--employees table data definition

There is a employees table in the Hive Programming Guide, the default delimiter is cumbersome, the editing is not very convenient (the general editor of the control character ^a, etc. is treated as a string, does not play the role of delimiters). The following solutions are collected:

Http://www.myexception.cn/software-architecture-design/1351552.html

http://blog.csdn.net/lichangzai/article/details/18703971

Remember, the simple text editor edits the following, the delimiter is not recognized, ^A^B^C will be treated as a string, import data in hive will not recognize the delimiter, causing some fields to display null

John doe^a100000.0^amary smith^btodd jones^afederal taxes^c.2^bstatetaxes^c.05^binsurance^c.1^a1 Michigan Ave.^ bchicago^bil^b60600
Mary smith^a80000.0^abill king^afederal taxes^c.2^bstate taxes^c.05^binsurance^c.1^a100 Ontario St.^BChicago^BIL^ B60601
Todd jones^a70000.0^afederaltaxes^c.15^bstate taxes^c.03^binsurance^c.1^a200 Chicago ave.^boak Park^BIL^B60700
Bill king^a60000.0^afederal taxes^c.15^bstate taxes^c.03^binsurance^c.1^a300 obscure Dr.^BObscuria^BIL^B60100

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Hive Programming Guide--employees table data definition