Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # dev >> Using indexes for predicates does not increase performance.


Copy link to this message
-
Using indexes for predicates does not increase performance.
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';
+
Chinna Rao Lalam 2012-05-23, 05:19
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB