Community
Training
Partners
Support
Cloudera Community
Cloudera Community
Announcements
Product Announcements
Community Announcements
What's New @ Cloudera
Support
Support Questions
Community Articles
Using the Community
Getting Started
Intros and Suggestions
Community Tips
Groups
Cloudera Data Analytics (CDA)
Sign In
prasoon6k
New Contributor
View All
Cloudera Community
About prasoon6k
Member since
10-06-2016
2
Posts
1
Kudos Received
0
Solutions
Latest Contributions by prasoon6k
Topics prasoon6k has Participated In
Latest Contributions by prasoon6k
Re: Select nth row in hive
by
prasoon6k
in
Support Questions
10-07-2016
05:26 AM
10-07-2016
05:26 AM
Hi Vaibhav, Which version of hive you are working with? Please check below link https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expression
... View more
Re: Select nth row in hive
by
prasoon6k
in
Support Questions
10-06-2016
10:47 AM
1 Kudo
10-06-2016
10:47 AM
1 Kudo
please use below query with t as ( select row_number() over (order by Codes) as RowNum, ID,Codes ) select * from t where RowNum=3;
... View more
Contact Me
Online
Offline
Last Visited
07-25-2018
11:22 AM
Community Statistics
Member Since
10-06-2016
10:43 AM
Last Visited
07-25-2018
11:22 AM
Posts
2
Kudos received
1
