Afaik hive has no indexing at all. That's part of why it's so simple (well, for hadoop folks) to use. All you need to do is copy a bunch of csv, tsv, logs, what

Afaik hive has no indexing at all. That's part of why it's so simple (well, for hadoop folks) to use. All you need to do is copy a bunch of csv, tsv, logs, whatever in a HDFS path, tell hive some basic infos about the files and you can join the table with any other information in the system. Really powerful stuff. However, if you don't have any legacy data and/or don't mind manual import into HBase then something like the above solution may reduce the complexity of the issue enough to get much better query performance.