Re: Unit tests failing on hive-0.7.1

2011-09-30 Thread Ramya Sunil
Thanks John. Will try it. On Thu, Sep 29, 2011 at 11:25 AM, John Sichi jsi...@fb.com wrote: mirror.facebook.net is currently down and won't be back up for at least a few days. There's a fallback at http://archive.cloudera.com/hive-deps If it's not kicking in for you automatically, you'll

Insert directory output format?

2011-09-30 Thread Jason Rutherglen
When using the command 'INSERT OVERWRITE LOCAL DIRECTORY ...' what is the format of the file output? Can it be customized?

Copying a Hive metastore

2011-09-30 Thread Steven Wong
Hi, What is a good way to copy the entire content of a Hive metastore and insert it into another Hive metastore? The second metastore contains existing metadata that needs to be preserved. Both metastores are in MySQL, not fronted by any Hive metastore server. My guess is Hive has some

October SF Hadoop Meetup

2011-09-30 Thread Aaron Kimball
The October SF Hadoop users meetup will be held Wednesday, October 12, from 7pm to 9pm. This meetup will be hosted by Twitter at their office on Folsom St. *Please note that due to scheduling constraints, we will begin an hour later than usual this month.* As usual, we will use the

Re: Copying a Hive metastore

2011-09-30 Thread Edward Capriolo
On Fri, Sep 30, 2011 at 5:05 PM, Steven Wong sw...@netflix.com wrote: Hi, What is a good way to copy the entire content of a Hive metastore and insert it into another Hive metastore? The second metastore contains existing metadata that needs to be preserved. Both metastores are in MySQL,

Hive NoSuchMethodError

2011-09-30 Thread Juwon Lee
Hello, I am trying to run a insert overwrite into ... select * from query. The hadoop job submitted by Hive finishes successfully, but there seems to be an error while collecting results. Please see below for exception stack. The interesting point is that the error is NoSuchMethodError. The

Having trouble using regex serde

2011-09-30 Thread Jonathan
Hi, I am trying to parse an apache2 log using the 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'. I am able to load the tables using the script below but its showing up each of the 3 rows as null for every entry. CREATE TABLE apachelog4 ( ip STRING, time STRING, beacon STRING) ROW

Re: Having trouble using regex serde

2011-09-30 Thread Jonathan
So the regex has to match every piece of the line completely. I wrote the regex so that it just takes a few helpful things out of the log line. Thanks for your help Jonathan On Sat, Oct 1, 2011 at 12:14 AM, Vijay tec...@gmail.com wrote: The log lines are in some kind of JSON format though.