You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kudu.apache.org by "Redriver (Jira)" <ji...@apache.org> on 2020/11/23 09:52:00 UTC

[jira] [Commented] (KUDU-2038) Add b-tree or inverted index on value field

    [ https://issues.apache.org/jira/browse/KUDU-2038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17237257#comment-17237257 ] 

Redriver commented on KUDU-2038:
--------------------------------

What is about the current status? It is a very useful feature for fast scan.

> Add b-tree or inverted index on value field
> -------------------------------------------
>
>                 Key: KUDU-2038
>                 URL: https://issues.apache.org/jira/browse/KUDU-2038
>             Project: Kudu
>          Issue Type: Task
>            Reporter: Yi Guolei
>            Priority: Major
>              Labels: roadmap-candidate
>
> Do we have a plan to add index on any column [not primary column] ? Currently kudu does not have btree or inverted index on columns. In this case if a query wants to filter a column then kudu has to scan all datas in all rowsets. 
> For example, select * from table where salary > 10000 and age < 40, the bloom filter or min max index will have no effect, kudu has to scan all datas in all row sets. But if kudu has inverted index, then it will be much faster.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)