Any solution for the below scenario I have a scenario like below. can anyone please provide some info. I have the below table. i tried doing this using join with lag and lead function but its not giving the expected result. I'm just not getting any clue how to implement the solution for this. name date amount abc 04/06/2018 100 abc 04/06/2018 200 abc 04/13/2018 300 now the output i needed is below. name date amount abc 04/06/2018 100 abc 04/06/2018 200 abc 04/13/2018 100 abc 04/13/2018 200 abc 04/13/2018 300 so here 300 is the new value and 100,200 from mon will also shown for tue. Do we have any way to do this in hive. Any help will be greatly appreciated. ... View more

Hi Tim,   Thanks for the solution but i'm not able to understand it prorperly. Can you provide a query with the below issue description. I tried using your solution query but wasn't able to map the col's. So i have a table buyers and its has one col 'id' for which every time an insert happens i want that col to get incremental value's for each insert. Table Buyers Col: id,name,created on Can you provide a sample query for this table. It will be really helpful to me as i'm stcuk on this from long time. ... View more