[
https://issues.apache.org/jira/browse/PHOENIX-1035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14241275#comment-14241275
]
rajeshbabu commented on PHOENIX-1035:
-------------------------------------
[~mujtabachohan]
I have setup pseudo cluster and loaded the data. Then when I ran count query
it's not taking much time.
{code}
0: jdbc:phoenix:localhost> explain select count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| PLAN |
+------------------------------------------+
| CLIENT 32-CHUNK PARALLEL 32-WAY RANGE SCAN OVER
_LOCAL_IDX_LOCAL_INDEXED_TABLE_WIDE [-32768] |
| SERVER AGGREGATE INTO SINGLE ROW |
+------------------------------------------+
2 rows selected (0.089 seconds)
0: jdbc:phoenix:localhost> select count(*) from LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 3000000 |
+------------------------------------------+
1 row selected (20.688 seconds)
0: jdbc:phoenix:localhost> select /*NO_INDEX*/count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 3000000 |
+------------------------------------------+
{code}
When splitting is in progress I ran explain query then it's going to data table
as for the fix.
{code}
0: jdbc:phoenix:localhost> explain select count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| PLAN |
+------------------------------------------+
| CLIENT 8-CHUNK PARALLEL 1-WAY FULL SCAN OVER LOCAL_INDEXED_TABLE_WIDE |
| SERVER AGGREGATE INTO SINGLE ROW |
+------------------------------------------+
2 rows selected (0.064 seconds)
{code}
Am I missing anything?
> Performance test local indexing against global indexing
> -------------------------------------------------------
>
> Key: PHOENIX-1035
> URL: https://issues.apache.org/jira/browse/PHOENIX-1035
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Mujtaba Chohan
>
> Local indexing is close to being in. We should perf test it both for reads
> and writes against global secondary indexing.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
