[jira] [Resolved] (PHOENIX-739) Phoenix not picking up the hint correctly.

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-739.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Phoenix not picking up the hint correctly.
> ------------------------------------------
>
>                 Key: PHOENIX-739
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-739
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Samarth Jain
>
> Phoenix is not picking up the right hint even when forced to do so:
> Version details:
> HBase - hbase-0.94.9-security
> Phoenix - 2.1.1
> If you execute the following on the squirrel client against a hbase cluster consisting of 1 region server - 
> DDL - 
> create table eh (organization_id char(15) not null,parent_id char(15) not null, created_date date not null, entity_history_id char(15) not null constraint pk primary key (organization_id, parent_id, created_date, entity_history_id))
> Query- 
> explain select /*+ RANGE_SCAN */ ORGANIZATION_ID, PARENT_ID, CREATED_DATE, ENTITY_HISTORY_ID from eh where ORGANIZATION_ID='111111111111111' and SUBSTR(PARENT_ID, 1, 3) = 'foo' and TO_DATE ('2012-0-1 00:00:00') <= CREATED_DATE and CREATED_DATE <= TO_DATE ('2012-11-31 00:00:00') order by ORGANIZATION_ID, PARENT_ID, CREATED_DATE DESC, ENTITY_HISTORY_ID limit 100
> <b>Expected:</b>
> CLIENT PARALLEL 1-WAY <b>RANGE SCAN OVER EH</b> ['111111111111111','foo','2011-12-01 00:00:00.000'] - ['111111111111111','fop','2012-12-01 00:00:00.000']\n" + 
>                 "    SERVER FILTER BY (CREATED_DATE >= 2011-11-30 AND CREATED_DATE <= 2012-11-30)\n" + 
>                 "    SERVER TOP 100 ROWS SORTED BY [ORGANIZATION_ID, PARENT_ID, CREATED_DATE DESC, ENTITY_HISTORY_ID]\n" +
> </br>
> <b>Actual:</b>
> CLIENT PARALLEL 1-WAY <b>SKIP SCAN ON 1 RANGE OVER EH</b> ['111111111111111','foo','2011-12-01 00:00:00.000'] - ['111111111111111','fop','2012-12-01 00:00:00.000']
>     SERVER TOP 100 ROWS SORTED BY [ORGANIZATION_ID, PARENT_ID, 
> CREATED_DATE DESC, ENTITY_HISTORY_ID]
> CLIENT MERGE SORT



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