Re: Hive table creation over sequence file

2012-03-07 Thread Weishung Chung
rds > Bejoy.K.S > > -- > *From:* Weishung Chung > *To:* user@hive.apache.org > *Sent:* Wednesday, March 7, 2012 10:34 AM > *Subject:* Re: Hive table creation over sequence file > > Fellow users, > > I created the table as follows using the mapreduce output file &g

Re: Hive table creation over sequence file

2012-03-07 Thread Bejoy Ks
Hi Chung       What is the OutputFormat of the map reduce job that writes data on to HDFS? Regards Bejoy.K.S From: Weishung Chung To: user@hive.apache.org Sent: Wednesday, March 7, 2012 10:34 AM Subject: Re: Hive table creation over sequence file Fellow

Re: Hive table creation over sequence file

2012-03-06 Thread Weishung Chung
Fellow users, I created the table as follows using the mapreduce output file CREATE EXTERNAL TABLE mytable ( word string, count int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS SEQUENCEFILE LOCATION 's3://mydata/'; This is what i have in my reduce method, key is of type Text

Hive table creation over sequence file

2012-03-06 Thread Wei Shung Chung
Hi users, I have a sequence file produced by mapreduce with TEXT, INTWRITABLE key value pair...I tried to create a external hive table using the file but hive can't read it. Thank you Sent from my iPhone