RE: Search the newest partition of one table in view

2010-10-20 Thread Paul Yang
I don't think it is possible to use just a view to get that effect. If you're generating the query programmatically, it'd be possible to either use the Thrift service or process the output of 'show partitions' to get the latest partition date. From: lei liu [mailto:liulei...@gmail.com] Sent: We

Search the newest partition of one table in view

2010-10-20 Thread lei liu
There is one table, I use one timer to create one new partition for the table every day, now I want to create one view, use the view to search the newest partition of the table,how can I receive the newest partition of the table in view? Thanks, LiuLei

RE: Unpredictable results when using partitions in where clause

2010-10-20 Thread Bakshi, Ankita
Pls. ignore this question. It was a bug on our side. From: Bakshi, Ankita Sent: Wednesday, October 20, 2010 10:50 AM To: 'user@hive.apache.org' Subject: RE: Unpredictable results when using partitions in where clause Attached are two such mapred jobs which produce

Using Hive with HBase 0.89

2010-10-20 Thread Leo Alekseyev
We are running into the issue reported in HIVE-1597 (Hive CLI returns MasterNotRunningException with HBase 0.89.x) when using Hive from trunk and HBase 0.89.20100830, StumbleUpon branch. Does anyone here have possible workarounds for this issue, or does anyone successfully run Hive with HBase 0.

Ambiguity with singleton array with a null value

2010-10-20 Thread Mike Lewis
It appears that if you have an array with the length of 1 and a null in it, it will just assume the column is null. I realize the specification for this is ambiguous because it would be stored the same way whether the array is null, or it is an array with the length of one. Is there a best known

Re: Key values not importing for SequenceFiles

2010-10-20 Thread Chris Bates
I just found this thread and will be investigating this now: http://www.mail-archive.com/hive-u...@hadoop.apache.org/msg01701.html On Wed, Oct 20, 2010 at 5:52 PM, Chris Bates < christopher.andrew.ba...@gmail.com> wrote: > Oh and we are using CDH2 which I believe is using version 0.4.1 > > > On W

Re: Key values not importing for SequenceFiles

2010-10-20 Thread Chris Bates
Oh and we are using CDH2 which I believe is using version 0.4.1 On Wed, Oct 20, 2010 at 5:38 PM, Chris Bates < christopher.andrew.ba...@gmail.com> wrote: > Hi all, > > I've done a lot of research about this today, but haven't found the > solution. I'm importing a bunch of sequencefiles that were

Key values not importing for SequenceFiles

2010-10-20 Thread Chris Bates
Hi all, I've done a lot of research about this today, but haven't found the solution. I'm importing a bunch of sequencefiles that were created from Map/Reduce jobs into Hive tables, but the keys never get imported, just the values. This is my create table syntax: create external table Feeds (se

RE: Unpredictable results when using partitions in where clause

2010-10-20 Thread Bakshi, Ankita
Attached are two such mapred jobs which produced different results. Here jobid 58 produced list of all partitions without the date filter and jobid 62 resulted in expected output. Thanks, Ankita From: Bakshi, Ankita Sent: Wednesday, October 20, 2010 10:33 AM To:

Unpredictable results when using partitions in where clause

2010-10-20 Thread Bakshi, Ankita
Hi, I have a table which is partitioned per hour. I wanted to get a list of partitions which are less than a certain time limit. The issue that I am facing is: the result of the query is unpredictable between continuous run - sometimes it give expected result, but sometimes, the same query is g