[
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)
