Return-Path: <issues-return-64518-archive-asf-public=cust-asf.ponee.io@flink.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 75373200B66
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Thu,  4 Aug 2016 04:10:04 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 73D8B160A8C; Thu,  4 Aug 2016 02:10:04 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id BBF8D160A86
	for <archive-asf-public@cust-asf.ponee.io>; Thu,  4 Aug 2016 04:10:03 +0200 (CEST)
Received: (qmail 53528 invoked by uid 500); 4 Aug 2016 02:10:03 -0000
Mailing-List: contact issues-help@flink.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@flink.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@flink.apache.org>
List-Post: <mailto:issues@flink.apache.org>
List-Id: <issues.flink.apache.org>
Reply-To: dev@flink.apache.org
Delivered-To: mailing list issues@flink.apache.org
Received: (qmail 53519 invoked by uid 99); 4 Aug 2016 02:10:03 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Aug 2016 02:10:02 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 87036C012D
	for <issues@flink.apache.org>; Thu,  4 Aug 2016 02:10:02 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: -5.265
X-Spam-Level: 
X-Spam-Status: No, score=-5.265 tagged_above=-999 required=6.31
	tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5,
	RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01,
	RP_MATCHES_RCVD=-1.245] autolearn=disabled
Received: from mx2-lw-eu.apache.org ([10.40.0.8])
	by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024)
	with ESMTP id LcdYgbUl_SZB for <issues@flink.apache.org>;
	Thu,  4 Aug 2016 02:10:00 +0000 (UTC)
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with SMTP id 8EF275F4EA
	for <issues@flink.incubator.apache.org>; Thu,  4 Aug 2016 02:09:59 +0000 (UTC)
Received: (qmail 53460 invoked by uid 99); 4 Aug 2016 02:09:58 -0000
Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Aug 2016 02:09:58 +0000
Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33)
	id 845E6E3839; Thu,  4 Aug 2016 02:09:58 +0000 (UTC)
From: gallenvara <git@git.apache.org>
To: issues@flink.incubator.apache.org
Reply-To: issues@flink.incubator.apache.org
References: <git-pr-2282-flink@git.apache.org>
In-Reply-To: <git-pr-2282-flink@git.apache.org>
Subject: [GitHub] flink pull request #2282: [FLINK-3940] [table] Add support for ORDER BY OFFS...
Content-Type: text/plain
Message-Id: <20160804020958.845E6E3839@git1-us-west.apache.org>
Date: Thu,  4 Aug 2016 02:09:58 +0000 (UTC)
archived-at: Thu, 04 Aug 2016 02:10:04 -0000

Github user gallenvara commented on a diff in the pull request:

    https://github.com/apache/flink/pull/2282#discussion_r73452976
  
    --- Diff: docs/apis/table.md ---
    @@ -606,6 +606,28 @@ Table result = in.orderBy("a.asc");
           </td>
         </tr>
     
    +    <tr>
    +      <td><strong>Offset</strong></td>
    +      <td>
    +        <p>Similar to a SQL OFFSET clause. Returns rows from offset position. It is technically part of the ORDER BY clause.</p>
    +{% highlight java %}
    +Table in = tableEnv.fromDataSet(ds, "a, b, c");
    +Table result = in.orderBy("a.asc").offset(3);
    +{% endhighlight %}
    +      </td>
    +    </tr>
    +    
    +    <tr>
    +      <td><strong>Fetch</strong></td>
    +      <td>
    +        <p>Similar to a SQL FETCH clause. Returns a set number of rows. FETCH can’t be used by itself, it is used in conjunction with OFFSET.</p>
    --- End diff --
    
    Make sense, thanks all.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---