phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajeshbabu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1035) Performance test local indexing against global indexing
Date Wed, 10 Dec 2014 15:54:13 GMT

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

Mime
View raw message