Using Hive Thrift SerDe

2011-06-27 Thread Ayon Sinha
Hi, I can't seem to make Hive find the Thrift SerDe. What do I need to do? hive> add jar /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar;                                                                      Added /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar to class path Added resource: /usr/lib/

Re: wiki has moved!

2011-06-27 Thread John Sichi
On Jun 27, 2011, at 5:16 PM, wrote: > I don't have control over the MoinMoin server; if someone has something > specific they can create an INFRA request, but the page name translation is > not 1-to-1, so it's probably not worth the effort; the old stuff should age > out, and the new stuff will

loading datafiles in s3

2011-06-27 Thread Kennon Lee
Hello, We're using hive on amazon elastic mapreduce to process logs on s3, and I had a couple basic questions. Apologies if they've been answered already-- I gathered most info from the hive tutorial on amazon ( http://aws.amazon.com/articles/2855), as well as from skimming the hive wiki pages, but

Re: wiki has moved!

2011-06-27 Thread John Sichi
On Jun 27, 2011, at 4:37 PM, Time Less wrote: > Might as well add me as editor. I've found tons of errors and problems. Not > the least of which the regexserde is now completely borked and nonsensical. > Compare "([^]*) ([^]*) ..." against "([^ ]*) ([^ ]*) ..." - I thought I was > going insane.

Re: Bizarro Hive (Hadoop?) Error

2011-06-27 Thread Sumanth V
You are hitting this bug - https://issues.apache.org/jira/browse/HIVE-1579 I consistently hit this bug for one of the Hive queries. Sumanth On Mon, Jun 27, 2011 at 5:08 PM, Time Less wrote: > Today I'm getting this error again. A Google search brought me back to... > you guessed it... my own

Re: Bizarro Hive (Hadoop?) Error

2011-06-27 Thread Time Less
Today I'm getting this error again. A Google search brought me back to... you guessed it... my own post. But this time no HDFS corruption. Bounced all services, namenode, jobtracker, datanodes, tasktrackers. Still same error. Here's what it looks like: *Fsck Output: *FSCK ended at Mon Jun 27 17:02

Re: wiki has moved!

2011-06-27 Thread Time Less
> We need your help (or at least tolerance) to deal with some of the > imperfections in the migration process: > > https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki > > If you already an editor on the old wiki, or if you would like to help with > fixing/editing now, contact me for writ

Loading seq file into hive

2011-06-27 Thread Mapred Learn
Hi, I have seq files with key as line number and value is ctrl B delimited text. a sample value is: 45454^B567^Brtrt^B-7.8 56577^B345^Bdrtd^B-0.9 when I create a table like: create table temp_seq (no. int, code string, rank string, amt string) row format delimited fields terminated by '\002' lines

RESOLVED: Re: URGENT: I need the Hive Server setup Wiki

2011-06-27 Thread Ayon Sinha
Thanks everyone.   -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions. From: John Sichi To: "" ; Ayon Sinha Sent: Monday, June 27, 2011 2:39 PM Subject: Re: URGENT: I need the Hive Server setup Wiki It's not empty, b

Re: URGENT: I need the Hive Server setup Wiki

2011-06-27 Thread John Sichi
It's not empty, but the links on it were broken; I just fixed them. jVS On Jun 27, 2011, at 2:31 PM, Ayon Sinha wrote: > https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServer > is empty > and the old link is gone. > > -Ayon > See My Photos on Flickr > Also check out

Re: URGENT: I need the Hive Server setup Wiki

2011-06-27 Thread Ted Yu
There're 3 links on that page. On Mon, Jun 27, 2011 at 2:39 PM, Ted Yu wrote: > wiki has moved. > See > https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServer > > > On Mon, Jun 27, 2011 at 2:31 PM, Ayon Sinha wrote: > >> >> https://cwiki.apache.org/confluence/display/H

Re: URGENT: I need the Hive Server setup Wiki

2011-06-27 Thread Ted Yu
wiki has moved. See https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServer On Mon, Jun 27, 2011 at 2:31 PM, Ayon Sinha wrote: > > https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServeris > empty > and the old link is gone. > > -Ayon > See My P

URGENT: I need the Hive Server setup Wiki

2011-06-27 Thread Ayon Sinha
https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServer is empty and the old link is gone.   -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions.

updated location for Apache Hive Contributor Day

2011-06-27 Thread John Sichi
The location details are on the event page: http://hivecontribday2011.eventbrite.com There are still plenty of seats left for anyone interested. JVS

Re: Resend -> how to load sequence file with decimal data

2011-06-27 Thread Mapred Learn
Hi Steven, With load data you give some info about data also. As in Tom' White's book: create external table external_table(dummy string) location load data Now dummy string is a field in this data. Similarly, what I have is a dcimal field. How do I specify it in the create command ? On