Percentage of rows in a Hive Table

[James Newhaven]

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