...
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.
...