Q. In Hive, what is the primary purpose of the ORDER BY clause in a SELECT statement?

• (A) Group records based on a column
• (B) Sort the result set based on specified columns
• (C) Join records from multiple tables
• (D) None of the above