hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahsa Mofidpoor <mofidp...@gmail.com>
Subject Using indexes for predicates does not increase performance.
Date Wed, 23 May 2012 00:11:00 GMT
Hi,

I did a simple experiment to see the performance difference between normal
execution of a query and the index-based execution. However, the response
time in non-indexed approach is astonishingly smaller. Is it because of the
small data size or the single setup node I use?
I appreciate any help.

Mahsa

Ubuntu 10.0.4
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
RAM 4GB

Hadoop 0.20.2 (*Single setup node*)
Hive-0.9.0
table size ranges from 4MB to 100MB

hive.optimize.index.filter=true
query: select * from table1 where col1='Mark';

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message