How to use Order By in HIVE Query?

In Hive, the ORDER BY clause is used to sort the query results by one or more columns in ascending or descending order. The syntax for using ORDER BY in Hive is as follows:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...

Here, column1, column2, etc. represent the columns by which you want to sort the result set. You can specify the sorting order for each column by using the optional ASC (ascending) or DESC (descending) keywords.

For example, suppose you have a table named employees with columns id, name, and salary. To retrieve the records from this table sorted by the salary column in descending order, you can use the following query:

SELECT id, name, salary
FROM employees
ORDER BY salary DESC;

This will return the records sorted by the salary column in descending order.