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