hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kirk True <k...@mustardgrain.com>
Subject Re: hive newbie - importing data into hive
Date Wed, 15 Dec 2010 05:00:48 GMT
Hi Sean,

The delimiter used is specified in the create table statement, not the 
LOAD DATA statement.

Kirk

On 12/14/2010 08:59 PM, Sean Curtis wrote:
> 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 
>> <mailto: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