hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal Vijayaraghavan <gop...@apache.org>
Subject Re: Is Hive Index officially not recommended?
Date Tue, 09 Feb 2016 02:13:28 GMT

> Is anybody storing there index in a non-native table such as HBase?
...
> Can you please point to implementations of HiveIndexHandler or
>AbstractIndexHandler
> that have usesIndexTable=false

I don't think there are any publically available implementations yet.

The Hive HBase-metastore project adds a standardized HBase instance into
the mixture in hive-2.0.

We already moved the min-max indexes in ORC to the HBase metastore

https://issues.apache.org/jira/browse/HIVE-11676

+
https://issues.apache.org/jira/browse/HIVE-12075
+
https://issues.apache.org/jira/browse/HIVE-12061


I haven't really worked out how the aggregate indexes should work, but the
goal is to produce min-max indexes (then bloom filters).

The representative query (in my mind) looks somewhat like

UPDATE txns SET reversed=true where txn_id = 1;

where txns is partitioned by date.

Cheers,
Gopal







Mime
View raw message