What is the syntax for HiveQL SELECT Statement

Question

Can anyone suggest what can be the syntax for HiveQL SELECT statement?

Answer 1

Hey, 

You can use this  syntax below:

1. SELECT [ALL | DISTINCT] select_expr, select_expr, ...
2. FROM table_reference
3. [WHERE where_condition]
4. [GROUP BY col_list]
5. [HAVING having_condition]
6. [CLUSTER BY col_list | [DISTRIBUTE BY col_list] [SORT BY col_list]]
7. [LIMIT number];