phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-153) Implement TABLESAMPLE clause
Date Tue, 01 Aug 2017 17:17:02 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16109342#comment-16109342
] 

ASF GitHub Bot commented on PHOENIX-153:
----------------------------------------

Github user aertoria commented on the issue:

    https://github.com/apache/phoenix/pull/262
  
    Commit 0507d4f change list:
    1, explain plan a new way (Thanks for the suggestion)
    2, squash previous four commit into one
    3, revise all commit message to start with PHOENIX-153+space 
    
    
    preview on a Single select
    `CLIENT 3-CHUNK 30 ROWS 2370 BYTES PARALLEL 1-WAY 0.2-SAMPLED ROUND ROBIN FULL SCAN OVER
PERSON`
    
    on a Join select
    ```
    CLIENT 1-CHUNK 0 ROWS 0 BYTES PARALLEL 1-WAY 0.65-SAMPLED ROUND ROBIN FULL SCAN OVER INX_ADDRESS_PERSON
        SERVER FILTER BY FIRST KEY ONLY
        PARALLEL INNER-JOIN TABLE 0
            CLIENT 1-CHUNK 1 ROWS 32 BYTES PARALLEL 1-WAY 0.15-SAMPLED ROUND ROBIN FULL SCAN
OVER US_POPULATION
        DYNAMIC SERVER FILTER BY TO_CHAR("INX_ADDRESS_PERSON.0:ADDRESS") IN (US_POPULATION.STATE)
    ```
    



> Implement TABLESAMPLE clause
> ----------------------------
>
>                 Key: PHOENIX-153
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-153
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>            Assignee: Ethan Wang
>              Labels: enhancement
>         Attachments: Sampling_Accuracy_Performance.jpg
>
>
> Support the standard SQL TABLESAMPLE clause by implementing a filter that uses a skip
next hint based on the region boundaries of the table to only return n rows per region.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message