1. Categories >> Software >> Big Data >> Hadoop >> Apache Hive
  2. Suggest New Category

When should we use SORT BY instead of ORDER BY?

Question Posted / nikhil kumar


When should we use SORT BY instead of ORDER BY?..

Answer / Satya Nand Mishra

You should use SORT BY instead of ORDER BY in Hive when you want to sort the result in a distributed fashion, which can lead to better performance for large datasets. However, SORT BY does not return immediate results like ORDER BY and requires additional memory.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

What does meta-store means in hive?

1 Answers  

Mention what is HiveServer2 (HS2)?

1 Answers  

When to choose "Internal Table" in Hive?

1 Answers  

What are the default record and field delimiter used for hive text files?

1 Answers  

What is CTAS Table in Hive?

1 Answers  

What are the different Primitive Data Types available in Hive?

1 Answers  

How would you drop a table in Hive?

1 Answers  

What are hive operators and its types?

1 Answers  

What is the precedence order of hive configuration?

1 Answers  

How to add the partition in existing table without the partition table?

1 Answers  

Why do we perform partitioning in Hive?

1 Answers  

What are the types of tables in Hive?

1 Answers  

For more Apache Hive Interview Questions Click Here
Categories