| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !where_before -- |
| 1 A 0 apple |
| 1 A 1 banana |
| 3 A 0 red |
| 3 A 1 green |
| 3 A 2 blue |
| |
| -- !where_after -- |
| 1 0 apple |
| 3 0 red |
| 3 1 green |
| 3 2 blue |
| 4 0 one |
| |
| -- !where_combined -- |
| 1 A apple |
| 2 B cat |
| 3 A red |
| |
| -- !join_inner -- |
| 1 1 one false |
| 1 2 two true |
| 1 3 three false |
| 2 2 two true |
| 2 3 three false |
| 2 4 four true |
| |
| -- !join_left -- |
| 1 1 one |
| 1 2 two |
| 2 5 five |
| 2 6 \N |
| 2 7 \N |
| |
| -- !join_self -- |
| 1 20 2 20 |
| 1 30 2 30 |
| |
| -- !group_by_udtf -- |
| apple 2 |
| banana 2 |
| cat 2 |
| cherry 1 |
| dog 1 |
| |
| -- !group_by_mixed -- |
| animal cat 2 |
| animal dog 1 |
| fruit apple 2 |
| fruit banana 2 |
| fruit cherry 1 |
| |
| -- !group_by_having -- |
| apple 2 |
| banana 2 |
| cat 2 |
| |
| -- !group_by_multi_agg -- |
| 1 5 1 5 15 3.0 |
| 2 5 3 7 25 5.0 |
| 3 3 10 12 33 11.0 |
| |
| -- !order_by_udtf -- |
| 2 Bob 95 |
| 1 Alice 92 |
| 2 Bob 90 |
| 2 Bob 88 |
| 3 Charlie 88 |
| |
| -- !order_by_mixed -- |
| 1 Alice 2 78 |
| 1 Alice 1 92 |
| 1 Alice 0 85 |
| 2 Bob 2 95 |
| 2 Bob 1 88 |
| 2 Bob 0 90 |
| 3 Charlie 2 88 |
| 3 Charlie 1 82 |
| 3 Charlie 0 70 |
| |
| -- !limit_only -- |
| 1 85 |
| 1 92 |
| 1 78 |
| |
| -- !top_n_pattern -- |
| 1 Alice 92 |
| 1 Alice 85 |
| 2 Bob 95 |
| 2 Bob 90 |
| 3 Charlie 88 |
| 3 Charlie 82 |
| |
| -- !subquery_in -- |
| 1 A,B,C |
| 3 A,C,E |
| |
| -- !subquery_from -- |
| C 3 |
| A 2 |
| B 2 |
| D 1 |
| E 1 |
| |
| -- !subquery_nested -- |
| C 3 |
| A 2 |
| B 2 |
| |
| -- !distinct_udtf -- |
| blue |
| green |
| red |
| yellow |
| |
| -- !count_distinct -- |
| 4 |
| |
| -- !union_all -- |
| 1 X |
| 1 Y |
| 2 Y |
| 2 Z |
| |
| -- !union_distinct -- |
| X |
| Y |
| Z |
| |
| -- !array_filter -- |
| 1 3 |
| 2 3 |
| 2 4 |
| 2 5 |
| 3 3 |
| 3 4 |
| |
| -- !array_aggregate -- |
| 1 3 6 2.0 |
| 2 4 14 3.5 |
| 3 2 7 3.5 |
| |
| -- !window_function -- |
| 1 A 10 1 100 |
| 2 A 15 2 100 |
| 1 A 20 3 100 |
| 2 A 25 4 100 |
| 1 A 30 5 100 |
| 3 B 5 1 30 |
| 3 B 10 2 30 |
| 3 B 15 3 30 |
| |
| -- !case_when -- |
| 1 5 small |
| 1 15 medium |
| 1 25 large |
| 2 10 medium |
| 2 20 large |
| 2 30 large |
| |
| -- !nested_2level -- |
| 1 1,2 1 |
| 1 1,2 2 |
| 1 3 3 |
| 2 4,5 4 |
| 2 4,5 5 |
| |
| -- !parallel_lateral -- |
| 1 A X |
| 1 A Y |
| 1 B X |
| 1 B Y |
| 2 C Z |
| |
| -- !nested_join -- |
| 1 soccer 10 |
| 1 tennis 8 |
| 1 pizza 5 |
| 2 rock 9 |
| |
| -- !nested_groupby -- |
| 1 3 450 |
| 2 3 650 |
| |
| -- !nested_3level -- |
| 1 0 A |
| 1 0 B |
| 1 0 C |
| 1 1 D |
| 1 1 E |
| 1 2 F |
| |
| -- !nested_array_expansion -- |
| 1 1 10 |
| 1 1 20 |
| 1 2 30 |
| 2 1 40 |
| 2 1 50 |
| |
| -- !nested_multifilter -- |
| 1 \N 20 |
| 1 \N 30 |
| 1 \N 40 |
| 2 \N 50 |
| 2 \N 60 |
| |
| -- !nested_distinct -- |
| blue |
| green |
| red |
| yellow |
| |
