hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sean Curtis <sean.cur...@gmail.com>
Subject Re: hive newbie - importing data into hive
Date Wed, 15 Dec 2010 04:59:18 GMT
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 <sean.curtis@gmail.com> 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
> 


Mime
View raw message