thanks Bryan should have been more specific. checked that guide and it didnt seem obvious with LOAD INFILE how to take a file that was already pipe-delimited and straight import that.
is there a section of the doc i may have missed or some tip that can help there? sean On Dec 14, 2010, at 11:36 PM, Bryan Talbot wrote: > I'll help by recommending that you get started by looking at the "Getting > Started Guide". > > http://wiki.apache.org/hadoop/Hive/GettingStarted > > > -Bryan > > > On Tue, Dec 14, 2010 at 8:23 PM, Sean Curtis <[email protected]> wrote: > 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 >
