Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Find TOP 10 using HiveQL


Copy link to this message
-
Find TOP 10 using HiveQL
When I run this query,

SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer_id, created_time DESC;
I always get error as-

*FAILED: Parse Error: line 1:7 cannot recognize input 'TOP' in select
expression*

Is there any way around to use TOP 10 or something similar that will work
in HiveQL?

*Raihan Jamal*