Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 82F1F17397 for ; Thu, 5 Feb 2015 09:51:16 +0000 (UTC) Received: (qmail 84924 invoked by uid 500); 5 Feb 2015 09:51:14 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 84859 invoked by uid 500); 5 Feb 2015 09:51:14 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 84849 invoked by uid 99); 5 Feb 2015 09:51:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Feb 2015 09:51:14 +0000 X-ASF-Spam-Status: No, hits=3.5 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLY,HTML_FONT_LOW_CONTRAST,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of r7raul1984@163.com designates 220.181.12.13 as permitted sender) Received: from [220.181.12.13] (HELO m12-13.163.com) (220.181.12.13) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Feb 2015 09:51:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Mime-Version:Message-ID; bh=Nf0tb +GaF4ghxTpcy4RIjnmF9g/Ajr1oYruTTbv1Qlw=; b=LKETldytK72UA+95Ulm3V EfA5pOf5jb/vVPmO2A1wjnPDPlvlhvGv1hWfdlGRQt2MD65mAedKpfoZD+AM/eC0 p40dcivJ2ltYrV4lMbvJXoEZzfcNITvsyHbk02szvhrAAL/hv/18IJIUZ+xYneE8 GKLvDz6u4OcOp4cP828718= Received: from NHSH1MNB72514 (unknown [203.110.175.179]) by smtp9 (Coremail) with SMTP id DcCowAD3ft_0PNNUIYU1AA--.5424S2; Thu, 05 Feb 2015 17:50:45 +0800 (CST) Date: Thu, 5 Feb 2015 17:50:45 +0800 From: "r7raul1984@163.com" To: user Subject: Re: Re: How to query data by page in Hive? References: <201502051601086504851@163.com>, X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7, 2, 5, 136[cn] Mime-Version: 1.0 Message-ID: <201502051750442566702@163.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart786358146506_=----" X-CM-TRANSID: DcCowAD3ft_0PNNUIYU1AA--.5424S2 X-Coremail-Antispam: 1Uf129KBjvdXoWrZw17Gr17WF45AF1rXF1rCrg_yoW3Crc_Wr nrJFnayayF9a4kGFZ3trWfJr1rXayjkw1Dta4UXrsIva4kArn5Za4kKrZruF1SyrnxXFn3 Wr13ZF45t34avjkaLaAFLSUrUUUUUb8apTn2vfkv8UJUUUU8Yxn0WfASr-VFAUDa7-sFnT 9fnUUvcSsGvfC2KfnxnUUI43ZEXa7IUUE4EJUUUUU== X-Originating-IP: [203.110.175.179] X-CM-SenderInfo: 3uxut3borzmki6rwjhhfrp/xtbBZBWXzlQGxuenCgAAs2 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_001_NextPart786358146506_=---- Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 VGhhbmsgeW91IERldm9wYW0hIENvdWxkIHlvdSBzaG93IG1lIGEgIGV4YW1wbGU/IA0KDQoNCg0K cjdyYXVsMTk4NEAxNjMuY29tDQogDQpGcm9tOiBEZXZvcGFtIE1pdHRyYQ0KRGF0ZTogMjAxNS0w Mi0wNSAxODowNQ0KVG86IHVzZXJAaGl2ZS5hcGFjaGUub3JnDQpTdWJqZWN0OiBSZTogSG93IHRv IHF1ZXJ5IGRhdGEgYnkgcGFnZSBpbiBIaXZlPw0KWW91IG1heSB3YW50IHRvIHVzZSBhIFJPV19O VU1CRVIgT1IgUkFOSyAvIERFTlNFIFJBTksgaW4gdGhlIGlubmVyIHF1ZXJ5IGFuZCB0aGVuIHNl bGVjdCBvbmx5IGEgc3Vic2V0IG9mIGl0IGluIHRoZSBvdXRlciBxdWVyeSB0byBjb250cm9sIHBh Z2luYXRpb24uIEJhc2VkIG9uIHlvdXIgbmVlZCwgeW91IG1heSB3YW50IHRvIG9yZGVyIHRoZSBy ZWNvcmRzIGFzIHdlbGwgLi4NCg0KQWx0ZXJuYXRpdmVseSB5b3UgbWF5IHdhbnQgdG8gdXNlIENU RShodHRwczovL2N3aWtpLmFwYWNoZS5vcmcvY29uZmx1ZW5jZS9kaXNwbGF5L0hpdmUvQ29tbW9u K1RhYmxlK0V4cHJlc3Npb24pIGZvciBzZWxlY3RpbmcgdGhlIGRhdGEgaW4gb25lIGdvIGFuZCB0 aGVuIHVzZSByb3cgbnVtYmVyIHRvIHNlbGVjdCBhcyBpbiBwcmV2aW91cyBjYXNlLg0KDQpyZWdh cmRzDQpEZXZvcGFtDQoNCk9uIFRodSwgRmViIDUsIDIwMTUgYXQgMTozMSBQTSwgcjdyYXVsMTk4 NEAxNjMuY29tIDxyN3JhdWwxOTg0QDE2My5jb20+IHdyb3RlOg0KSGVsbG8sDQogICAgICAgICBI b3cgdG8gcXVlcnkgZGF0YSBieSBwYWdlIGluIEhpdmU/DQoNCmhpdmU+IHNlbGVjdCAqIGZyb20g dV9kYXRhIGEgbGltaXQgMSwyOyANCkZBSUxFRDogUGFyc2VFeGNlcHRpb24gbGluZSAxOjMxIG1p c3NpbmcgRU9GIGF0ICcsJyBuZWFyICcxJyANCg0KDQoNCnI3cmF1bDE5ODRAMTYzLmNvbQ0KDQoN Cg0KLS0gDQpEZXZvcGFtIE1pdHRyYQ0KTGlmZSBhbmQgUmVsYXRpb25zIGFyZSBub3QgYmluYXJ5 DQo= ------=_001_NextPart786358146506_=---- Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =0A
= Thank you Devopam! Could you show me a =  example? 
=0A

=0A
= r7raul1984@163.com
=0A
 
Date: 2015-02-05 18:05<= /div>
Subject: Re: How to query data by p= age in Hive?
You may want to use a ROW_NUMBER OR RANK / DENSE RANK = in the inner query and then select only a subset of it in the outer query = to control pagination. Based on your need, you may want to order the recor= ds as well ..

Alternatively you may want to use CTE(https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expr= ession) for selecting the data in one go and then use row number to se= lect as in previous case.

regards
Devop= am

On= Thu, Feb 5, 2015 at 1:31 PM, r7raul= 1984@163.com <r7raul1984@163.com> wrote:
=0A
Hello,
         How to query data by page in Hive?
<= span style=3D"background-color:rgba(0,0,0,0);font-size:10.5pt;line-height:= 1.5">
= hive> select * from u_data a limit 1,2; 
FAILED: ParseException= line 1:31 missing EOF at ',' near '1' 
=0A
=0A
<= span>
r7raul1984@163.com
=0A

<= br clear=3D"all">

--
Devo= pam Mittra
Life and Relations are not binary
=0A=0A=0A ------=_001_NextPart786358146506_=------