HiveQL SELECT Statement

A HiveQL SELECT Statement is a SQL SELECT statement expressed in HiveQL and against a Hive table.

• Context:
  • It can (typically) be an Analytic Data Query Statement.
  • …
• Example(s):
  • SELECT * FROM table WHERE DATEDIFF(FROM_UNIXTIME( UNIX_TIMESTAMP()), event_date) <= 7
  • SELECT * FROM table WHERE TRIM(REGEXP_REPLACE(LOWER(html_substring),'<.+?>',)) = 'term X'
• Counter-Example(s):
  • a HiveQL Data Manipulation Statement.
  • a HiveQL Data Definition Statement.
  • MySQL Query.
  • Transact-SQL Query.
  • Cassandra Query.
• See: Data Manipulation Query, SQL Query.

---

---