Re: does hive support Sequence File format ?

2011-06-28 Thread Tim Spence
It should be here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL For everyone's benefit, the old wiki page you linked to has a link to a page directory on the new wiki here: https://cwiki.apache.org/confluence/pages/listpages-dirview.action?key=Hive Tim On Tue, Jun 28, 2

Re: Hive Query Question

2011-06-13 Thread Tim Spence
ue ? > > Can anyone comment on whether that's safe, re: I'm not familiar with Hive > internals ? > > Thanks, > > pk > > Sent from my iPhone > > On Jun 10, 2011, at 11:18 PM, Tim Spence > wrote: > > Praveen, > This would be best accomplished

Re: Hive Query Question

2011-06-10 Thread Tim Spence
Praveen, This would be best accomplished with a UDF because Hive does not support cursors. Best of luck, Tim On Fri, Jun 10, 2011 at 10:29 PM, Praveen Kumar wrote: > If I have table timestamps: > > hive> desc timestamps; > > OK > ts bigint > > > hive> select ts from timestamps order by t

Re: Can Hive 0.7 Rebuild partitions ?

2011-05-19 Thread Tim Spence
Is this functionality handled by ALTER TABLE [name] RECOVER PARTITIONS? Take a look at this presentation for context: http://www.slideshare.net/AmazonWebServices/aws-office-hours-amazon-elastic-mapreduce Best of luck, Tim On Thu, May 19, 2011 at 2:25 AM, Jasper Knulst wrote: > Hi, > > I have

Re: Inconsistent results from INSERT OVERWRITE TABLE

2011-05-11 Thread Tim Spence
he whole Hive query. > > On May 11, 2011, at 2:16 PM, Tim Spence wrote: > > > I've been using Hive in production for two months now. We're mainly > using it for processing server logs, about 1-2GB per day (2-2.5 million > requests). Typically we import a day'

Inconsistent results from INSERT OVERWRITE TABLE

2011-05-11 Thread Tim Spence
I've been using Hive in production for two months now. We're mainly using it for processing server logs, about 1-2GB per day (2-2.5 million requests). Typically we import a day's worth of logs at once. That said, sometimes we decide to tweak a calculated column. When that happens, we modify our

Re: HiveQL scripts and input arguments

2011-05-04 Thread Tim Spence
I'm wondering the same. I didn't notice it in the documentation for 0.7. My (possibly silly) way of dealing with it is to write ruby scripts to concatenate commands like > bin/hive -e "some statement" to a shell script, then execute the shell script. Parameterized scripting would be so welcome