Re: hive newbie - importing data into hive

2010-12-14 Thread Sonal Goyal
Sean, You can refer to http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create.2BAC8-Drop_Table You can define the ROW FORMAT DELIMITED as part of the table definition and then load your data into the table. Thanks and Regards, Sonal Connect Hadoop with d

Re: hive newbie - importing data into hive

2010-12-14 Thread Kirk True
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 alread

Re: hive newbie - importing data into hive

2010-12-14 Thread Sean Curtis
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:

Re: hive newbie - importing data into hive

2010-12-14 Thread Bryan Talbot
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 wrote: > just wondering if i have a pipe delimited file, how i can just import this > data into hive

hive newbie - importing data into hive

2010-12-14 Thread Sean Curtis
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 th

Re: Libfb303.jar

2010-12-14 Thread Pavan
Did you try replacing libfb3003.jar in Hadoop with the "libfb3003.jar" from Hive? And let us know if this doesn't work. ~ Pavan Yara @yarapavan On Tue, Dec 14, 2010 at 4:22 PM, Adarsh Sharma wrote: > Dear all, > > I am using Hadoop-0.20.2 and Hadoopdb Hive on a 5 node cluster. > I am connecting

Libfb303.jar

2010-12-14 Thread Adarsh Sharma
Dear all, I am using Hadoop-0.20.2 and Hadoopdb Hive on a 5 node cluster. I am connecting Hive through Eclipse but I got the error below : Hive history file=/tmp/hadoop/hive_job_log_hadoop_201012141618_1092196256.txt 10/12/14 16:18:37 INFO exec.HiveHistory: Hive history file=/tmp/hadoop/hive_j