[ 
https://issues.apache.org/jira/browse/HIVE-13205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179454#comment-15179454
 ] 

Rahul commented on HIVE-13205:
------------------------------

I have tried many thing, but not able to solve the issue. In the mean while can 
you please suggest some other method to fill all null with the last known value 
in the same column. Can we achieve this using lag().

> Job with last_value() function keep running forever.
> ----------------------------------------------------
>
>                 Key: HIVE-13205
>                 URL: https://issues.apache.org/jira/browse/HIVE-13205
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Rahul
>
> Hi,
> I am running following query to fill all null with the last known value in 
> the column:
> Select price,time, id,last_value(price,true) over (partition by id order by 
> time) as LatestPrice from table;
> For few records, the query is running successfully. But for large number of 
> records (2 Bn), the query keep running forever.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to