Thanks for the response! This works as expected now!
On Thu, Dec 10, 2015 at 10:32 AM, Nicholas Hakobian <
nicholas.hakob...@rallyhealth.com> wrote:
> Last_value and lag are not aggregate functions. They are best thought
> of as streaming windowing functions. The last_value function picks the
> l
Last_value and lag are not aggregate functions. They are best thought
of as streaming windowing functions. The last_value function picks the
last value over your window and applies it to every row in your select
statement. Similarly, lag over your window will lag that column by the
specified number
]
Sent: Thursday, December 10, 2015 10:21 AM
To: user@hive.apache.org
Subject: Help With Hive Windowing
I am attempting to run a simple query over a table with website click data
using last_value and lag functions to get the last two times we saw URL's being
hit by specific bots. The table
I am attempting to run a simple query over a table with website click data
using last_value and lag functions to get the last two times we saw URL's
being hit by specific bots. The table I am querying has the following schema
Table Schema
URL
HIT_TIME
USER_AGENT
MONTH
DAY
Created as an unpartitio
