# TheFlash TPCH on 1 node, pushdown + codegen + broadcast, different concurrent config. ## Config and result * CH-0001: partitions=16, decoders=1, encoders=16 * CH-0002: partitions=16, decoders=2, encoders=16 * CH-0003: partitions=16, decoders=4, encoders=16 * CH-0004: partitions=16, decoders=8, encoders=16 * CH-0005: partitions=16, decoders=16, encoders=16 * CH-0006: partitions=16, decoders=4, encoders=32 * CH-0007: partitions=32, decoders=4, encoders=16 * CH-0008: partitions=8, decoders=4, encoders=16 * CH-0009: partitions=4, decoders=4, encoders=16 * CH-0015: partitions=8, decoders=2, encoders=16 * CH-0016: partitions=8, decoders=1, encoders=16 * CH-0017: partitions=4, decoders=2, encoders=16 * Too slow * CH-0010: partitions=2, decoders=4, encoders=16 * CH-0011: partitions=2, decoders=8, encoders=16 * CH-0012: partitions=1, decoders=4, encoders=16 * CH-0013: partitions=1, decoders=8, encoders=16 * CH-0014: partitions=1, decoders=16, encoders=16 | Query | CH-0001 | CH-0002 | CH-0003 | CH-0004 | CH-0005 | CH-0006 | CH-0007 | CH-0008 | CH-0009 | CH-0015 | CH-0016 | CH-0017 | | ----- | ------: | ------: | ------: | ------: | ------: | ------: | ------: | ------: | ------: | ------: | ------: | ------: | | Q01 | 11.6 | 10.7 | 10.2 | 11.0 | 10.5 | 10.6 | 11.4 | 10.9 | 10.5 | 10.7 | 10.8 | 10.1 | | Q02 | 46.1 | 45.3 | 43.8 | 43.6 | 44.5 | 42.9 | 44.2 | 43.0 | 42.5 | 43.5 | 41.6 | 42.3 | | Q03 | 66.0 | 65.8 | 66.5 | 67.7 | 67.5 | 65.0 | 67.7 | 66.1 | 84.8 | 67.1 | 64.5 | 81.3 | | Q04 | 305.9 | 302.7 | 296.8 | 294.6 | 437.5 | 300.1 | 298.5 | 300.8 | 358.4 | 304.9 | 309.8 | 355.7 | | Q05 | 123.7 | 123.6 | 126.0 | 122.9 | 122.0 | 123.9 | 124.9 | 130.2 | 167.0 | 131.0 | 127.6 | 163.4 | | Q06 | 4.5 | 4.4 | 4.3 | 4.2 | 4.5 | 4.5 | 4.6 | 4.4 | 4.2 | 4.5 | 4.3 | 4.4 | | Q07 | 88.6 | 90.8 | 90.1 | 90.2 | 93.3 | 89.0 | 88.4 | 91.2 | 107.6 | 89.5 | 87.9 | 109.3 | | Q08 | 131.4 | 128.7 | 130.1 | 131.9 | 131.0 | 128.3 | 137.7 | 143.3 | 188.6 | 144.2 | 146.8 | 186.8 | | Q09 | 180.3 | 176.8 | 177.6 | 187.2 | 183.7 | 171.0 | 179.2 | 183.0 | 234.6 | 185.6 | 181.5 | 242.7 | | Q10 | 56.6 | 55.9 | 56.2 | 59.2 | 62.1 | 58.0 | 57.4 | 55.4 | 61.1 | 54.6 | 55.3 | 57.8 | | Q11 | 17.7 | 17.2 | 17.9 | 17.6 | 18.7 | 17.4 | 18.0 | 16.3 | 16.9 | 16.4 | 16.6 | 16.9 | | Q12 | 36.7 | 38.3 | 39.5 | 37.6 | 38.3 | 36.5 | 37.3 | 39.2 | 43.3 | 36.5 | 35.9 | 42.7 | | Q13 | 57.5 | 57.0 | 57.4 | 56.2 | 58.7 | 56.0 | 56.0 | 64.1 | 95.0 | 63.6 | 63.5 | 94.4 | | Q14 | 12.7 | 13.1 | 12.8 | 13.2 | 13.7 | 13.0 | 13.3 | 12.5 | 13.0 | 12.6 | 12.3 | 13.4 | | Q15 | | | | | | | | | | | | | | Q16 | 131.2 | 135.1 | 227.1 | 633.6 | 103.0 | 176.9 | 197.7 | 569.6 | 474.3 | 595.6 | 323.7 | 428.4 | | Q17 | | | | | | | | | | | | | | Q18 | | | | | | | | | | | | | | Q19 | 57.8 | 53.8 | 54.2 | 53.4 | 56.2 | 54.4 | 54.4 | 55.9 | 55.4 | 51.6 | 54.6 | 50.9 | | Q20 | | | | | | | | | | | | | | Q21 | | | | | | | | | | | | | | Q22 | 89.1 | 88.7 | 90.1 | 94.1 | 93.1 | 85.2 | 86.6 | 92.3 | 111.9 | 89.4 | 87.9 | 114.5 | ## Raw result data * CH-0001: partitions=16, decoders=1, encoders=16 ``` Q01, avg: 11.6, detail: [10.0, 10.4, 11.5, 12.5, 12.1, 13.0] Q02, avg: 46.1, detail: [48.0, 46.9, 46.5, 43.9, 46.8, 44.4] Q03, avg: 66.0, detail: [65.3, 69.8, 65.7, 61.5, 68.8, 64.8] Q04, avg: 305.9, detail: [304.6, 310.0, 304.6, 297.3, 307.7, 311.3] Q05, avg: 123.7, detail: [123.5, 124.5, 123.5, 128.8, 122.2, 119.9] Q06, avg: 4.5, detail: [4.6, 4.3, 4.7, 4.6, 4.3, 4.6] Q07, avg: 88.6, detail: [88.9, 82.7, 85.9, 88.3, 90.7, 95.2] Q08, avg: 131.4, detail: [128.5, 140.1, 137.5, 125.2, 129.4, 127.5] Q09, avg: 180.3, detail: [178.2, 176.3, 185.1, 190.1, 178.9, 173.4] Q10, avg: 56.6, detail: [57.2, 60.8, 55.0, 55.3, 53.7, 57.6] Q11, avg: 17.7, detail: [18.4, 18.2, 17.1, 18.0, 16.5, 18.3] Q12, avg: 36.7, detail: [35.6, 36.4, 38.3, 37.2, 36.9, 35.8] Q13, avg: 57.5, detail: [54.1, 55.4, 58.0, 53.0, 61.0, 63.3] Q14, avg: 12.7, detail: [12.8, 12.7, 13.2, 12.1, 12.1, 13.4] Q16, avg: 131.2, detail: [111.9, 120.9, 113.9, 177.9] Q19, avg: 57.8, detail: [52.7, 60.8, 56.8, 60.8, 56.3, 59.2] Q22, avg: 89.1, detail: [88.6, 82.9, 88.3, 91.6, 93.5, 89.7] ``` * CH-0002: partitions=16, decoders=2, encoders=16 ``` Q01, avg: 10.7, detail: [9.6, 10.2, 10.8, 10.9, 11.2, 11.5] Q02, avg: 45.3, detail: [47.0, 45.0, 44.1, 44.8, 44.7, 46.3] Q03, avg: 65.8, detail: [68.5, 66.4, 64.0, 64.7, 64.7, 66.3] Q04, avg: 302.7, detail: [310.7, 298.4, 297.8, 299.0, 306.2, 304.1] Q05, avg: 123.6, detail: [138.4, 123.1, 117.1, 115.7, 127.1, 120.0] Q06, avg: 4.4, detail: [4.3, 4.6, 4.3, 4.4, 4.4, 4.2] Q07, avg: 90.8, detail: [98.4, 94.6, 82.7, 94.3, 86.1, 88.4] Q08, avg: 128.7, detail: [129.2, 125.0, 138.6, 122.8, 130.7, 125.6] Q09, avg: 176.8, detail: [173.3, 174.3, 168.6, 165.7, 186.0, 193.0] Q10, avg: 55.9, detail: [52.5, 57.9, 56.2, 54.5, 56.3, 57.8] Q11, avg: 17.2, detail: [16.6, 16.7, 17.0, 17.8, 16.5, 18.4] Q12, avg: 38.3, detail: [35.6, 37.6, 41.2, 37.1, 42.2, 36.1] Q13, avg: 57.0, detail: [57.9, 56.5, 57.6, 56.8, 57.9, 55.2] Q14, avg: 13.1, detail: [13.1, 13.0, 12.3, 12.5, 14.1, 13.6] Q16, avg: 135.1, detail: [126.8, 131.2, 120.3, 172.9, 124.5] Q19, avg: 53.8, detail: [53.3, 54.0, 55.5, 51.9, 52.9, 55.4] Q22, avg: 88.7, detail: [87.7, 90.4, 91.7, 88.2, 85.3] ``` * CH-0003: partitions=16, decoders=4, encoders=16 ``` Q01, avg: 10.2, detail: [9.8, 11.6, 10.3, 9.7, 10.4, 9.6] Q02, avg: 43.8, detail: [44.5, 45.0, 43.0, 44.2, 40.8, 45.5] Q03, avg: 66.5, detail: [64.5, 70.4, 67.5, 64.9, 63.3, 68.4] Q04, avg: 296.8, detail: [292.1, 299.4, 292.0, 303.2, 294.6, 299.3] Q05, avg: 126.0, detail: [135.2, 120.4, 113.4, 128.1, 134.1, 124.9] Q06, avg: 4.3, detail: [4.1, 4.4, 4.1, 4.6, 4.3, 4.2] Q07, avg: 90.1, detail: [92.9, 92.2, 86.1, 87.2, 90.0, 91.9] Q08, avg: 130.1, detail: [130.7, 128.0, 125.9, 138.6, 129.7, 127.7] Q09, avg: 177.6, detail: [174.1, 191.7, 178.0, 176.9, 179.5, 165.2] Q10, avg: 56.2, detail: [55.4, 53.4, 56.7, 56.8, 58.7, 56.0] Q11, avg: 17.9, detail: [17.8, 17.6, 18.8, 17.6, 18.1, 17.8] Q12, avg: 39.5, detail: [44.6, 40.3, 36.4, 36.6, 38.7, 40.4] Q13, avg: 57.4, detail: [55.6, 58.7, 54.9, 57.2, 61.1, 56.6] Q14, avg: 12.8, detail: [12.6, 13.4, 13.2, 12.7, 12.5, 12.6] Q16, avg: 227.1, detail: [143.9, 481.4, 124.0, 159.1] Q19, avg: 54.2, detail: [54.4, 60.8, 50.7, 53.3, 53.8, 52.5] Q22, avg: 90.1, detail: [85.5, 109.4, 86.6, 85.4, 83.4] ``` * CH-0004: partitions=16, decoders=8, encoders=16 ``` Q01, avg: 11.0, detail: [10.5, 10.4, 11.9, 9.7, 10.9, 12.8] Q02, avg: 43.6, detail: [46.0, 42.2, 42.9, 42.7, 43.7, 44.0] Q03, avg: 67.7, detail: [68.8, 68.0, 69.7, 65.0, 68.8, 66.1] Q04, avg: 294.6, detail: [290.5, 289.9, 297.1, 287.2, 304.1, 298.9] Q05, avg: 122.9, detail: [120.9, 113.6, 123.2, 132.2, 125.1, 122.6] Q06, avg: 4.2, detail: [4.2, 4.2, 4.3, 4.2, 4.3, 4.3] Q07, avg: 90.2, detail: [91.9, 85.9, 87.5, 97.2, 91.6, 87.3] Q08, avg: 131.9, detail: [141.7, 132.4, 132.5, 129.0, 130.0, 125.9] Q09, avg: 187.2, detail: [169.3, 174.0, 173.0, 169.5, 266.8, 170.6] Q10, avg: 59.2, detail: [61.5, 60.3, 54.5, 62.8, 60.2, 56.1] Q11, avg: 17.6, detail: [17.1, 16.9, 17.5, 17.5, 17.7, 19.1] Q12, avg: 37.6, detail: [35.0, 39.2, 37.9, 37.4, 38.0, 37.9] Q13, avg: 56.2, detail: [54.9, 57.8, 54.7, 57.0, 54.3, 58.7] Q14, avg: 13.2, detail: [13.5, 13.6, 12.4, 13.9, 12.9, 12.9] Q16, avg: 633.6, detail: [172.0, 343.3, 720.7, 807.9, 1095.1, 662.8] Q19, avg: 53.4, detail: [53.5, 52.4, 53.9, 54.0, 53.9, 52.8] Q22, avg: 94.1, detail: [86.1, 108.6, 84.6, 94.5, 96.6] ``` * CH-0005: partitions=16, decoders=16, encoders=16 ``` Q01, avg: 10.5, detail: [10.8, 10.1, 11.3, 9.5, 10.4, 10.8] Q02, avg: 44.5, detail: [47.2, 43.8, 46.6, 40.6, 43.1, 45.6] Q03, avg: 67.5, detail: [68.3, 66.8, 67.0, 63.1, 70.6, 69.5] Q04, avg: 437.5, detail: [312.5, 302.8, 549.2, 308.2, 614.7, 537.7] Q05, avg: 122.0, detail: [122.3, 120.2, 115.3, 122.2, 129.2, 122.7] Q06, avg: 4.5, detail: [4.5, 4.3, 4.2, 4.2, 4.9, 4.6] Q07, avg: 93.3, detail: [99.1, 87.0, 96.5, 89.2, 93.0, 95.0] Q08, avg: 131.0, detail: [135.4, 126.8, 130.7, 130.4, 131.1, 131.6] Q09, avg: 183.7, detail: [188.6, 193.2, 178.0, 171.9, 178.5, 191.9] Q10, avg: 62.1, detail: [58.3, 60.9, 62.8, 65.5, 62.1, 63.1] Q11, avg: 18.7, detail: [19.0, 18.5, 18.8, 19.5, 17.6, 18.5] Q12, avg: 38.3, detail: [40.6, 38.5, 36.0, 38.6, 39.2, 36.7] Q13, avg: 58.7, detail: [58.4, 59.2, 57.0, 61.9, 58.0, 57.6] Q14, avg: 13.7, detail: [14.2, 13.5, 13.0, 13.0, 13.7, 14.7] Q16, avg: 103.0, detail: [101.8, 105.7, 105.6, 98.7] Q19, avg: 56.2, detail: [52.8, 61.5, 56.8, 56.2, 55.7, 54.0] Q22, avg: 93.1, detail: [101.6, 87.2, 92.7, 99.4, 84.6] ``` * CH-0006: partitions=16, decoders=4, encoders=32 ``` Q01, avg: 10.6, detail: [10.0, 9.6, 10.5, 11.2, 11.4, 10.7] Q02, avg: 42.9, detail: [43.0, 41.0, 44.5, 40.4, 44.7, 44.0] Q03, avg: 65.0, detail: [65.5, 65.3, 63.5, 65.0, 62.5, 68.3] Q04, avg: 300.1, detail: [303.9, 296.2, 299.9, 299.3, 302.5, 298.6] Q05, avg: 123.9, detail: [128.8, 128.7, 120.5, 127.9, 118.7, 118.6] Q06, avg: 4.5, detail: [4.4, 4.3, 4.5, 4.4, 5.0, 4.5] Q07, avg: 89.0, detail: [90.6, 85.2, 86.2, 91.6, 93.7, 86.6] Q08, avg: 128.3, detail: [126.8, 127.8, 125.0, 131.1, 129.7, 129.2] Q09, avg: 171.0, detail: [160.8, 169.9, 174.2, 178.5, 175.7, 166.6] Q10, avg: 58.0, detail: [54.3, 55.2, 58.1, 58.3, 60.3, 61.9] Q11, avg: 17.4, detail: [17.7, 17.9, 16.8, 18.0, 16.6, 17.3] Q12, avg: 36.5, detail: [37.2, 35.8, 35.8, 38.8, 37.3, 34.3] Q13, avg: 56.0, detail: [54.2, 54.6, 53.4, 60.0, 58.7, 54.9] Q14, avg: 13.0, detail: [13.8, 13.2, 12.6, 13.1, 12.6, 13.0] Q16, avg: 176.9, detail: [202.5, 154.2, 161.9, 239.8, 126.1] Q19, avg: 54.4, detail: [50.7, 54.3, 52.9, 61.0, 55.9, 51.9] Q22, avg: 85.2, detail: [83.3, 86.7, 84.5, 86.5, 84.9] ``` * CH-0007: partitions=32, decoders=4, encoders=16 ``` Q01, avg: 11.4, detail: [9.9, 12.0, 11.8, 11.2, 11.9, 11.5] Q02, avg: 44.2, detail: [42.8, 44.9, 42.7, 45.2, 46.3, 43.4] Q03, avg: 67.7, detail: [67.0, 64.7, 78.4, 63.0, 69.8, 63.0] Q04, avg: 298.5, detail: [294.6, 296.7, 292.1, 306.1, 303.4, 298.3] Q05, avg: 124.9, detail: [119.6, 127.0, 129.0, 127.9, 125.4, 120.3] Q06, avg: 4.6, detail: [4.3, 4.6, 4.4, 4.8, 4.9, 4.6] Q07, avg: 88.4, detail: [90.3, 84.0, 87.4, 85.5, 93.4, 89.8] Q08, avg: 137.7, detail: [139.3, 142.5, 133.3, 138.4, 146.6, 125.9] Q09, avg: 179.2, detail: [183.9, 183.0, 178.3, 182.0, 166.3, 181.4] Q10, avg: 57.4, detail: [59.1, 56.2, 58.7, 55.4, 57.8, 57.3] Q11, avg: 18.0, detail: [17.9, 18.1, 18.5, 19.1, 16.9, 17.5] Q12, avg: 37.3, detail: [35.6, 35.6, 36.0, 40.1, 37.0, 39.4] Q13, avg: 56.0, detail: [58.9, 53.6, 57.7, 55.1, 55.8, 54.9] Q14, avg: 13.3, detail: [13.1, 13.4, 13.1, 13.5, 13.4, 13.5] Q16, avg: 197.7, detail: [169.1, 313.6, 157.4, 209.1, 139.5] Q19, avg: 54.4, detail: [53.6, 51.2, 52.3, 61.9, 52.9, 54.6] Q22, avg: 86.6, detail: [84.3, 80.9, 89.8, 93.8, 84.4] ``` * CH-0008: partitions=8, decoders=4, encoders=16 ``` Q01, avg: 10.9, detail: [9.1, 11.7, 11.1, 10.9, 12.3, 10.6] Q02, avg: 43.0, detail: [44.0, 41.7, 41.8, 41.6, 45.3, 43.6] Q03, avg: 66.1, detail: [65.7, 65.8, 63.2, 66.6, 65.2, 70.3] Q04, avg: 300.8, detail: [303.4, 296.3, 299.5, 309.5, 297.6, 298.4] Q05, avg: 130.2, detail: [128.4, 126.8, 135.9, 125.8, 136.1, 128.4] Q06, avg: 4.4, detail: [4.2, 4.2, 4.4, 4.4, 4.3, 4.8] Q07, avg: 91.2, detail: [90.4, 89.8, 94.2, 94.4, 88.1, 90.1] Q08, avg: 143.3, detail: [136.9, 137.7, 164.0, 139.8, 137.1, 144.1] Q09, avg: 183.0, detail: [174.0, 176.3, 195.2, 180.4, 192.4, 180.0] Q10, avg: 55.4, detail: [57.8, 59.7, 53.0, 54.6, 52.9, 54.2] Q11, avg: 16.3, detail: [17.0, 15.5, 16.8, 16.0, 16.6, 16.0] Q12, avg: 39.2, detail: [42.9, 41.8, 37.2, 35.0, 42.2, 35.9] Q13, avg: 64.1, detail: [62.8, 67.0, 63.7, 64.7, 64.0, 62.5] Q14, avg: 12.5, detail: [12.0, 11.8, 13.3, 13.2, 12.5, 12.2] Q16, avg: 569.6, detail: [740.9, 454.4, 648.7, 721.2, 299.5, 553.1] Q19, avg: 55.9, detail: [71.4, 52.8, 52.4, 56.5, 50.9, 51.7] Q22, avg: 92.3, detail: [97.6, 90.8, 94.8, 91.7, 86.4] ``` * CH-0009: partitions=4, decoders=4, encoders=16 ``` Q01, avg: 10.5, detail: [9.2, 11.5, 9.8, 11.0, 9.9, 11.5] Q02, avg: 42.5, detail: [43.8, 43.5, 41.9, 41.8, 42.3, 41.7] Q03, avg: 84.8, detail: [78.8, 81.8, 83.9, 87.2, 92.6, 84.6] Q04, avg: 358.4, detail: [361.3, 355.5, 353.8, 363.9, 355.2, 360.7] Q05, avg: 167.0, detail: [158.0, 168.7, 162.5, 166.5, 183.1, 163.1] Q06, avg: 4.2, detail: [4.4, 4.1, 4.1, 4.3, 4.1, 4.4] Q07, avg: 107.6, detail: [103.9, 107.1, 105.2, 109.5, 110.7, 109.2] Q08, avg: 188.6, detail: [193.1, 182.5, 182.2, 192.0, 195.0, 186.8] Q09, avg: 234.6, detail: [234.1, 230.5, 238.7, 233.7, 227.8, 243.1] Q10, avg: 61.1, detail: [59.0, 62.3, 59.9, 60.7, 61.2, 63.3] Q11, avg: 16.9, detail: [17.2, 17.5, 16.2, 17.2, 16.8, 16.6] Q12, avg: 43.3, detail: [43.4, 42.1, 44.3, 42.4, 44.2, 43.1] Q13, avg: 95.0, detail: [93.9, 95.6, 95.1, 95.8, 97.5, 92.1] Q14, avg: 13.0, detail: [13.0, 12.9, 13.2, 13.5, 12.5, 13.0] Q16, avg: 474.3, detail: [360.0, 433.1, 488.7, 630.5, 459.4] Q19, avg: 55.4, detail: [49.7, 61.1, 47.4, 58.1, 66.8, 49.3] Q22, avg: 111.9, detail: [122.1, 110.5, 106.6, 109.0, 111.2] ``` * CH-0015: partitions=8, decoders=2, encoders=16 ``` Q01, avg: 10.7, detail: [11.3, 11.0, 11.5, 9.7, 10.1] Q02, avg: 43.5, detail: [43.7, 43.8, 44.8, 43.1, 42.0] Q03, avg: 67.1, detail: [60.5, 73.6, 66.3, 67.2, 67.7] Q04, avg: 304.9, detail: [301.2, 306.5, 302.3, 307.1, 307.5] Q05, avg: 131.0, detail: [128.2, 135.0, 136.7, 124.0, 131.3] Q06, avg: 4.5, detail: [4.8, 4.3, 4.7, 4.5, 4.1] Q07, avg: 89.5, detail: [86.2, 87.4, 92.5, 88.6, 92.9] Q08, avg: 144.2, detail: [143.4, 146.3, 140.9, 142.7, 147.8] Q09, avg: 185.6, detail: [192.5, 185.8, 182.6, 176.7, 190.3] Q10, avg: 54.6, detail: [54.2, 53.4, 54.0, 55.2, 56.2] Q11, avg: 16.4, detail: [16.6, 15.8, 17.0, 15.6, 16.8] Q12, avg: 36.5, detail: [37.9, 35.8, 34.3, 37.2, 37.5] Q13, avg: 63.6, detail: [66.9, 62.7, 63.3, 64.9, 60.0] Q14, avg: 12.6, detail: [11.9, 13.1, 12.2, 12.9, 12.8] Q16, avg: 595.6, detail: [379.4, 666.1, 1067.7, 434.6, 430.1] Q19, avg: 51.6, detail: [52.0, 51.0, 52.0, 51.1, 51.8] Q22, avg: 89.4, detail: [81.6, 90.6, 91.0, 91.1, 92.8] ``` * CH-0016: partitions=8, decoders=1, encoders=16 ``` Q01, avg: 10.8, detail: [11.7, 9.7, 10.7, 10.6, 11.3] Q02, avg: 41.6, detail: [43.4, 41.2, 41.1, 40.4, 41.9] Q03, avg: 64.5, detail: [62.5, 61.8, 62.2, 68.6, 67.3] Q04, avg: 309.8, detail: [309.1, 313.2, 315.4, 308.1, 303.3] Q05, avg: 127.6, detail: [126.5, 130.4, 131.3, 121.2, 128.5] Q06, avg: 4.3, detail: [4.2, 4.4, 4.3, 4.2, 4.3] Q07, avg: 87.9, detail: [86.7, 86.3, 87.8, 90.6, 88.0] Q08, avg: 146.8, detail: [156.9, 144.8, 141.2, 143.0, 147.9] Q09, avg: 181.5, detail: [182.8, 189.3, 174.1, 180.8, 180.7] Q10, avg: 55.3, detail: [59.1, 56.4, 51.3, 55.7, 54.0] Q11, avg: 16.6, detail: [16.1, 17.4, 16.4, 16.3, 16.7] Q12, avg: 35.9, detail: [34.8, 37.0, 34.7, 37.3, 35.7] Q13, avg: 63.5, detail: [64.3, 61.1, 61.9, 63.7, 66.3] Q14, avg: 12.3, detail: [11.8, 12.3, 13.9, 11.6, 12.1] Q16, avg: 323.7, detail: [221.0, 348.2, 284.3, 441.2] Q19, avg: 54.6, detail: [52.6, 51.2, 52.5, 63.4, 53.3] Q22, avg: 87.9, detail: [87.5, 84.0, 84.3, 92.4, 91.1] ``` * CH-0017: partitions=4, decoders=2, encoders=16 ``` Q01, avg: 10.1, detail: [9.3, 10.3, 10.9, 9.9, 9.9] Q02, avg: 42.3, detail: [41.8, 42.0, 42.6, 42.3, 42.9] Q03, avg: 81.3, detail: [78.4, 78.5, 84.4, 83.0, 82.3] Q04, avg: 355.7, detail: [353.7, 361.6, 348.8, 359.8, 354.6] Q05, avg: 163.4, detail: [166.5, 163.0, 162.2, 161.4, 163.7] Q06, avg: 4.4, detail: [4.2, 4.3, 4.8, 4.7, 4.2] Q07, avg: 109.3, detail: [111.3, 109.9, 109.6, 103.4, 112.2] Q08, avg: 186.8, detail: [185.4, 198.4, 176.4, 185.6, 188.0] Q09, avg: 242.7, detail: [248.8, 248.6, 243.5, 247.7, 224.8] Q10, avg: 57.8, detail: [60.1, 53.2, 60.9, 60.3, 54.7] Q11, avg: 16.9, detail: [15.9, 18.0, 17.2, 17.0, 16.5] Q12, avg: 42.7, detail: [42.3, 43.3, 42.7, 40.5, 44.8] Q13, avg: 94.4, detail: [97.7, 93.4, 94.2, 94.2, 92.4] Q14, avg: 13.4, detail: [13.0, 13.8, 13.2, 14.0, 12.8] Q16, avg: 428.4, detail: [412.5, 345.3, 421.5, 534.5] Q19, avg: 50.9, detail: [49.4, 49.8, 49.0, 48.3, 57.8] Q22, avg: 114.5, detail: [111.2, 122.7, 104.9, 125.6, 108.3] ``` ## Environment ### Hardware * Intel Xeon E312xx 16 cores 2.4Ghz. * 16G Memory 1600MHz . * SSD 2.0GB+/s. ### Software * CentOS Linux release 7.2.1511 * Spark version 2.1.1 * CH server version 1.1.54310 ### Data Set * TPCH-100 100G data scala