Looking for hive Answers? Try Ask4KnowledgeBase
Looking for hive Keywords? Try Ask4Keywords

hiveSELECT Statement


Syntax

  • SELECT [ALL | DISTINCT] select_expr, select_expr, select_expr, ….
  • FROM table_reference
  • [WHERE where_condition]
  • [GROUP BY col_list]
  • [HAVING having condition]
  • [ORDER BY col_list]
  • [LIMIT n]