Hello Debopam Please mail.me the queries as well for rank/dense rank. TIA. Regards Swagatika On Feb 5, 2015 3:51 PM, "Devopam Mittra" <devo...@gmail.com> wrote:
> Please provide a valid table structure and the columns you wish to pick > and I shall email you the query directly > > > regards > Devopam > > On Thu, Feb 5, 2015 at 3:20 PM, r7raul1...@163.com <r7raul1...@163.com> > wrote: > >> Thank you Devopam! Could you show me a example? >> >> ------------------------------ >> r7raul1...@163.com >> >> >> *From:* Devopam Mittra <devo...@gmail.com> >> *Date:* 2015-02-05 18:05 >> *To:* user@hive.apache.org >> *Subject:* Re: How to query data by page 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 records as well .. >> >> Alternatively you may want to use CTE( >> https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expression) >> for selecting the data in one go and then use row number to select as in >> previous case. >> >> regards >> Devopam >> >> On Thu, Feb 5, 2015 at 1:31 PM, r7raul1...@163.com <r7raul1...@163.com> >> wrote: >> >>> Hello, >>> How to query data by page in Hive? >>> >>> hive> select * from u_data a limit 1,2; >>> FAILED: ParseException line 1:31 missing EOF at ',' near '1' >>> >>> ------------------------------ >>> r7raul1...@163.com >>> >> >> >> >> -- >> Devopam Mittra >> Life and Relations are not binary >> >> > > > -- > Devopam Mittra > Life and Relations are not binary >
