The LIMIT clause applied to a select query
A - Executes the entire query before the LIMIT clause
B - Hive fetches one row at a time until it gets the required limit.
C - Creates a temporary file and stores the query result their
D - Does a random sampling on the rows