Github user myui commented on the issue:

    https://github.com/apache/incubator-hivemall/pull/135
  
    ```sql
    select generate_series(2,4);
    
    value
    2
    3
    4
    
    select generate_series(5,1,-2);
    
    value
    5
    3
    1
    
    select generate_series(4,3);
    
    (no return)
    
    select date_add(current_date(),value) as `date`,value from (select 
generate_series(1,3)) t;
    
    date    value
    2018-04-21      1
    2018-04-22      2
    2018-04-23      3
    
    WITH input as (
     select 1 as c1, 10 as c2, 3 as step
     UNION ALL
     select 10, 2, -3
    )
    select generate_series(c1, c2, step) as series from input;
    
    series
    1
    4
    7
    10
    10
    7
    4
    ```


---

Reply via email to