On Thursday, March 17, 2011, Guy Doulberg <guy.doulb...@conduit.com> wrote: > Hey guys, I have a hive partitioned table. First I ran a query that look like > this:Select count(*) From tableWhere field like '%bla%' and (partition>'10' > and partition < '20') For this query I gotSome records let's say 640 When I > ran this query Select count(*) From tableWhere 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
Is your table partitioned by int or string? '5' is not less then '20' when you are treating them as strings. Don't put single quotes around numbers
