[jira] [Commented] (PHOENIX-114) Add Hints so that user can select whether to use "avoid seek optimization" or not

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-114:
--------------------------------------

+1. Looks great. Thanks, [~anoop.hbase].

> Add Hints so that user can select whether to use "avoid seek optimization" or not
> ---------------------------------------------------------------------------------
>
>                 Key: PHOENIX-114
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-114
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Anoop Sam John
>            Assignee: Anoop Sam John
>         Attachments: PHOENIX-114.patch
>
>
> PHOENIX-29 added a new optimization in which we wont use HBase side ExplicitColumnTracker and seeks to columns (When query selects selective columns). This will be useful when there are less number of columns/versions whic are excluded.  But when there are many column/versions which can be skipped (If the seeks can jump over some HFile blocks) the old way will be better.
> This issue adds two Hints in select for the user to explicitely tell whether to use the column seek model or non seek model



--
This message was sent by Atlassian JIRA
(v6.2#6252)