HiveQL SELECT Statement
Jump to navigation
Jump to search
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):
- See: Data Manipulation Query, SQL Query.