Hello Edward Capriolo, Thank you for your reply. Are you sure that if you string enough 'or' together (say 8000) the query parser which uses java beans serialization will OOM? How many memory you assign to hive?
2010/8/4 Edward Capriolo <[email protected]> > On Wed, Aug 4, 2010 at 6:10 AM, lei liu <[email protected]> wrote: > > Because my company reuire we use 0.4.1 version, the version don't support > IN > > clause. I want to use the OR clause(example:where id=1 or id=2 or id=3) > to > > implement the IN clause(example: id in(1,2,3) ). I know it will be > slower > > especially when the list after "in" is very long. Could anybody can tell > me > > why is slow when use OR clause to implement In clause? > > > > > > Thanks, > > > > > > LiuLei > > > > I can not imagine the performance difference between 'or' or 'in' > would be that great but I never benchmarked it. The big looming > problems is that if you string enough 'or' together (say 8000) the > query parser which uses java beans serialization will OOM. > > Edward >
