AdamGS opened a new issue, #20078: URL: https://github.com/apache/datafusion/issues/20078
When running [benchmarks](https://github.com/vortex-data/vortex/pull/6169#issuecomment-3806652223) on large AWS metal boxes, I've noticed that some queries become significantly slower (this one ~8x slower for Vortex, ~10x slower of Parquet) at core counts. This issue also reproduces locally on my laptop by adjusting `DATAFUSION_EXECUTION_TARGET_PARTITIONS`, so I suspect that's mostly related to how the plan is partitioned and planned. Initial profiling showed that most of the time is actually spent in `PhysicalExprSimplifier::simplify`, I'm going to dump some observations here as I'm reading through the codebase: 1. When changing `target_partitions` from 14 to 128, the predicate becomes much bigger (see below). 2. The current repartitioning logic can potentially create a lot of partitions even for relatively small files. The table this predicates refers to is `store_sales`, which is about 100MB of vortex/120MB of parquet, splitting that into 128 seems likely to be wasteful, increasing the plan's overhead significantly. I saw https://github.com/apache/datafusion/pull/19073 is trying to address some of that, but I'm not sure quite the same thing. 3. Profiling shows that most of the query's time ends up in `FilePruner::should_prune`, more specifically in `PhysicalExprSimplifier::simplify`, which I assume is caused by the much larger predicates (I have a small PR on the way that will hopefully make some difference there, will post results when I have them). 4. A key correlation here is that more partitions => more `FilePruner` instances calling `simplify` again and again, which ## Debug artifacts ### Profiles Taken on my laptop, setting `target_partitions` explicitly, and running our benchmarks on Vortex, but I'm glad to generate the same thing with Parquet, I don't think there's much of a difference. - [16 partitions](https://share.firefox.dev/4t6jPaE) - [128 partitions](https://share.firefox.dev/4tgCYqD) ### Predicates I've used the `Display` fmt, is there a better one that people like for discussing/debugging? <details> <summary>14 partitions</summary> ``` ss_store_sk@7 IS NULL AND DynamicFilter [ CASE hash_repartition % 14 WHEN 0 THEN ss_item_sk@2 >= 52 AND ss_item_sk@2 <= 17992 AND hash_lookup WHEN 1 THEN ss_item_sk@2 >= 1 AND ss_item_sk@2 <= 18000 AND hash_lookup WHEN 2 THEN ss_item_sk@2 >= 10 AND ss_item_sk@2 <= 17993 AND hash_lookup WHEN 3 THEN ss_item_sk@2 >= 25 AND ss_item_sk@2 <= 17976 AND hash_lookup WHEN 4 THEN ss_item_sk@2 >= 3 AND ss_item_sk@2 <= 17996 AND hash_lookup WHEN 5 THEN ss_item_sk@2 >= 15 AND ss_item_sk@2 <= 17965 AND hash_lookup WHEN 6 THEN ss_item_sk@2 >= 24 AND ss_item_sk@2 <= 17935 AND hash_lookup WHEN 7 THEN ss_item_sk@2 >= 2 AND ss_item_sk@2 <= 17998 AND hash_lookup WHEN 8 THEN ss_item_sk@2 >= 7 AND ss_item_sk@2 <= 17995 AND hash_lookup WHEN 9 THEN ss_item_sk@2 >= 6 AND ss_item_sk@2 <= 17999 AND hash_lookup WHEN 10 THEN ss_item_sk@2 >= 18 AND ss_item_sk@2 <= 17997 AND hash_lookup WHEN 11 THEN ss_item_sk@2 >= 68 AND ss_item_sk@2 <= 17994 AND hash_lookup WHEN 12 THEN ss_item_sk@2 >= 19 AND ss_item_sk@2 <= 1 7986 AND hash_lookup WHEN 13 THEN ss_item_sk@2 >= 4 AND ss_item_sk@2 <= 17990 AND hash_lookup ELSE false END ] AND DynamicFilter [ CASE hash_repartition % 14 WHEN 0 THEN ss_sold_date_sk@0 >= 2415041 AND ss_sold_date_sk@0 <= 2488070 AND hash_lookup WHEN 1 THEN ss_sold_date_sk@0 >= 2415062 AND ss_sold_date_sk@0 <= 2488034 AND hash_lookup WHEN 2 THEN ss_sold_date_sk@0 >= 2415025 AND ss_sold_date_sk@0 <= 2488063 AND hash_lookup WHEN 3 THEN ss_sold_date_sk@0 >= 2415022 AND ss_sold_date_sk@0 <= 2488065 AND hash_lookup WHEN 4 THEN ss_sold_date_sk@0 >= 2415027 AND ss_sold_date_sk@0 <= 2488032 AND hash_lookup WHEN 5 THEN ss_sold_date_sk@0 >= 2415026 AND ss_sold_date_sk@0 <= 2488061 AND hash_lookup WHEN 6 THEN ss_sold_date_sk@0 >= 2415024 AND ss_sold_date_sk@0 <= 2488068 AND hash_lookup WHEN 7 THEN ss_sold_date_sk@0 >= 2415043 AND ss_sold_date_sk@0 <= 2488066 AND hash_lookup WHEN 8 THEN ss_sold_date_sk@0 >= 2415036 AND ss_sold_date_sk@0 <= 2488053 AND hash_lookup WHEN 9 THEN ss_sold_date_sk@0 >= 2415037 AND ss_sold_date_sk@0 <= 2488069 AND hash_lookup WHEN 10 THEN ss_sold_date_sk@0 >= 2415059 AND ss_sold_date_sk@0 <= 2488045 AND hash_lookup WHEN 11 THEN ss_sold_date_sk@0 >= 2415033 AND ss_sold_date_sk@0 <= 2488040 AND hash_lookup WHEN 12 THEN ss_sold_date_sk@0 >= 2415023 AND ss_sold_date_sk@0 <= 2488052 AND hash_lookup WHEN 13 THEN ss_sold_date_sk@0 >= 2415031 AND ss_sold_date_sk@0 <= 2488067 AND hash_lookup ELSE false END ] ``` </details> <details> <summary>128 partitions</summary> ``` ss_store_sk@7 IS NULL AND DynamicFilter [ CASE hash_repartition % 128 WHEN 0 THEN ss_item_sk@2 >= 5 AND ss_item_sk@2 <= 17941 AND hash_lookup WHEN 1 THEN ss_item_sk@2 >= 11 AND ss_item_sk@2 <= 17965 AND hash_lookup WHEN 2 THEN ss_item_sk@2 >= 35 AND ss_item_sk@2 <= 17971 AND hash_lookup WHEN 3 THEN ss_item_sk@2 >= 300 AND ss_item_sk@2 <= 17898 AND hash_lookup WHEN 4 THEN ss_item_sk@2 >= 51 AND ss_item_sk@2 <= 17991 AND hash_lookup WHEN 5 THEN ss_item_sk@2 >= 4 AND ss_item_sk@2 <= 17980 AND hash_lookup WHEN 6 THEN ss_item_sk@2 >= 14 AND ss_item_sk@2 <= 17982 AND hash_lookup WHEN 7 THEN ss_item_sk@2 >= 9 AND ss_item_sk@2 <= 17962 AND hash_lookup WHEN 8 THEN ss_item_sk@2 >= 147 AND ss_item_sk@2 <= 17986 AND hash_lookup WHEN 9 THEN ss_item_sk@2 >= 290 AND ss_item_sk@2 <= 17963 AND hash_lookup WHEN 10 THEN ss_item_sk@2 >= 34 AND ss_item_sk@2 <= 17881 AND hash_lookup WHEN 11 THEN ss_item_sk@2 >= 177 AND ss_item_sk@2 <= 17819 AND hash_lookup WHEN 12 THEN ss_item_sk@2 >= 58 AND ss_item_sk @2 <= 17876 AND hash_lookup WHEN 13 THEN ss_item_sk@2 >= 83 AND ss_item_sk@2 <= 17959 AND hash_lookup WHEN 14 THEN ss_item_sk@2 >= 176 AND ss_item_sk@2 <= 17830 AND hash_lookup WHEN 15 THEN ss_item_sk@2 >= 45 AND ss_item_sk@2 <= 17832 AND hash_lookup WHEN 16 THEN ss_item_sk@2 >= 24 AND ss_item_sk@2 <= 17955 AND hash_lookup WHEN 17 THEN ss_item_sk@2 >= 116 AND ss_item_sk@2 <= 17902 AND hash_lookup WHEN 18 THEN ss_item_sk@2 >= 69 AND ss_item_sk@2 <= 17792 AND hash_lookup WHEN 19 THEN ss_item_sk@2 >= 1 AND ss_item_sk@2 <= 17711 AND hash_lookup WHEN 20 THEN ss_item_sk@2 >= 94 AND ss_item_sk@2 <= 17974 AND hash_lookup WHEN 21 THEN ss_item_sk@2 >= 25 AND ss_item_sk@2 <= 17736 AND hash_lookup WHEN 22 THEN ss_item_sk@2 >= 32 AND ss_item_sk@2 <= 17997 AND hash_lookup WHEN 23 THEN ss_item_sk@2 >= 846 AND ss_item_sk@2 <= 17450 AND hash_lookup WHEN 24 THEN ss_item_sk@2 >= 42 AND ss_item_sk@2 <= 17801 AND hash_lookup WHEN 25 THEN ss_item_sk@2 >= 47 AND ss_item_sk@2 <= 17838 AND hash_lookup WHEN 26 THEN ss_item_sk@2 >= 154 AND ss_item_sk@2 <= 17798 AND hash_lookup WHEN 27 THEN ss_item_sk@2 >= 172 AND ss_item_sk@2 <= 17984 AND hash_lookup WHEN 28 THEN ss_item_sk@2 >= 224 AND ss_item_sk@2 <= 17854 AND hash_lookup WHEN 29 THEN ss_item_sk@2 >= 134 AND ss_item_sk@2 <= 17781 AND hash_lookup WHEN 30 THEN ss_item_sk@2 >= 52 AND ss_item_sk@2 <= 17979 AND hash_lookup WHEN 31 THEN ss_item_sk@2 >= 20 AND ss_item_sk@2 <= 17968 AND hash_lookup WHEN 32 THEN ss_item_sk@2 >= 114 AND ss_item_sk@2 <= 17788 AND hash_lookup WHEN 33 THEN ss_item_sk@2 >= 15 AND ss_item_sk@2 <= 17759 AND hash_lookup WHEN 34 THEN ss_item_sk@2 >= 193 AND ss_item_sk@2 <= 17771 AND hash_lookup WHEN 35 THEN ss_item_sk@2 >= 26 AND ss_item_sk@2 <= 17895 AND hash_lookup WHEN 36 THEN ss_item_sk@2 >= 56 AND ss_item_sk@2 <= 17947 AND hash_lookup WHEN 37 THEN ss_item_sk@2 >= 71 AND ss_item_sk@2 <= 17911 AND hash_lookup WHEN 38 THEN ss_item_sk@2 >= 384 AND ss_item_sk@2 <= 17940 AND hash_lookup WHEN 39 THEN ss_item_sk@2 >= 248 AND ss_item_sk@2 <= 17518 AND hash_lookup WHEN 40 THEN ss_item_sk@2 >= 55 AND ss_item_sk@2 <= 17893 AND hash_lookup WHEN 41 THEN ss_item_sk@2 >= 23 AND ss_item_sk@2 <= 17804 AND hash_lookup WHEN 42 THEN ss_item_sk@2 >= 79 AND ss_item_sk@2 <= 17904 AND hash_lookup WHEN 43 THEN ss_item_sk@2 >= 74 AND ss_item_sk@2 <= 17693 AND hash_lookup WHEN 44 THEN ss_item_sk@2 >= 794 AND ss_item_sk@2 <= 17921 AND hash_lookup WHEN 45 THEN ss_item_sk@2 >= 6 AND ss_item_sk@2 <= 17908 AND hash_lookup WHEN 46 THEN ss_item_sk@2 >= 37 AND ss_item_sk@2 <= 17831 AND hash_lookup WHEN 47 THEN ss_item_sk@2 >= 33 AND ss_item_sk@2 <= 17967 AND hash_lookup WHEN 48 THEN ss_item_sk@2 >= 174 AND ss_item_sk@2 <= 17996 AND hash_lookup WHEN 49 THEN ss_item_sk@2 >= 206 AND ss_item_sk@2 <= 17925 AND hash_lookup WHEN 50 THEN ss_item_sk@2 >= 38 AND ss_item_sk@2 <= 17935 AND hash_lookup WHEN 51 THEN ss_item_sk@2 >= 371 AND ss_item_sk@2 <= 17923 AND hash_lookup WHEN 52 THEN ss_item_sk@2 >= 18 AND ss_item_sk@2 <= 17988 AND ha sh_lookup WHEN 53 THEN ss_item_sk@2 >= 209 AND ss_item_sk@2 <= 17688 AND hash_lookup WHEN 54 THEN ss_item_sk@2 >= 130 AND ss_item_sk@2 <= 17882 AND hash_lookup WHEN 55 THEN ss_item_sk@2 >= 48 AND ss_item_sk@2 <= 17933 AND hash_lookup WHEN 56 THEN ss_item_sk@2 >= 270 AND ss_item_sk@2 <= 17871 AND hash_lookup WHEN 57 THEN ss_item_sk@2 >= 36 AND ss_item_sk@2 <= 17937 AND hash_lookup WHEN 58 THEN ss_item_sk@2 >= 30 AND ss_item_sk@2 <= 17951 AND hash_lookup WHEN 59 THEN ss_item_sk@2 >= 87 AND ss_item_sk@2 <= 17956 AND hash_lookup WHEN 60 THEN ss_item_sk@2 >= 93 AND ss_item_sk@2 <= 17903 AND hash_lookup WHEN 61 THEN ss_item_sk@2 >= 2 AND ss_item_sk@2 <= 17960 AND hash_lookup WHEN 62 THEN ss_item_sk@2 >= 167 AND ss_item_sk@2 <= 17874 AND hash_lookup WHEN 63 THEN ss_item_sk@2 >= 229 AND ss_item_sk@2 <= 17864 AND hash_lookup WHEN 64 THEN ss_item_sk@2 >= 191 AND ss_item_sk@2 <= 17642 AND hash_lookup WHEN 65 THEN ss_item_sk@2 >= 303 AND ss_item_sk@2 <= 17958 AND hash_lookup WHEN 66 THEN ss_ite m_sk@2 >= 46 AND ss_item_sk@2 <= 17944 AND hash_lookup WHEN 67 THEN ss_item_sk@2 >= 140 AND ss_item_sk@2 <= 17999 AND hash_lookup WHEN 68 THEN ss_item_sk@2 >= 10 AND ss_item_sk@2 <= 17916 AND hash_lookup WHEN 69 THEN ss_item_sk@2 >= 41 AND ss_item_sk@2 <= 17966 AND hash_lookup WHEN 70 THEN ss_item_sk@2 >= 190 AND ss_item_sk@2 <= 17865 AND hash_lookup WHEN 71 THEN ss_item_sk@2 >= 101 AND ss_item_sk@2 <= 17732 AND hash_lookup WHEN 72 THEN ss_item_sk@2 >= 100 AND ss_item_sk@2 <= 17800 AND hash_lookup WHEN 73 THEN ss_item_sk@2 >= 57 AND ss_item_sk@2 <= 17526 AND hash_lookup WHEN 74 THEN ss_item_sk@2 >= 85 AND ss_item_sk@2 <= 17905 AND hash_lookup WHEN 75 THEN ss_item_sk@2 >= 135 AND ss_item_sk@2 <= 17637 AND hash_lookup WHEN 76 THEN ss_item_sk@2 >= 111 AND ss_item_sk@2 <= 17247 AND hash_lookup WHEN 77 THEN ss_item_sk@2 >= 225 AND ss_item_sk@2 <= 17969 AND hash_lookup WHEN 78 THEN ss_item_sk@2 >= 245 AND ss_item_sk@2 <= 17992 AND hash_lookup WHEN 79 THEN ss_item_sk@2 >= 200 AND ss_item_s k@2 <= 17970 AND hash_lookup WHEN 80 THEN ss_item_sk@2 >= 16 AND ss_item_sk@2 <= 17915 AND hash_lookup WHEN 81 THEN ss_item_sk@2 >= 153 AND ss_item_sk@2 <= 17708 AND hash_lookup WHEN 82 THEN ss_item_sk@2 >= 73 AND ss_item_sk@2 <= 17890 AND hash_lookup WHEN 83 THEN ss_item_sk@2 >= 711 AND ss_item_sk@2 <= 17977 AND hash_lookup WHEN 84 THEN ss_item_sk@2 >= 21 AND ss_item_sk@2 <= 17851 AND hash_lookup WHEN 85 THEN ss_item_sk@2 >= 28 AND ss_item_sk@2 <= 17938 AND hash_lookup WHEN 86 THEN ss_item_sk@2 >= 50 AND ss_item_sk@2 <= 17975 AND hash_lookup WHEN 87 THEN ss_item_sk@2 >= 196 AND ss_item_sk@2 <= 17985 AND hash_lookup WHEN 88 THEN ss_item_sk@2 >= 7 AND ss_item_sk@2 <= 17811 AND hash_lookup WHEN 89 THEN ss_item_sk@2 >= 54 AND ss_item_sk@2 <= 17852 AND hash_lookup WHEN 90 THEN ss_item_sk@2 >= 120 AND ss_item_sk@2 <= 17972 AND hash_lookup WHEN 91 THEN ss_item_sk@2 >= 121 AND ss_item_sk@2 <= 17929 AND hash_lookup WHEN 92 THEN ss_item_sk@2 >= 39 AND ss_item_sk@2 <= 17957 AND hash_lookup WH EN 93 THEN ss_item_sk@2 >= 198 AND ss_item_sk@2 <= 17841 AND hash_lookup WHEN 94 THEN ss_item_sk@2 >= 82 AND ss_item_sk@2 <= 17987 AND hash_lookup WHEN 95 THEN ss_item_sk@2 >= 254 AND ss_item_sk@2 <= 16900 AND hash_lookup WHEN 96 THEN ss_item_sk@2 >= 53 AND ss_item_sk@2 <= 17839 AND hash_lookup WHEN 97 THEN ss_item_sk@2 >= 80 AND ss_item_sk@2 <= 17896 AND hash_lookup WHEN 98 THEN ss_item_sk@2 >= 92 AND ss_item_sk@2 <= 17930 AND hash_lookup WHEN 99 THEN ss_item_sk@2 >= 137 AND ss_item_sk@2 <= 17998 AND hash_lookup WHEN 100 THEN ss_item_sk@2 >= 288 AND ss_item_sk@2 <= 17993 AND hash_lookup WHEN 101 THEN ss_item_sk@2 >= 29 AND ss_item_sk@2 <= 17745 AND hash_lookup WHEN 102 THEN ss_item_sk@2 >= 160 AND ss_item_sk@2 <= 17943 AND hash_lookup WHEN 103 THEN ss_item_sk@2 >= 13 AND ss_item_sk@2 <= 18000 AND hash_lookup WHEN 104 THEN ss_item_sk@2 >= 19 AND ss_item_sk@2 <= 17981 AND hash_lookup WHEN 105 THEN ss_item_sk@2 >= 97 AND ss_item_sk@2 <= 17584 AND hash_lookup WHEN 106 THEN ss_item_sk@2 >= 133 AND ss_item_sk@2 <= 17945 AND hash_lookup WHEN 107 THEN ss_item_sk@2 >= 202 AND ss_item_sk@2 <= 17939 AND hash_lookup WHEN 108 THEN ss_item_sk@2 >= 3 AND ss_item_sk@2 <= 17949 AND hash_lookup WHEN 109 THEN ss_item_sk@2 >= 64 AND ss_item_sk@2 <= 17964 AND hash_lookup WHEN 110 THEN ss_item_sk@2 >= 89 AND ss_item_sk@2 <= 17924 AND hash_lookup WHEN 111 THEN ss_item_sk@2 >= 27 AND ss_item_sk@2 <= 17857 AND hash_lookup WHEN 112 THEN ss_item_sk@2 >= 84 AND ss_item_sk@2 <= 17802 AND hash_lookup WHEN 113 THEN ss_item_sk@2 >= 675 AND ss_item_sk@2 <= 17758 AND hash_lookup WHEN 114 THEN ss_item_sk@2 >= 171 AND ss_item_sk@2 <= 17995 AND hash_lookup WHEN 115 THEN ss_item_sk@2 >= 113 AND ss_item_sk@2 <= 17812 AND hash_lookup WHEN 116 THEN ss_item_sk@2 >= 67 AND ss_item_sk@2 <= 17690 AND hash_lookup WHEN 117 THEN ss_item_sk@2 >= 149 AND ss_item_sk@2 <= 17717 AND hash_lookup WHEN 118 THEN ss_item_sk@2 >= 72 AND ss_item_sk@2 <= 17594 AND hash_lookup WHEN 119 THEN ss_item_sk@2 >= 223 AND ss_it em_sk@2 <= 17989 AND hash_lookup WHEN 120 THEN ss_item_sk@2 >= 321 AND ss_item_sk@2 <= 17907 AND hash_lookup WHEN 121 THEN ss_item_sk@2 >= 187 AND ss_item_sk@2 <= 17742 AND hash_lookup WHEN 122 THEN ss_item_sk@2 >= 12 AND ss_item_sk@2 <= 17909 AND hash_lookup WHEN 123 THEN ss_item_sk@2 >= 438 AND ss_item_sk@2 <= 17919 AND hash_lookup WHEN 124 THEN ss_item_sk@2 >= 151 AND ss_item_sk@2 <= 17978 AND hash_lookup WHEN 125 THEN ss_item_sk@2 >= 76 AND ss_item_sk@2 <= 17918 AND hash_lookup WHEN 126 THEN ss_item_sk@2 >= 31 AND ss_item_sk@2 <= 17926 AND hash_lookup WHEN 127 THEN ss_item_sk@2 >= 139 AND ss_item_sk@2 <= 17645 AND hash_lookup ELSE false END ] AND DynamicFilter [ CASE hash_repartition % 128 WHEN 0 THEN ss_sold_date_sk@0 >= 2415036 AND ss_sold_date_sk@0 <= 2487967 AND hash_lookup WHEN 1 THEN ss_sold_date_sk@0 >= 2415098 AND ss_sold_date_sk@0 <= 2487958 AND hash_lookup WHEN 2 THEN ss_sold_date_sk@0 >= 2415110 AND ss_sold_date_sk@0 <= 2487996 AND hash_lookup WHEN 3 THEN ss_sold_date _sk@0 >= 2415197 AND ss_sold_date_sk@0 <= 2487990 AND hash_lookup WHEN 4 THEN ss_sold_date_sk@0 >= 2415223 AND ss_sold_date_sk@0 <= 2487954 AND hash_lookup WHEN 5 THEN ss_sold_date_sk@0 >= 2415325 AND ss_sold_date_sk@0 <= 2488066 AND hash_lookup WHEN 6 THEN ss_sold_date_sk@0 >= 2415152 AND ss_sold_date_sk@0 <= 2488058 AND hash_lookup WHEN 7 THEN ss_sold_date_sk@0 >= 2415267 AND ss_sold_date_sk@0 <= 2487999 AND hash_lookup WHEN 8 THEN ss_sold_date_sk@0 >= 2415205 AND ss_sold_date_sk@0 <= 2487946 AND hash_lookup WHEN 9 THEN ss_sold_date_sk@0 >= 2415356 AND ss_sold_date_sk@0 <= 2488059 AND hash_lookup WHEN 10 THEN ss_sold_date_sk@0 >= 2415210 AND ss_sold_date_sk@0 <= 2487892 AND hash_lookup WHEN 11 THEN ss_sold_date_sk@0 >= 2415179 AND ss_sold_date_sk@0 <= 2487919 AND hash_lookup WHEN 12 THEN ss_sold_date_sk@0 >= 2415023 AND ss_sold_date_sk@0 <= 2487897 AND hash_lookup WHEN 13 THEN ss_sold_date_sk@0 >= 2415039 AND ss_sold_date_sk@0 <= 2487899 AND hash_lookup WHEN 14 THEN ss_sold_date_s k@0 >= 2415153 AND ss_sold_date_sk@0 <= 2487860 AND hash_lookup WHEN 15 THEN ss_sold_date_sk@0 >= 2415032 AND ss_sold_date_sk@0 <= 2488062 AND hash_lookup WHEN 16 THEN ss_sold_date_sk@0 >= 2415042 AND ss_sold_date_sk@0 <= 2487931 AND hash_lookup WHEN 17 THEN ss_sold_date_sk@0 >= 2415088 AND ss_sold_date_sk@0 <= 2487937 AND hash_lookup WHEN 18 THEN ss_sold_date_sk@0 >= 2415183 AND ss_sold_date_sk@0 <= 2487936 AND hash_lookup WHEN 19 THEN ss_sold_date_sk@0 >= 2415081 AND ss_sold_date_sk@0 <= 2487994 AND hash_lookup WHEN 20 THEN ss_sold_date_sk@0 >= 2415118 AND ss_sold_date_sk@0 <= 2488043 AND hash_lookup WHEN 21 THEN ss_sold_date_sk@0 >= 2415095 AND ss_sold_date_sk@0 <= 2487859 AND hash_lookup WHEN 22 THEN ss_sold_date_sk@0 >= 2415055 AND ss_sold_date_sk@0 <= 2487640 AND hash_lookup WHEN 23 THEN ss_sold_date_sk@0 >= 2415060 AND ss_sold_date_sk@0 <= 2487783 AND hash_lookup WHEN 24 THEN ss_sold_date_sk@0 >= 2415256 AND ss_sold_date_sk@0 <= 2487785 AND hash_lookup WHEN 25 THEN ss_sold_da te_sk@0 >= 2415268 AND ss_sold_date_sk@0 <= 2488006 AND hash_lookup WHEN 26 THEN ss_sold_date_sk@0 >= 2415027 AND ss_sold_date_sk@0 <= 2488070 AND hash_lookup WHEN 27 THEN ss_sold_date_sk@0 >= 2415091 AND ss_sold_date_sk@0 <= 2487843 AND hash_lookup WHEN 28 THEN ss_sold_date_sk@0 >= 2415065 AND ss_sold_date_sk@0 <= 2487883 AND hash_lookup WHEN 29 THEN ss_sold_date_sk@0 >= 2415104 AND ss_sold_date_sk@0 <= 2488024 AND hash_lookup WHEN 30 THEN ss_sold_date_sk@0 >= 2415096 AND ss_sold_date_sk@0 <= 2487983 AND hash_lookup WHEN 31 THEN ss_sold_date_sk@0 >= 2415367 AND ss_sold_date_sk@0 <= 2487800 AND hash_lookup WHEN 32 THEN ss_sold_date_sk@0 >= 2415509 AND ss_sold_date_sk@0 <= 2488008 AND hash_lookup WHEN 33 THEN ss_sold_date_sk@0 >= 2415064 AND ss_sold_date_sk@0 <= 2488039 AND hash_lookup WHEN 34 THEN ss_sold_date_sk@0 >= 2415070 AND ss_sold_date_sk@0 <= 2487903 AND hash_lookup WHEN 35 THEN ss_sold_date_sk@0 >= 2415279 AND ss_sold_date_sk@0 <= 2488030 AND hash_lookup WHEN 36 THEN ss_sol d_date_sk@0 >= 2415222 AND ss_sold_date_sk@0 <= 2487811 AND hash_lookup WHEN 37 THEN ss_sold_date_sk@0 >= 2415033 AND ss_sold_date_sk@0 <= 2488061 AND hash_lookup WHEN 38 THEN ss_sold_date_sk@0 >= 2415186 AND ss_sold_date_sk@0 <= 2488049 AND hash_lookup WHEN 39 THEN ss_sold_date_sk@0 >= 2415226 AND ss_sold_date_sk@0 <= 2488067 AND hash_lookup WHEN 40 THEN ss_sold_date_sk@0 >= 2415127 AND ss_sold_date_sk@0 <= 2488063 AND hash_lookup WHEN 41 THEN ss_sold_date_sk@0 >= 2415113 AND ss_sold_date_sk@0 <= 2487944 AND hash_lookup WHEN 42 THEN ss_sold_date_sk@0 >= 2415024 AND ss_sold_date_sk@0 <= 2487582 AND hash_lookup WHEN 43 THEN ss_sold_date_sk@0 >= 2415170 AND ss_sold_date_sk@0 <= 2487972 AND hash_lookup WHEN 44 THEN ss_sold_date_sk@0 >= 2415233 AND ss_sold_date_sk@0 <= 2488037 AND hash_lookup WHEN 45 THEN ss_sold_date_sk@0 >= 2415422 AND ss_sold_date_sk@0 <= 2487842 AND hash_lookup WHEN 46 THEN ss_sold_date_sk@0 >= 2415145 AND ss_sold_date_sk@0 <= 2487905 AND hash_lookup WHEN 47 THEN ss _sold_date_sk@0 >= 2415043 AND ss_sold_date_sk@0 <= 2487989 AND hash_lookup WHEN 48 THEN ss_sold_date_sk@0 >= 2415195 AND ss_sold_date_sk@0 <= 2487926 AND hash_lookup WHEN 49 THEN ss_sold_date_sk@0 >= 2415057 AND ss_sold_date_sk@0 <= 2487855 AND hash_lookup WHEN 50 THEN ss_sold_date_sk@0 >= 2415074 AND ss_sold_date_sk@0 <= 2488064 AND hash_lookup WHEN 51 THEN ss_sold_date_sk@0 >= 2415037 AND ss_sold_date_sk@0 <= 2488007 AND hash_lookup WHEN 52 THEN ss_sold_date_sk@0 >= 2415107 AND ss_sold_date_sk@0 <= 2488042 AND hash_lookup WHEN 53 THEN ss_sold_date_sk@0 >= 2415072 AND ss_sold_date_sk@0 <= 2488028 AND hash_lookup WHEN 54 THEN ss_sold_date_sk@0 >= 2415111 AND ss_sold_date_sk@0 <= 2488053 AND hash_lookup WHEN 55 THEN ss_sold_date_sk@0 >= 2415026 AND ss_sold_date_sk@0 <= 2487898 AND hash_lookup WHEN 56 THEN ss_sold_date_sk@0 >= 2415052 AND ss_sold_date_sk@0 <= 2488017 AND hash_lookup WHEN 57 THEN ss_sold_date_sk@0 >= 2415213 AND ss_sold_date_sk@0 <= 2487921 AND hash_lookup WHEN 58 THE N ss_sold_date_sk@0 >= 2415025 AND ss_sold_date_sk@0 <= 2487552 AND hash_lookup WHEN 59 THEN ss_sold_date_sk@0 >= 2415084 AND ss_sold_date_sk@0 <= 2487980 AND hash_lookup WHEN 60 THEN ss_sold_date_sk@0 >= 2415264 AND ss_sold_date_sk@0 <= 2488010 AND hash_lookup WHEN 61 THEN ss_sold_date_sk@0 >= 2415188 AND ss_sold_date_sk@0 <= 2487868 AND hash_lookup WHEN 62 THEN ss_sold_date_sk@0 >= 2415574 AND ss_sold_date_sk@0 <= 2488011 AND hash_lookup WHEN 63 THEN ss_sold_date_sk@0 >= 2415147 AND ss_sold_date_sk@0 <= 2488031 AND hash_lookup WHEN 64 THEN ss_sold_date_sk@0 >= 2415030 AND ss_sold_date_sk@0 <= 2488036 AND hash_lookup WHEN 65 THEN ss_sold_date_sk@0 >= 2415058 AND ss_sold_date_sk@0 <= 2487987 AND hash_lookup WHEN 66 THEN ss_sold_date_sk@0 >= 2415105 AND ss_sold_date_sk@0 <= 2487964 AND hash_lookup WHEN 67 THEN ss_sold_date_sk@0 >= 2415121 AND ss_sold_date_sk@0 <= 2487988 AND hash_lookup WHEN 68 THEN ss_sold_date_sk@0 >= 2415386 AND ss_sold_date_sk@0 <= 2487910 AND hash_lookup WHEN 69 THEN ss_sold_date_sk@0 >= 2415140 AND ss_sold_date_sk@0 <= 2488004 AND hash_lookup WHEN 70 THEN ss_sold_date_sk@0 >= 2415120 AND ss_sold_date_sk@0 <= 2488045 AND hash_lookup WHEN 71 THEN ss_sold_date_sk@0 >= 2415031 AND ss_sold_date_sk@0 <= 2488041 AND hash_lookup WHEN 72 THEN ss_sold_date_sk@0 >= 2415272 AND ss_sold_date_sk@0 <= 2488032 AND hash_lookup WHEN 73 THEN ss_sold_date_sk@0 >= 2415075 AND ss_sold_date_sk@0 <= 2488015 AND hash_lookup WHEN 74 THEN ss_sold_date_sk@0 >= 2415073 AND ss_sold_date_sk@0 <= 2487938 AND hash_lookup WHEN 75 THEN ss_sold_date_sk@0 >= 2415148 AND ss_sold_date_sk@0 <= 2487912 AND hash_lookup WHEN 76 THEN ss_sold_date_sk@0 >= 2415141 AND ss_sold_date_sk@0 <= 2488044 AND hash_lookup WHEN 77 THEN ss_sold_date_sk@0 >= 2415022 AND ss_sold_date_sk@0 <= 2488018 AND hash_lookup WHEN 78 THEN ss_sold_date_sk@0 >= 2415035 AND ss_sold_date_sk@0 <= 2488026 AND hash_lookup WHEN 79 THEN ss_sold_date_sk@0 >= 2415115 AND ss_sold_date_sk@0 <= 2487961 AND hash_lookup WHE N 80 THEN ss_sold_date_sk@0 >= 2415051 AND ss_sold_date_sk@0 <= 2487758 AND hash_lookup WHEN 81 THEN ss_sold_date_sk@0 >= 2415117 AND ss_sold_date_sk@0 <= 2487993 AND hash_lookup WHEN 82 THEN ss_sold_date_sk@0 >= 2415247 AND ss_sold_date_sk@0 <= 2487886 AND hash_lookup WHEN 83 THEN ss_sold_date_sk@0 >= 2415184 AND ss_sold_date_sk@0 <= 2487945 AND hash_lookup WHEN 84 THEN ss_sold_date_sk@0 >= 2415212 AND ss_sold_date_sk@0 <= 2488014 AND hash_lookup WHEN 85 THEN ss_sold_date_sk@0 >= 2415046 AND ss_sold_date_sk@0 <= 2487968 AND hash_lookup WHEN 86 THEN ss_sold_date_sk@0 >= 2415047 AND ss_sold_date_sk@0 <= 2487683 AND hash_lookup WHEN 87 THEN ss_sold_date_sk@0 >= 2415038 AND ss_sold_date_sk@0 <= 2487902 AND hash_lookup WHEN 88 THEN ss_sold_date_sk@0 >= 2415034 AND ss_sold_date_sk@0 <= 2487962 AND hash_lookup WHEN 89 THEN ss_sold_date_sk@0 >= 2415315 AND ss_sold_date_sk@0 <= 2487523 AND hash_lookup WHEN 90 THEN ss_sold_date_sk@0 >= 2415040 AND ss_sold_date_sk@0 <= 2487715 AND hash_lookup WHEN 91 THEN ss_sold_date_sk@0 >= 2415313 AND ss_sold_date_sk@0 <= 2488056 AND hash_lookup WHEN 92 THEN ss_sold_date_sk@0 >= 2415079 AND ss_sold_date_sk@0 <= 2488052 AND hash_lookup WHEN 93 THEN ss_sold_date_sk@0 >= 2415258 AND ss_sold_date_sk@0 <= 2488065 AND hash_lookup WHEN 94 THEN ss_sold_date_sk@0 >= 2415053 AND ss_sold_date_sk@0 <= 2487743 AND hash_lookup WHEN 95 THEN ss_sold_date_sk@0 >= 2415399 AND ss_sold_date_sk@0 <= 2488038 AND hash_lookup WHEN 96 THEN ss_sold_date_sk@0 >= 2415144 AND ss_sold_date_sk@0 <= 2488046 AND hash_lookup WHEN 97 THEN ss_sold_date_sk@0 >= 2415178 AND ss_sold_date_sk@0 <= 2488040 AND hash_lookup WHEN 98 THEN ss_sold_date_sk@0 >= 2415240 AND ss_sold_date_sk@0 <= 2487976 AND hash_lookup WHEN 99 THEN ss_sold_date_sk@0 >= 2415234 AND ss_sold_date_sk@0 <= 2487947 AND hash_lookup WHEN 100 THEN ss_sold_date_sk@0 >= 2415123 AND ss_sold_date_sk@0 <= 2488060 AND hash_lookup WHEN 101 THEN ss_sold_date_sk@0 >= 2415125 AND ss_sold_date_sk@0 <= 2487851 AND hash_ lookup WHEN 102 THEN ss_sold_date_sk@0 >= 2415159 AND ss_sold_date_sk@0 <= 2488035 AND hash_lookup WHEN 103 THEN ss_sold_date_sk@0 >= 2415097 AND ss_sold_date_sk@0 <= 2488057 AND hash_lookup WHEN 104 THEN ss_sold_date_sk@0 >= 2415114 AND ss_sold_date_sk@0 <= 2488068 AND hash_lookup WHEN 105 THEN ss_sold_date_sk@0 >= 2415133 AND ss_sold_date_sk@0 <= 2488055 AND hash_lookup WHEN 106 THEN ss_sold_date_sk@0 >= 2415136 AND ss_sold_date_sk@0 <= 2487798 AND hash_lookup WHEN 107 THEN ss_sold_date_sk@0 >= 2415446 AND ss_sold_date_sk@0 <= 2487357 AND hash_lookup WHEN 108 THEN ss_sold_date_sk@0 >= 2415028 AND ss_sold_date_sk@0 <= 2487909 AND hash_lookup WHEN 109 THEN ss_sold_date_sk@0 >= 2415090 AND ss_sold_date_sk@0 <= 2488054 AND hash_lookup WHEN 110 THEN ss_sold_date_sk@0 >= 2415041 AND ss_sold_date_sk@0 <= 2488050 AND hash_lookup WHEN 111 THEN ss_sold_date_sk@0 >= 2415284 AND ss_sold_date_sk@0 <= 2488003 AND hash_lookup WHEN 112 THEN ss_sold_date_sk@0 >= 2415221 AND ss_sold_date_sk@0 <= 24 88023 AND hash_lookup WHEN 113 THEN ss_sold_date_sk@0 >= 2415093 AND ss_sold_date_sk@0 <= 2487992 AND hash_lookup WHEN 114 THEN ss_sold_date_sk@0 >= 2415108 AND ss_sold_date_sk@0 <= 2487145 AND hash_lookup WHEN 115 THEN ss_sold_date_sk@0 >= 2415312 AND ss_sold_date_sk@0 <= 2487812 AND hash_lookup WHEN 116 THEN ss_sold_date_sk@0 >= 2415168 AND ss_sold_date_sk@0 <= 2487891 AND hash_lookup WHEN 117 THEN ss_sold_date_sk@0 >= 2415045 AND ss_sold_date_sk@0 <= 2488051 AND hash_lookup WHEN 118 THEN ss_sold_date_sk@0 >= 2415162 AND ss_sold_date_sk@0 <= 2488029 AND hash_lookup WHEN 119 THEN ss_sold_date_sk@0 >= 2415083 AND ss_sold_date_sk@0 <= 2487805 AND hash_lookup WHEN 120 THEN ss_sold_date_sk@0 >= 2415348 AND ss_sold_date_sk@0 <= 2488020 AND hash_lookup WHEN 121 THEN ss_sold_date_sk@0 >= 2415050 AND ss_sold_date_sk@0 <= 2487984 AND hash_lookup WHEN 122 THEN ss_sold_date_sk@0 >= 2415080 AND ss_sold_date_sk@0 <= 2488047 AND hash_lookup WHEN 123 THEN ss_sold_date_sk@0 >= 2415230 AND ss_sold_ date_sk@0 <= 2488027 AND hash_lookup WHEN 124 THEN ss_sold_date_sk@0 >= 2415218 AND ss_sold_date_sk@0 <= 2487666 AND hash_lookup WHEN 125 THEN ss_sold_date_sk@0 >= 2415085 AND ss_sold_date_sk@0 <= 2487949 AND hash_lookup WHEN 126 THEN ss_sold_date_sk@0 >= 2415103 AND ss_sold_date_sk@0 <= 2488013 AND hash_lookup WHEN 127 THEN ss_sold_date_sk@0 >= 2415044 AND ss_sold_date_sk@0 <= 2488069 AND hash_lookup ELSE false END ] ``` </details> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
