Re: Changing Apache Derby Embedded Database

2010-11-04 Thread Edward Capriolo
On Thu, Nov 4, 2010 at 5:32 PM, bichonfrise74 wrote: > It looks like only one user can access the Apache Derby DB. When I try to > have multiple jobs running on hive, the other jobs complain something like > this: > > FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to > sta

Changing Apache Derby Embedded Database

2010-11-04 Thread bichonfrise74
It looks like only one user can access the Apache Derby DB. When I try to have multiple jobs running on hive, the other jobs complain something like this: FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to start database '/hadoop/metastore_db', see the next exception for de

Re: Upgrading Hypertable Hive connector

2010-11-04 Thread Ashutosh Chauhan
+1 for shorter release cycles. Currently, is it time based or feature based ? If time based, whats the timeline for 0.7 and if its feature based, which features are "must" for 0.7 release? Ashutosh On Thu, Nov 4, 2010 at 11:42, John Sichi wrote: > We branched 0.6 quite early and by that point we

San Francisco Hadoop meetup

2010-11-04 Thread Aaron Kimball
Hello Hadoop fans, The Bay Area Hadoop User Group meetups are a long hike for those of us who come from San Francisco. I'd like to gauge interest in SF-centric Hadoop gatherings. In contrast to the presentation-based format of the usual HUG meetings, I'm interested in holding events that are more

Re: Upgrading Hypertable Hive connector

2010-11-04 Thread John Sichi
We branched 0.6 quite early and by that point we were only backporting blockers for the release. We're hoping we can make the 0.7 release cycle a lot shorter, and HIVE-1226 will be in there for sure. JVS On Nov 4, 2010, at 2:27 PM, Sanjit Jhala wrote: > Thanks John. Just curious, I see the la

Re: Upgrading Hypertable Hive connector

2010-11-04 Thread Carl Steinbach
Hi Sanjit, On Thu, Nov 4, 2010 at 11:27 AM, Sanjit Jhala wrote: > Thanks John. Just curious, I see the last commit for HIVE-1226 was almost a > month before the 0.6.0 release and I'm wondering why it didn't get into the > release. We created the 0.6 branch several months before the actual 0.6

Re: Upgrading Hypertable Hive connector

2010-11-04 Thread Sanjit Jhala
Thanks John. Just curious, I see the last commit for HIVE-1226 was almost a month before the 0.6.0 release and I'm wondering why it didn't get into the release. Also, I agree theres a lot of duplicated code and will be happy to help out in a refactoring effort. -Sanjit On Thu, Nov 4, 2010 at 11:

Re: Upgrading Hypertable Hive connector

2010-11-04 Thread John Sichi
HIVE-1226 (support for pushing filters down into storage handlers) is only in trunk (not 0.6). Separately: as a followup to HIVE-1434, it would be good to plan a refactoring across the handlers for HBase/Hypertable/Cassandra since there is a lot of duplicated code. JVS On Nov 4, 2010, at 1:3

Upgrading Hypertable Hive connector

2010-11-04 Thread Sanjit Jhala
Hi, I'm taking another pass over the Hypertable Hive storage handler and adding a bit more functionality to it (including regexp filtering). I was also planning to upgrade the Hive version it uses from something between 0.4 & 0.5 to 0.6. In this regard, my preference is to upgrade to 0.6 but I'm

longest matching prefix

2010-11-04 Thread Eyal
Hi, In MySQL to match '12684041234' to the longest prefix I would do SELECT num_prefix FROM nums WHERE '12684041234' LIKE CONCAT(num_prefix, '%') AND LENGTH(num_prefix) = ( SELECT MAX(LENGTH(num_prefix)) FROM nums WHERE '12684041234' LIKE CONCAT(num_prefix, '%') ) ** Table nums has a column name

RE: NOT IN query

2010-11-04 Thread Bennie Schut
You can use a left outer join which works in all databases. select a.value from tablea a left outer join tableb b on (b.value = a.value) where b.value is null; Databases are generally pretty good at doing joins so this usually performs good. From: איל (Eyal)