phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4064) Why the group by the index field will execute scan over table.
Date Fri, 04 Aug 2017 02:55:00 GMT

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

James Taylor commented on PHOENIX-4064:
---------------------------------------

Need to see your table & index DDL.

>  Why the group by the index field will execute scan over table.
> ---------------------------------------------------------------
>
>                 Key: PHOENIX-4064
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4064
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.11.0
>            Reporter: jifei_yang
>              Labels: features
>             Fix For: 4.11.0
>
>
> Why the group by the index field will execute scan over table.
> I created a Phoenix table, and then created the index, all the fields are marked as index.
However, when the group by index field is executed, the execution plan is viewed and the index
is not used. Please help solve the next, thank you.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message