04-Timeseries

Fun: csum()

1. Basic query for input different params

2. Query on super/child/normal table

3. Support types

4. Error cases

5. Query with where condition

6. Query with group/partition/order by

7. Query with tags

8. Query with join/union/nest/interval

9. Query with limit/slimit/offset/soffset

10. Check null value

11. Check boundary values

path: cases/11-Functions/04-Timeseries/test_fun_ts_csum.py

Fun: derivative()

1. Basic query for different params

2. Query on super/child/normal table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

7. Query with sub query

8. Query with function nested

9. Query with limit/slimit/offset/soffset

10. Check null value

path: cases/11-Functions/04-Timeseries/test_fun_ts_derivative.py

Fun: diff()

1. Sim case for LIKE, timestamp comparisons, and ordinary column comparisons.

2. Basic query for input different params

3. Query on super/child/normal table

4. Support types

5. Error cases

6. Query with where condition

7. Query with group/partition/order by

8. Query with tags

9. Query with join/union/nest/interval

10. Query with limit/slimit/offset/soffset

11. Check null value

path: cases/11-Functions/04-Timeseries/test_fun_ts_diff.py

Fun: interp()

1. Basic query for different params

2. Query on super/child/normal/empty table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

7. Query with sub query

8. Query with union/join/fill/every/range/interval

9. Select _irowts, _irowts_origin, _isfilled

10. Check null value

11. Single INTERP query covering multiple columns

path: cases/11-Functions/04-Timeseries/test_fun_ts_interp.py

Fun: irate()

1. Basic query for input different params

2. Query on super/child table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/order by

7. Query with sub query

8. Query with function nested

9. Check null value

path: cases/11-Functions/04-Timeseries/test_fun_ts_irate.py

Fun: mavg()

1. Basic query for different params

2. Query on super/child/normal table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

7. Query with sub query

8. Query with function nested

9. Query with limit/slimit/offset/soffset

10. Check null value

path: cases/11-Functions/04-Timeseries/test_fun_ts_mavg.py

Fun: sample()

1. Basic query for different params

2. Query on super/child/normal table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

8. Query with union/join/range/interval

9. Query with null value

10. Query with big data

path: cases/11-Functions/04-Timeseries/test_fun_ts_sample.py

Fun: statecount()

1. Basic query for different params

2. Query on super/child/normal table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

7. Query with sub query

8. Query with union/join

9. Query with unit time

10. Check null value

11. Boundary values

path: cases/11-Functions/04-Timeseries/test_fun_ts_statecount.py

Fun: stateduration()

1. Basic query for different params

2. Query on super/child/normal table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group/order by

7. Query with sub query

8. Query with union/join

9. Query with unit time

10. Check null value

11. Boundary values

path: cases/11-Functions/04-Timeseries/test_fun_ts_stateduration.py

Fun: twa()

1. Basic query for different params

2. Query on super/child table

3. Support data types

4. Error cases

5. Query with where condition

6. Query with partition/group by

7. Query with sub query

8. Query with union

9. Check null value

path: cases/11-Functions/04-Timeseries/test_fun_ts_twa.py