SORT BY ORDER BY CLUSTER BY DISTRIBUTE BY

Question

Accepted Answer

SORT BY, ORDER BY, CLUSTER BY, and DISTRIBUTE BY are SQL clauses used for data sorting and partitioning.

SORT BY is used to sort the result set in ascending or descending order based on one or more columns.
ORDER BY is used to sort the result set in ascending or descending order based on one or more columns. It is similar to SORT BY but can be used with other clauses like LIMIT and OFFSET.
CLUSTER BY is used to group data based on a specific column. It is used to improve query performance by reducing the amount of data that needs to be scanned.
DISTRIBUTE BY is used to distribute data across nodes in a cluster based on a specific column. It is used to improve query performance by reducing data shuffling between nodes.

Top Cognizant Associate Data Engineer interview questions & answers