Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Fri, 9 Jun 2017 18:35:18 +0000 (UTC)
From: "Ethan Wang (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.12699925.1394495194000.41267.1497033318301@Atlassian.JIRA>
In-Reply-To: <JIRA.12699925.1394495194000@Atlassian.JIRA>
References: <JIRA.12699925.1394495194000@Atlassian.JIRA> <JIRA.12699925.1394495194677@jira-lw-us.apache.org>
Subject: [jira] [Comment Edited] (PHOENIX-153) Implement TABLESAMPLE clause
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 09 Jun 2017 18:35:23 -0000


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

Ethan Wang edited comment on PHOENIX-153 at 6/9/17 6:34 PM:
------------------------------------------------------------

Spec of this patch. Feedback plz.

++
++Belows are SUPPORTED
++
===BASE CASE====
select * from Person;
select * from PERSON TABLESAMPLE 0.45;

===WHERE CLAUSE====
select * from PERSON where ADDRESS = 'CA' OR name>'tina3';
select * from PERSON TABLESAMPLE 0.49 where ADDRESS = 'CA' OR name>'tina3';
select * from PERSON TABLESAMPLE 0.49 where ADDRESS = 'CA' OR name>'tina3' LIMIT 1;


===Wired Table===
select * from LOCAL_ADDRESS TABLESAMPLE 0.79;
select * from SYSTEM.STATS TABLESAMPLE 0.41;


===CORNER CASE===
select * from PERSON TABLESAMPLE 0;
select * from PERSON TABLESAMPLE 1.45;
select * from PERSON TABLESAMPLE kko;


++
++belows are NOT SUPPORTED
++
===Subquery and outter join not supporting===
select * from (select * from PERSON where ADDRESS = 'CA') TABLESAMPE 0.2 where Name > 'tina10'

===AGGREGATION===
select count( * ) from PERSON TABLESAMPLE 0.5 LIMIT 2


was (Author: aertoria):
Spec of this patch. Feedback plz.

++
++Belows are SUPPORTED
++
===BASE CASE====
select * from Person;
select * from PERSON TABLESAMPLE 0.45;

===WHERE CLAUSE====
select * from PERSON where ADDRESS = 'CA' OR name>'tina3';
select * from PERSON TABLESAMPLE 0.49 where ADDRESS = 'CA' OR name>'tina3';
select * from PERSON TABLESAMPLE 0.49 where ADDRESS = 'CA' OR name>'tina3' LIMIT 1;


===Wired Table===
select * from LOCAL_ADDRESS TABLESAMPLE 0.79;
select * from SYSTEM.STATS TABLESAMPLE 0.41;


===CORNER CASE===
select * from PERSON TABLESAMPLE 0;
select * from PERSON TABLESAMPLE 1.45;
select * from PERSON TABLESAMPLE kko;


++
++belows are NOT SUPPORTED
++
===Subquery and outter join not supporting===
select * from (select * from PERSON where ADDRESS = 'CA') TABLESAMPE 0.2 where Name > 'tina10'

===AGGREGATION===
select count(*) from PERSON TABLESAMPLE 0.5 LIMIT 2

> 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
>
> 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.3.15#6346)