[jira] [Resolved] (PHOENIX-609) explain select indexed column and general column,only full scan over primary table

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

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

Gabriel Reid resolved PHOENIX-609.
----------------------------------

    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.

> explain select indexed column and general column,only full scan over primary table
> ----------------------------------------------------------------------------------
>
>                 Key: PHOENIX-609
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-609
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: hnucsbjd
>
> explain select indexed columns  from primary table,full scan over index table,but explain select indexed column and general column together from primary table,only full scan over primary table,why not full scan over index table?
> primary table test(v,v2),index table test_idx(v)
> explain select v2 from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST 
> explain select v from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST_IDX
> explain select v,v2 from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST



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