You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/23 21:41:39 UTC

[jira] [Updated] (PHOENIX-2094) Query hint ignored for functional index

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

James Taylor updated PHOENIX-2094:
----------------------------------
    Assignee: Thomas D'Silva

> Query hint ignored for functional index
> ---------------------------------------
>
>                 Key: PHOENIX-2094
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2094
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Bryan Gerber
>            Assignee: Thomas D'Silva
>
> Hints are not being used for functional index.
>  
> EXPLAIN SELECT /*+ INDEX(LOG LOG_LOWER_REQUEST_IDX) */ * FROM LOG WHERE LOWER(RQ) LIKE '/jquery%';
> +------------------------------------------+
> | CLIENT 40-CHUNK PARALLEL 40-WAY FULL SCAN OVER LOG |
> |     SERVER FILTER BY LOWER(RQ) LIKE '/jquery%' |
> +------------------------------------------+
>  
> Test table has 2.9 million records; production table is many orders of magnitude larger. 
> Here’s a simplified schema for the test table:
> CREATE TABLE IF NOT EXISTS LOG
> (
>     TS VARCHAR NOT NULL,
>     f VARCHAR NOT NULL,
>     r INTEGER NOT NULL,
>     sa VARCHAR,
>     da VARCHAR,
>     rq VARCHAR
> CONSTRAINT pkey PRIMARY KEY (TS, f, r)
> ) TTL='5616000',KEEP_DELETED_CELLS='false',IMMUTABLE_ROWS=true,COMPRESSION='SNAPPY',SALT_BUCKETS=40,MAX_FILESIZE='10000000000',SPLIT_POLICY='org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy';
>  
> CREATE INDEX IF NOT EXISTS LOG_LOWER_REQUEST_IDX  ON LOG(LOWER(rq)) TTL='5616000',KEEP_DELETED_CELLS='false',COMPRESSION='SNAPPY',MAX_FILESIZE='10000000000',SPLIT_POLICY='org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy';
> CREATE INDEX IF NOT EXISTS LOG_REQUEST_IDX  ON LOG(rq) TTL='5616000',KEEP_DELETED_CELLS='false',COMPRESSION='SNAPPY',MAX_FILESIZE='10000000000',SPLIT_POLICY='org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy';



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)