James, See if sampling <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling>is what you need
On Wed, Mar 28, 2012 at 5:53 PM, James Newhaven <james.newha...@gmail.com>wrote: > I am trying to write a query that will return the first 5% of rows in a > table. > > I've struggled with this for quite a while and can't figure out a command > that works in Hive. > > Has anyone done this? > > Thanks, > James >
