in Big Data | Hadoop by
Q:
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

1 Answer

0 votes
by
Executes the entire query before the LIMIT clause

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
+1 vote
asked May 7, 2020 in Big Data | Hadoop by GeorgeBell
...