hivemall-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myui <...@git.apache.org>
Subject [GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions
Date Wed, 04 Apr 2018 09:04:00 GMT
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|



---

Mime
View raw message