github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q19 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q19 9 # Discounted Revenue 10 # Reports the gross discounted revenue attributed to the sale of selected parts 11 # handled in a particular manner. This query is an example of code such as might 12 # be produced programmatically by a data mining tool. 13 # 14 # The Discounted Revenue query finds the gross discounted revenue for all orders 15 # for three different types of parts that were shipped by air and delivered in 16 # person. Parts are selected based on the combination of specific brands, a list 17 # of containers, and a range of sizes. 18 # -------------------------------------------------- 19 save-tables database=tpch save-tables-prefix=q19 20 SELECT 21 sum(l_extendedprice* (1 - l_discount)) AS revenue 22 FROM 23 lineitem, 24 part 25 WHERE 26 ( 27 p_partkey = l_partkey 28 AND p_brand = 'Brand#12' 29 AND p_container IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG') 30 AND l_quantity >= 1 AND l_quantity <= 1 + 10 31 AND p_size BETWEEN 1 AND 5 32 AND l_shipmode IN ('AIR', 'AIR REG') 33 AND l_shipinstruct = 'DELIVER IN PERSON' 34 ) 35 OR 36 ( 37 p_partkey = l_partkey 38 AND p_brand = 'Brand#23' 39 AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK') 40 AND l_quantity >= 10 AND l_quantity <= 10 + 10 41 AND p_size BETWEEN 1 AND 10 42 AND l_shipmode IN ('AIR', 'AIR REG') 43 AND l_shipinstruct = 'DELIVER IN PERSON' 44 ) 45 OR 46 ( 47 p_partkey = l_partkey 48 AND p_brand = 'Brand#34' 49 AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG') 50 AND l_quantity >= 20 AND l_quantity <= 20 + 10 51 AND p_size BETWEEN 1 AND 15 52 AND l_shipmode IN ('AIR', 'AIR REG') 53 AND l_shipinstruct = 'DELIVER IN PERSON' 54 ); 55 ---- 56 scalar-group-by 57 ├── save-table-name: q19_scalar_group_by_1 58 ├── columns: revenue:27(float) 59 ├── cardinality: [1 - 1] 60 ├── stats: [rows=1, distinct(27)=1, null(27)=0] 61 ├── key: () 62 ├── fd: ()-->(27) 63 ├── project 64 │ ├── save-table-name: q19_project_2 65 │ ├── columns: column26:26(float!null) 66 │ ├── stats: [rows=71.4087386, distinct(26)=71.402791, null(26)=0] 67 │ ├── inner-join (hash) 68 │ │ ├── save-table-name: q19_inner_join_3 69 │ │ ├── columns: l_partkey:2(int!null) l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_shipinstruct:14(char!null) l_shipmode:15(char!null) p_partkey:17(int!null) p_brand:20(char!null) p_size:22(int!null) p_container:23(char!null) 70 │ │ ├── stats: [rows=71.4087386, distinct(2)=71.4087386, null(2)=0, distinct(5)=5.55555556, null(5)=0, distinct(6)=71.4015197, null(6)=0, distinct(7)=10.9833244, null(7)=0, distinct(14)=1, null(14)=0, distinct(15)=2, null(15)=0, distinct(17)=71.4087386, null(17)=0, distinct(20)=3, null(20)=0, distinct(22)=5.55555556, null(22)=0, distinct(23)=12, null(23)=0, distinct(6,7)=71.402791, null(6,7)=0, distinct(20,22,23)=71.4087386, null(20,22,23)=0] 71 │ │ ├── fd: ()-->(14), (17)-->(20,22,23), (2)==(17), (17)==(2) 72 │ │ ├── select 73 │ │ │ ├── save-table-name: q19_select_4 74 │ │ │ ├── columns: l_partkey:2(int!null) l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_shipinstruct:14(char!null) l_shipmode:15(char!null) 75 │ │ │ ├── stats: [rows=428658.214, distinct(2)=177863.163, null(2)=0, distinct(5)=50, null(5)=0, distinct(6)=353162.332, null(6)=0, distinct(7)=11, null(7)=0, distinct(14)=1, null(14)=0, distinct(15)=2, null(15)=0, distinct(6,7)=428658.214, null(6,7)=0, distinct(14,15)=2, null(14,15)=0] 76 │ │ │ ├── fd: ()-->(14) 77 │ │ │ ├── scan lineitem 78 │ │ │ │ ├── save-table-name: q19_scan_5 79 │ │ │ │ ├── columns: l_partkey:2(int!null) l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_shipinstruct:14(char!null) l_shipmode:15(char!null) 80 │ │ │ │ └── stats: [rows=6001215, distinct(2)=199241, null(2)=0, distinct(5)=50, null(5)=0, distinct(6)=925955, null(6)=0, distinct(7)=11, null(7)=0, distinct(14)=4, null(14)=0, distinct(15)=7, null(15)=0, distinct(6,7)=6001215, null(6,7)=0, distinct(14,15)=28, null(14,15)=0] 81 │ │ │ │ histogram(2)= 0 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 600 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 1200 29405 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 82 │ │ │ │ <--- 29 ------- 959 ------- 1845 ------- 3339 ------- 4395 ------- 5525 ------- 6349 ------- 7298 ------- 8340 ------- 9659 ------- 10756 ------- 11642 ------- 12662 ------- 13609 ------- 14663 ------- 15886 ------- 16905 ------- 17902 ------- 18705 ------- 19722 ------- 20827 ------- 21789 ------- 23026 ------- 24201 ------- 25338 ------- 26224 ------- 27182 ------- 28202 ------- 29058 ------- 29919 ------- 31031 ------- 32058 ------- 33058 ------- 34089 ------- 34972 ------- 35929 ------- 36995 ------- 37901 ------- 38814 ------- 39884 ------- 41044 ------- 42034 ------- 43257 ------- 44224 ------- 45196 ------- 46284 ------- 47373 ------- 48352 ------- 49175 ------- 50212 ------- 51359 ------- 52449 ------- 53225 ------- 54295 ------- 55556 ------- 56736 ------- 57984 ------- 59102 ------- 60117 ------- 61111 ------- 62007 ------- 63054 ------- 63923 ------- 64971 ------- 66018 ------- 67114 ------- 67979 ------- 69163 ------- 70178 ------- 71421 ------- 72412 ------- 73432 ------- 74444 ------- 75421 ------- 76307 ------- 77194 ------- 78249 ------- 79229 ------- 80220 ------- 81103 ------- 81841 ------- 83133 ------- 84398 ------- 85526 ------- 86382 ------- 87333 ------- 88313 ------- 89185 ------- 90240 ------- 91121 ------- 91927 ------- 92840 ------- 93562 ------- 94443 ------- 95372 ------- 96282 ------- 97084 ------- 97969 ------- 99105 ------- 100036 ------- 100911 ------- 101928 ------- 102725 ------- 103625 ------- 104599 ------- 105568 ------- 106366 ------- 107318 ------- 108221 ------- 109084 ------- 110150 ------- 111130 ------- 112290 ------- 113258 ------- 114514 ------- 115361 ------- 116860 ------- 118141 ------- 119083 ------- 120205 ------- 121265 ------- 122280 ------- 123210 ------- 124316 ------- 125393 ------- 126419 ------- 127466 ------- 128467 ------- 129550 ------- 130729 ------- 131956 ------- 133065 ------- 134173 ------- 135106 ------- 136339 ------- 137237 ------- 138221 ------- 139139 ------- 140103 ------- 141250 ------- 142059 ------- 142984 ------- 144048 ------- 145243 ------- 146186 ------- 147153 ------- 148099 ------- 149103 ------- 149945 ------- 150918 ------- 151860 ------- 152830 ------- 153863 ------- 154681 ------- 156041 ------- 156862 ------- 157688 ------- 158743 ------- 159676 ------- 160684 ------- 161325 ------- 162394 ------- 163558 ------- 164576 ------- 165819 ------- 166748 ------- 167734 ------- 168986 ------- 170087 ------- 170931 ------- 171933 ------- 172836 ------- 174038 ------- 175011 ------- 175836 ------- 176680 ------- 177741 ------- 178899 ------- 179745 ------- 180631 ------- 181664 ------- 182624 ------- 183639 ------- 184414 ------- 185145 ------- 186261 ------- 187090 ------- 188033 ------- 189049 ------- 190063 ------- 191040 ------- 192115 ------- 193408 ------- 194360 ------- 195506 ------- 196582 ------- 197367 ------- 198465 ------- 199096 ------- 199970 83 │ │ │ └── filters 84 │ │ │ ├── l_shipmode:15 IN ('AIR', 'AIR REG') [type=bool, outer=(15), constraints=(/15: [/'AIR' - /'AIR'] [/'AIR REG' - /'AIR REG']; tight)] 85 │ │ │ └── l_shipinstruct:14 = 'DELIVER IN PERSON' [type=bool, outer=(14), constraints=(/14: [/'DELIVER IN PERSON' - /'DELIVER IN PERSON']; tight), fd=()-->(14)] 86 │ │ ├── select 87 │ │ │ ├── save-table-name: q19_select_6 88 │ │ │ ├── columns: p_partkey:17(int!null) p_brand:20(char!null) p_size:22(int!null) p_container:23(char!null) 89 │ │ │ ├── stats: [rows=66666.6667, distinct(17)=66618.6736, null(17)=0, distinct(20)=25, null(20)=0, distinct(22)=16.6666667, null(22)=0, distinct(23)=40, null(23)=0, distinct(20,22,23)=16666.6667, null(20,22,23)=0] 90 │ │ │ ├── key: (17) 91 │ │ │ ├── fd: (17)-->(20,22,23) 92 │ │ │ ├── scan part 93 │ │ │ │ ├── save-table-name: q19_scan_7 94 │ │ │ │ ├── columns: p_partkey:17(int!null) p_brand:20(char!null) p_size:22(int!null) p_container:23(char!null) 95 │ │ │ │ ├── stats: [rows=200000, distinct(17)=199241, null(17)=0, distinct(20)=25, null(20)=0, distinct(22)=50, null(22)=0, distinct(23)=40, null(23)=0, distinct(20,22,23)=50000, null(20,22,23)=0] 96 │ │ │ │ │ histogram(17)= 0 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 97 │ │ │ │ │ <--- 27 ----- 1110 ----- 2241 ----- 3086 ----- 4134 ----- 5302 ----- 6222 ----- 7308 ----- 8249 ----- 9171 ----- 10049 ----- 10958 ----- 11832 ----- 13025 ----- 14063 ----- 14953 ----- 16249 ----- 17419 ----- 18363 ----- 19412 ----- 20257 ----- 21190 ----- 22110 ----- 23045 ----- 23956 ----- 24962 ----- 25942 ----- 26990 ----- 27934 ----- 28876 ----- 29513 ----- 30326 ----- 31259 ----- 32300 ----- 33577 ----- 34550 ----- 35562 ----- 36498 ----- 37475 ----- 38584 ----- 39641 ----- 40548 ----- 41605 ----- 42527 ----- 43612 ----- 44702 ----- 45701 ----- 46726 ----- 47795 ----- 48935 ----- 50152 ----- 51183 ----- 52001 ----- 52904 ----- 53868 ----- 54808 ----- 55986 ----- 57155 ----- 58516 ----- 59526 ----- 60557 ----- 61547 ----- 62369 ----- 63672 ----- 64583 ----- 65360 ----- 66147 ----- 67201 ----- 68142 ----- 69145 ----- 70209 ----- 71141 ----- 71923 ----- 73031 ----- 73987 ----- 74974 ----- 76170 ----- 77138 ----- 77849 ----- 78931 ----- 79832 ----- 80761 ----- 81843 ----- 82834 ----- 84032 ----- 85072 ----- 86287 ----- 87302 ----- 88422 ----- 89432 ----- 90550 ----- 91463 ----- 92249 ----- 93385 ----- 94789 ----- 96013 ----- 96893 ----- 98000 ----- 99008 ----- 100166 ----- 101263 ----- 102351 ----- 103236 ----- 104121 ----- 105363 ----- 106329 ----- 107325 ----- 108231 ----- 109054 ----- 110019 ----- 111185 ----- 112112 ----- 112908 ----- 113904 ----- 114785 ----- 115410 ----- 116526 ----- 117559 ----- 118310 ----- 119073 ----- 120034 ----- 120817 ----- 121744 ----- 122566 ----- 123720 ----- 124813 ----- 125835 ----- 126622 ----- 127651 ----- 128328 ----- 129315 ----- 130244 ----- 131450 ----- 132439 ----- 133288 ----- 134164 ----- 135298 ----- 136347 ----- 137243 ----- 138256 ----- 139427 ----- 140374 ----- 141371 ----- 142302 ----- 143322 ----- 144335 ----- 145333 ----- 146212 ----- 147321 ----- 148591 ----- 149594 ------ 150514 ------ 151361 ------ 152059 ------ 153070 ------ 154059 ------ 155259 ------ 156473 ------ 157690 ------ 158703 ------ 159675 ------ 160597 ------ 161668 ------ 162737 ------ 163955 ------ 164942 ------ 165924 ------ 167059 ------ 167866 ------ 169034 ------ 169935 ------ 170712 ------ 171806 ------ 172841 ------ 174078 ------ 175347 ------ 176430 ------ 177346 ------ 178566 ------ 179515 ------ 180677 ------ 181729 ------ 182983 ------ 183814 ------ 184892 ------ 185696 ------ 186611 ------ 187744 ------ 188974 ------ 189911 ------ 190671 ------ 191607 ------ 192820 ------ 193789 ------ 195057 ------ 196224 ------ 197231 ------ 198281 ------ 199119 ------ 199999 98 │ │ │ │ ├── key: (17) 99 │ │ │ │ └── fd: (17)-->(20,22,23) 100 │ │ │ └── filters 101 │ │ │ └── p_size:22 >= 1 [type=bool, outer=(22), constraints=(/22: [/1 - ]; tight)] 102 │ │ └── filters 103 │ │ ├── p_partkey:17 = l_partkey:2 [type=bool, outer=(2,17), constraints=(/2: (/NULL - ]; /17: (/NULL - ]), fd=(2)==(17), (17)==(2)] 104 │ │ └── ((((((p_brand:20 = 'Brand#12') AND (p_container:23 IN ('SM BOX', 'SM CASE', 'SM PACK', 'SM PKG'))) AND (l_quantity:5 >= 1.0)) AND (l_quantity:5 <= 11.0)) AND (p_size:22 <= 5)) OR (((((p_brand:20 = 'Brand#23') AND (p_container:23 IN ('MED BAG', 'MED BOX', 'MED PACK', 'MED PKG'))) AND (l_quantity:5 >= 10.0)) AND (l_quantity:5 <= 20.0)) AND (p_size:22 <= 10))) OR (((((p_brand:20 = 'Brand#34') AND (p_container:23 IN ('LG BOX', 'LG CASE', 'LG PACK', 'LG PKG'))) AND (l_quantity:5 >= 20.0)) AND (l_quantity:5 <= 30.0)) AND (p_size:22 <= 15)) [type=bool, outer=(5,20,22,23), constraints=(/5: [/1.0 - /30.0]; /20: [/'Brand#12' - /'Brand#12'] [/'Brand#23' - /'Brand#23'] [/'Brand#34' - /'Brand#34']; /22: (/NULL - /15]; /23: [/'LG BOX' - /'LG BOX'] [/'LG CASE' - /'LG CASE'] [/'LG PACK' - /'LG PACK'] [/'LG PKG' - /'LG PKG'] [/'MED BAG' - /'MED BAG'] [/'MED BOX' - /'MED BOX'] [/'MED PACK' - /'MED PACK'] [/'MED PKG' - /'MED PKG'] [/'SM BOX' - /'SM BOX'] [/'SM CASE' - /'SM CASE'] [/'SM PACK' - /'SM PACK'] [/'SM PKG' - /'SM PKG'])] 105 │ └── projections 106 │ └── l_extendedprice:6 * (1.0 - l_discount:7) [as=column26:26, type=float, outer=(6,7)] 107 └── aggregations 108 └── sum [as=sum:27, type=float, outer=(26)] 109 └── column26:26 [type=float] 110 111 stats table=q19_scalar_group_by_1 112 ---- 113 column_names row_count distinct_count null_count 114 {revenue} 1 1 0 115 ~~~~ 116 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 117 {revenue} 1.00 1.00 1.00 1.00 0.00 1.00 118 119 stats table=q19_project_2 120 ---- 121 column_names row_count distinct_count null_count 122 {column26} 121 121 0 123 ~~~~ 124 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 125 {column26} 71.00 1.70 71.00 1.70 0.00 1.00 126 127 stats table=q19_inner_join_3 128 ---- 129 column_names row_count distinct_count null_count 130 {l_discount} 121 11 0 131 {l_extendedprice} 121 118 0 132 {l_partkey} 121 103 0 133 {l_quantity} 121 29 0 134 {l_shipinstruct} 121 1 0 135 {l_shipmode} 121 1 0 136 {p_brand} 121 3 0 137 {p_container} 121 12 0 138 {p_partkey} 121 103 0 139 {p_size} 121 14 0 140 ~~~~ 141 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 142 {l_discount} 71.00 1.70 11.00 1.00 0.00 1.00 143 {l_extendedprice} 71.00 1.70 71.00 1.66 0.00 1.00 144 {l_partkey} 71.00 1.70 71.00 1.45 0.00 1.00 145 {l_quantity} 71.00 1.70 6.00 4.83 <== 0.00 1.00 146 {l_shipinstruct} 71.00 1.70 1.00 1.00 0.00 1.00 147 {l_shipmode} 71.00 1.70 2.00 2.00 <== 0.00 1.00 148 {p_brand} 71.00 1.70 3.00 1.00 0.00 1.00 149 {p_container} 71.00 1.70 12.00 1.00 0.00 1.00 150 {p_partkey} 71.00 1.70 71.00 1.45 0.00 1.00 151 {p_size} 71.00 1.70 6.00 2.33 <== 0.00 1.00 152 153 stats table=q19_select_4 154 ---- 155 column_names row_count distinct_count null_count 156 {l_discount} 214377 11 0 157 {l_extendedprice} 214377 188952 0 158 {l_partkey} 214377 131422 0 159 {l_quantity} 214377 50 0 160 {l_shipinstruct} 214377 1 0 161 {l_shipmode} 214377 1 0 162 ~~~~ 163 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 164 {l_discount} 428658.00 2.00 <== 11.00 1.00 0.00 1.00 165 {l_extendedprice} 428658.00 2.00 <== 353162.00 1.87 0.00 1.00 166 {l_partkey} 428658.00 2.00 <== 177863.00 1.35 0.00 1.00 167 {l_quantity} 428658.00 2.00 <== 50.00 1.00 0.00 1.00 168 {l_shipinstruct} 428658.00 2.00 <== 1.00 1.00 0.00 1.00 169 {l_shipmode} 428658.00 2.00 <== 2.00 2.00 <== 0.00 1.00 170 171 stats table=q19_scan_5 172 ---- 173 column_names row_count distinct_count null_count 174 {l_discount} 6001215 11 0 175 {l_extendedprice} 6001215 925955 0 176 {l_partkey} 6001215 199241 0 177 {l_quantity} 6001215 50 0 178 {l_shipinstruct} 6001215 4 0 179 {l_shipmode} 6001215 7 0 180 ~~~~ 181 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 182 {l_discount} 6001215.00 1.00 11.00 1.00 0.00 1.00 183 {l_extendedprice} 6001215.00 1.00 925955.00 1.00 0.00 1.00 184 {l_partkey} 6001215.00 1.00 199241.00 1.00 0.00 1.00 185 {l_quantity} 6001215.00 1.00 50.00 1.00 0.00 1.00 186 {l_shipinstruct} 6001215.00 1.00 4.00 1.00 0.00 1.00 187 {l_shipmode} 6001215.00 1.00 7.00 1.00 0.00 1.00 188 189 stats table=q19_select_6 190 ---- 191 column_names row_count distinct_count null_count 192 {p_brand} 200000 25 0 193 {p_container} 200000 40 0 194 {p_partkey} 200000 199241 0 195 {p_size} 200000 50 0 196 ~~~~ 197 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 198 {p_brand} 66667.00 3.00 <== 25.00 1.00 0.00 1.00 199 {p_container} 66667.00 3.00 <== 40.00 1.00 0.00 1.00 200 {p_partkey} 66667.00 3.00 <== 66619.00 2.99 <== 0.00 1.00 201 {p_size} 66667.00 3.00 <== 17.00 2.94 <== 0.00 1.00 202 203 stats table=q19_scan_7 204 ---- 205 column_names row_count distinct_count null_count 206 {p_brand} 200000 25 0 207 {p_container} 200000 40 0 208 {p_partkey} 200000 199241 0 209 {p_size} 200000 50 0 210 ~~~~ 211 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 212 {p_brand} 200000.00 1.00 25.00 1.00 0.00 1.00 213 {p_container} 200000.00 1.00 40.00 1.00 0.00 1.00 214 {p_partkey} 200000.00 1.00 199241.00 1.00 0.00 1.00 215 {p_size} 200000.00 1.00 50.00 1.00 0.00 1.00