Github user myui commented on the issue:

    https://github.com/apache/incubator-hivemall/pull/135
  
    ```sql
    create temporary function moving_avg as 
'hivemall.statistics.MovingAverageUDTF';
    
    select moving_avg(x, 3) from (select explode(array(1,2,3,4,5,6,7)) as x) 
series;
    select moving_avg(x, 3) from (select 
explode(array(1.0,2.0,3.0,4.0,5.0,6.0,7.0)) as x) series;
    ```
    
    |avg|
    |:-:|
    |1.0|
    |1.5|
    |2.0|
    |3.0|
    |4.0|
    |5.0|
    |6.0|



---

Reply via email to