hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy Doulberg <Guy.Doulb...@conduit.com>
Subject We had this wierd behvior
Date Thu, 17 Mar 2011 08:43:26 GMT
Hey guys,

I have a hive partitioned table.

First I ran a query that look like this:
Select count(*)
>From table
Where field like '%bla%' and (partition>'10' and partition < '20')

For this query I got
Some records let's say 640

When I ran this query
Select count(*)
>From table
Where field like '%bla%' and (partition>'5' and partition < '20')

I got none.....

Assume that I have partitions 5-20.

What am I missing here?

Thanks gut



Mime
View raw message