We had this wierd behvior

[Guy Doulberg]

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