just wondering if i have a pipe delimited file, how i can just import this data into hive:
basically i am using the microlens database, which is pipe separated. for example: user id | age | gender | occupation | zip code translates to 123 | 24 | M | worker | 12345 i'd like to just import this straight into Hive. my initial thoughts: 1. use unix substitute command and change all "|" to "Ctrl-A". 2. import into mysql, then use sqoop seems it should be easier than this. can someone help? thanks for the help. sean