Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> About Usage of Hive Index

Copy link to this message
About Usage of Hive Index

When I try to use Hive Indexing, I have the following questions.

1. Does Indexing have the same performance on both the partitioned and
non-partitioned tables? How about bucketed and un-bucked tables?

2. Is it possible for us to build index of function of indexed columns,
        create index x on my_table(my_function_1(col1, col2, ...),
my_function_2(col1, col2, ...), ...)?

3. If we try to use the non-indexed columns in base table,  can we use the
index table to speed up the query? join?

Any suggestions? Thanks in advance.
Best wishes,