...
Code Block |
---|
SELECT page_views.* FROM page_views JOIN dim_users ON (page_views.user_id = dim_users.id AND page_views.date >= '2008-03-01' AND page_views.date <= '2008-03-31') |
- See also Partition Filter Syntax.
- See also Group By.
- See also Sort By / Cluster By / Distribute By / Order By.
...
The first argument specifies the offset of the first row to return (as of Hive 2.0.0) and the second specifies the maximum number of rows to return.
A When a single argument is given, it stands for the maximum number of rows and the offset defaults to 0.
...
Code Block |
---|
SELECT * FROM customers ORDER BY createdcreate_date LIMIT 5 |
The following query returns the first 5 3rd to the 7th customers to be created
Code Block |
---|
SELECT * FROM customers ORDER BY createdcreate_date LIMIT 2,5 |
REGEX Column Specification
...