Re: Running and Sliding on Aggregates

2010-11-16 Thread Jeff Hammerbacher
Hey Michael, I unfortunately can't tell you how to get around this limitation, but I can point you to the JIRA issue that attempts to capture the requirements: https://issues.apache.org/jira/browse/HIVE-896. If you could describe your use case there, we can capture it for posterity in hope that so

Running and Sliding on Aggregates

2010-11-16 Thread Michael Roessler
I suffer from "sql-itis", especially the SQL:2003 variant. I can barely get a data-related programming line out of my fingers that doesn't include a "partition by" or an "over order by". Many of the data sets I analyze can be simplified for comprehension by thinking of them as having only three co

Best approach for data mashup... Import external Data from MySQL to a Hive table or use Custom Map using JDBC?

2010-11-16 Thread Marcello de Sales
Hello all, I'm using Hive to do mashups of data that is currently on HDFS and data is that is on a MySQL database... I'm considering this scenario instead of bringing the data from MySQL to HDFS because it is a matter verifying the relating data from the query to the data in the external data stor

Re: EXTERNAL:Re: unable to create table

2010-11-16 Thread Ted Yu
The class is in antlr-runtime-3.0.1.jar Try finding it under On Tue, Nov 16, 2010 at 11:43 AM, Gerlach, Hannah L (IS) < hannah.gerl...@ngc.com> wrote: > Dear Ted, > > > > Maybe I am missing something, but ‘Exception in hive startup’ appears to > be a different problem. > > > > When I run /bin/h

RE: EXTERNAL:Re: unable to create table

2010-11-16 Thread Gerlach, Hannah L (IS)
Dear Ted, Maybe I am missing something, but 'Exception in hive startup' appears to be a different problem. When I run /bin/hive, it starts fine. The problem arises when I try to create a table once hive is running. Best, Hannah From: Ted Yu [mailto:yuzhih...@gmail.com] Sent: Tue

Re: unable to create table

2010-11-16 Thread Ted Yu
See 'Exception in hive startup' discussion - especially Edward's response on Oct 13th. On Tue, Nov 16, 2010 at 9:40 AM, Gerlach, Hannah L (IS) < hannah.gerl...@ngc.com> wrote: > Hello, > > > > I am completely new to hive and I need some help. Hive starts fine, but > when I try to create a table,

unable to create table

2010-11-16 Thread Gerlach, Hannah L (IS)
Hello, I am completely new to hive and I need some help. Hive starts fine, but when I try to create a table, I get an error. See below. hive> CREATE TABLE pokes (foo INT, bar STRING); Exception in thread "main" java.lang.NoClassDefFoundError: org/antlr/runtime/tree/TreeAdaptor

Re: How to generate global unique ID?

2010-11-16 Thread afancy
Hi, Tim, I think sequential integer would be better. Is it difficult to generate a global integer? BTW: how to generate UUID in Hive? thanks Regards, afancy On Tue, Nov 16, 2010 at 9:11 AM, Tim Robertson wrote: > Does it need to be a sequential INT? If not, then a UUID works very well. > > Chee

Re: How to generate global unique ID?

2010-11-16 Thread Tim Robertson
Does it need to be a sequential INT? If not, then a UUID works very well. Cheers, Tim On Tue, Nov 16, 2010 at 8:55 AM, afancy wrote: > Hi, Zhang, > How to integrate this snowflake with Hive?  Thanks! > Regards, > afancy > > On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang wrote: >> >> Please refer