You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@gluten.apache.org by "lgbo-ustc (via GitHub)" <gi...@apache.org> on 2024/05/29 09:48:09 UTC
[PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
lgbo-ustc opened a new pull request, #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913
## What changes were proposed in this pull request?
(Please fill in changes proposed in this fix)
Fixes: #5904
## How was this patch tested?
(Please explain how this patch was tested. E.g. unit tests, integration tests, manual tests)
unit tests
(If this patch involves UI changes, please attach a screenshot; otherwise, remove this)
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "GlutenPerfBot (via GitHub)" <gi...@apache.org>.
GlutenPerfBot commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2140567463
===== Performance report for TPCDS SF2000 with Velox backend, for reference only ====
<table border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td><font color=#000000>query</font></td>
<td><font color=#000000>log/native_master_05_30_2024_time.csv</font></td>
<td><font color=#000000>log/native_master_05_29_2024_588faae351_time.csv</font></td>
<td><font color=#000000>difference</font></td>
<td><font color=#000000>percentage</font></td>
</tr>
<tr>
<td><font color=#F92663>q1</font></td>
<td><font color=#F92663>16.16</font></td>
<td><font color=#F92663>16.97</font></td>
<td><font color=#F92663>0.809</font></td>
<td><font color=#F92663>105.00%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q2</font></td>
<td><font color=#6F9915>17.99</font></td>
<td><font color=#6F9915>14.94</font></td>
<td><font color=#6F9915>-3.055</font></td>
<td><font color=#6F9915>83.02%</font></td>
</tr>
<tr>
<td><font color=#F92663>q3</font></td>
<td><font color=#F92663>4.11</font></td>
<td><font color=#F92663>4.96</font></td>
<td><font color=#F92663>0.842</font></td>
<td><font color=#F92663>120.45%</font></td>
</tr>
<tr>
<td><font color=#F92663>q4</font></td>
<td><font color=#F92663>63.57</font></td>
<td><font color=#F92663>64.00</font></td>
<td><font color=#F92663>0.431</font></td>
<td><font color=#F92663>100.68%</font></td>
</tr>
<tr>
<td><font color=#F92663>q5</font></td>
<td><font color=#F92663>6.41</font></td>
<td><font color=#F92663>7.81</font></td>
<td><font color=#F92663>1.402</font></td>
<td><font color=#F92663>121.88%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q6</font></td>
<td><font color=#6F9915>4.02</font></td>
<td><font color=#6F9915>2.42</font></td>
<td><font color=#6F9915>-1.607</font></td>
<td><font color=#6F9915>60.06%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q7</font></td>
<td><font color=#6F9915>6.02</font></td>
<td><font color=#6F9915>5.64</font></td>
<td><font color=#6F9915>-0.383</font></td>
<td><font color=#6F9915>93.64%</font></td>
</tr>
<tr>
<td><font color=#F92663>q8</font></td>
<td><font color=#F92663>3.22</font></td>
<td><font color=#F92663>5.59</font></td>
<td><font color=#F92663>2.366</font></td>
<td><font color=#F92663>173.39%</font></td>
</tr>
<tr>
<td><font color=#F92663>q9</font></td>
<td><font color=#F92663>15.38</font></td>
<td><font color=#F92663>18.71</font></td>
<td><font color=#F92663>3.324</font></td>
<td><font color=#F92663>121.61%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q10</font></td>
<td><font color=#6F9915>9.77</font></td>
<td><font color=#6F9915>9.65</font></td>
<td><font color=#6F9915>-0.121</font></td>
<td><font color=#6F9915>98.76%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q11</font></td>
<td><font color=#6F9915>35.41</font></td>
<td><font color=#6F9915>35.04</font></td>
<td><font color=#6F9915>-0.368</font></td>
<td><font color=#6F9915>98.96%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q12</font></td>
<td><font color=#6F9915>1.39</font></td>
<td><font color=#6F9915>1.39</font></td>
<td><font color=#6F9915>-0.005</font></td>
<td><font color=#6F9915>99.64%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q13</font></td>
<td><font color=#6F9915>6.91</font></td>
<td><font color=#6F9915>6.52</font></td>
<td><font color=#6F9915>-0.392</font></td>
<td><font color=#6F9915>94.33%</font></td>
</tr>
<tr>
<td><font color=#F92663>q14a</font></td>
<td><font color=#F92663>42.34</font></td>
<td><font color=#F92663>44.10</font></td>
<td><font color=#F92663>1.758</font></td>
<td><font color=#F92663>104.15%</font></td>
</tr>
<tr>
<td><font color=#F92663>q14b</font></td>
<td><font color=#F92663>40.78</font></td>
<td><font color=#F92663>43.05</font></td>
<td><font color=#F92663>2.272</font></td>
<td><font color=#F92663>105.57%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q15</font></td>
<td><font color=#6F9915>3.62</font></td>
<td><font color=#6F9915>2.47</font></td>
<td><font color=#6F9915>-1.143</font></td>
<td><font color=#6F9915>68.40%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q16</font></td>
<td><font color=#6F9915>41.71</font></td>
<td><font color=#6F9915>39.09</font></td>
<td><font color=#6F9915>-2.618</font></td>
<td><font color=#6F9915>93.72%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q17</font></td>
<td><font color=#6F9915>5.67</font></td>
<td><font color=#6F9915>5.64</font></td>
<td><font color=#6F9915>-0.031</font></td>
<td><font color=#6F9915>99.46%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q18</font></td>
<td><font color=#6F9915>7.97</font></td>
<td><font color=#6F9915>6.47</font></td>
<td><font color=#6F9915>-1.506</font></td>
<td><font color=#6F9915>81.12%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q19</font></td>
<td><font color=#6F9915>3.66</font></td>
<td><font color=#6F9915>1.91</font></td>
<td><font color=#6F9915>-1.746</font></td>
<td><font color=#6F9915>52.27%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q20</font></td>
<td><font color=#6F9915>1.71</font></td>
<td><font color=#6F9915>1.21</font></td>
<td><font color=#6F9915>-0.499</font></td>
<td><font color=#6F9915>70.83%</font></td>
</tr>
<tr>
<td><font color=#F92663>q21</font></td>
<td><font color=#F92663>1.16</font></td>
<td><font color=#F92663>2.41</font></td>
<td><font color=#F92663>1.248</font></td>
<td><font color=#F92663>207.83%</font></td>
</tr>
<tr>
<td><font color=#F92663>q22</font></td>
<td><font color=#F92663>8.18</font></td>
<td><font color=#F92663>8.78</font></td>
<td><font color=#F92663>0.604</font></td>
<td><font color=#F92663>107.39%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q23a</font></td>
<td><font color=#6F9915>82.34</font></td>
<td><font color=#6F9915>81.60</font></td>
<td><font color=#6F9915>-0.741</font></td>
<td><font color=#6F9915>99.10%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q23b</font></td>
<td><font color=#6F9915>103.12</font></td>
<td><font color=#6F9915>102.04</font></td>
<td><font color=#6F9915>-1.081</font></td>
<td><font color=#6F9915>98.95%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q24a</font></td>
<td><font color=#6F9915>76.11</font></td>
<td><font color=#6F9915>76.07</font></td>
<td><font color=#6F9915>-0.039</font></td>
<td><font color=#6F9915>99.95%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q24b</font></td>
<td><font color=#6F9915>77.12</font></td>
<td><font color=#6F9915>68.64</font></td>
<td><font color=#6F9915>-8.482</font></td>
<td><font color=#6F9915>89.00%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q25</font></td>
<td><font color=#6F9915>4.16</font></td>
<td><font color=#6F9915>4.14</font></td>
<td><font color=#6F9915>-0.023</font></td>
<td><font color=#6F9915>99.46%</font></td>
</tr>
<tr>
<td><font color=#F92663>q26</font></td>
<td><font color=#F92663>2.74</font></td>
<td><font color=#F92663>3.07</font></td>
<td><font color=#F92663>0.323</font></td>
<td><font color=#F92663>111.76%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q27</font></td>
<td><font color=#6F9915>3.14</font></td>
<td><font color=#6F9915>3.01</font></td>
<td><font color=#6F9915>-0.130</font></td>
<td><font color=#6F9915>95.86%</font></td>
</tr>
<tr>
<td><font color=#F92663>q28</font></td>
<td><font color=#F92663>20.18</font></td>
<td><font color=#F92663>22.76</font></td>
<td><font color=#F92663>2.571</font></td>
<td><font color=#F92663>112.74%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q29</font></td>
<td><font color=#6F9915>7.78</font></td>
<td><font color=#6F9915>6.60</font></td>
<td><font color=#6F9915>-1.178</font></td>
<td><font color=#6F9915>84.85%</font></td>
</tr>
<tr>
<td><font color=#F92663>q30</font></td>
<td><font color=#F92663>4.10</font></td>
<td><font color=#F92663>4.28</font></td>
<td><font color=#F92663>0.187</font></td>
<td><font color=#F92663>104.56%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q31</font></td>
<td><font color=#6F9915>9.67</font></td>
<td><font color=#6F9915>5.97</font></td>
<td><font color=#6F9915>-3.703</font></td>
<td><font color=#6F9915>61.71%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q32</font></td>
<td><font color=#6F9915>1.05</font></td>
<td><font color=#6F9915>0.96</font></td>
<td><font color=#6F9915>-0.095</font></td>
<td><font color=#6F9915>90.96%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q33</font></td>
<td><font color=#6F9915>6.48</font></td>
<td><font color=#6F9915>4.84</font></td>
<td><font color=#6F9915>-1.642</font></td>
<td><font color=#6F9915>74.65%</font></td>
</tr>
<tr>
<td><font color=#F92663>q34</font></td>
<td><font color=#F92663>5.05</font></td>
<td><font color=#F92663>6.25</font></td>
<td><font color=#F92663>1.195</font></td>
<td><font color=#F92663>123.66%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q35</font></td>
<td><font color=#6F9915>7.08</font></td>
<td><font color=#6F9915>6.40</font></td>
<td><font color=#6F9915>-0.688</font></td>
<td><font color=#6F9915>90.28%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q36</font></td>
<td><font color=#6F9915>3.14</font></td>
<td><font color=#6F9915>2.98</font></td>
<td><font color=#6F9915>-0.162</font></td>
<td><font color=#6F9915>94.83%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q37</font></td>
<td><font color=#6F9915>4.14</font></td>
<td><font color=#6F9915>3.86</font></td>
<td><font color=#6F9915>-0.275</font></td>
<td><font color=#6F9915>93.36%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q38</font></td>
<td><font color=#6F9915>12.25</font></td>
<td><font color=#6F9915>12.00</font></td>
<td><font color=#6F9915>-0.247</font></td>
<td><font color=#6F9915>97.98%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q39a</font></td>
<td><font color=#6F9915>3.33</font></td>
<td><font color=#6F9915>3.22</font></td>
<td><font color=#6F9915>-0.113</font></td>
<td><font color=#6F9915>96.60%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q39b</font></td>
<td><font color=#6F9915>2.96</font></td>
<td><font color=#6F9915>2.75</font></td>
<td><font color=#6F9915>-0.211</font></td>
<td><font color=#6F9915>92.88%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q40</font></td>
<td><font color=#6F9915>5.75</font></td>
<td><font color=#6F9915>4.75</font></td>
<td><font color=#6F9915>-1.004</font></td>
<td><font color=#6F9915>82.54%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q41</font></td>
<td><font color=#6F9915>0.61</font></td>
<td><font color=#6F9915>0.58</font></td>
<td><font color=#6F9915>-0.030</font></td>
<td><font color=#6F9915>95.15%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q42</font></td>
<td><font color=#6F9915>1.01</font></td>
<td><font color=#6F9915>0.86</font></td>
<td><font color=#6F9915>-0.145</font></td>
<td><font color=#6F9915>85.65%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q43</font></td>
<td><font color=#6F9915>6.53</font></td>
<td><font color=#6F9915>3.47</font></td>
<td><font color=#6F9915>-3.063</font></td>
<td><font color=#6F9915>53.12%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q44</font></td>
<td><font color=#6F9915>7.48</font></td>
<td><font color=#6F9915>6.87</font></td>
<td><font color=#6F9915>-0.615</font></td>
<td><font color=#6F9915>91.78%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q45</font></td>
<td><font color=#6F9915>4.23</font></td>
<td><font color=#6F9915>3.47</font></td>
<td><font color=#6F9915>-0.756</font></td>
<td><font color=#6F9915>82.12%</font></td>
</tr>
<tr>
<td><font color=#F92663>q46</font></td>
<td><font color=#F92663>3.36</font></td>
<td><font color=#F92663>5.11</font></td>
<td><font color=#F92663>1.752</font></td>
<td><font color=#F92663>152.16%</font></td>
</tr>
<tr>
<td><font color=#F92663>q47</font></td>
<td><font color=#F92663>14.68</font></td>
<td><font color=#F92663>15.72</font></td>
<td><font color=#F92663>1.040</font></td>
<td><font color=#F92663>107.08%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q48</font></td>
<td><font color=#6F9915>4.52</font></td>
<td><font color=#6F9915>4.50</font></td>
<td><font color=#6F9915>-0.021</font></td>
<td><font color=#6F9915>99.54%</font></td>
</tr>
<tr>
<td><font color=#F92663>q49</font></td>
<td><font color=#F92663>7.27</font></td>
<td><font color=#F92663>7.64</font></td>
<td><font color=#F92663>0.368</font></td>
<td><font color=#F92663>105.06%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q50</font></td>
<td><font color=#6F9915>28.60</font></td>
<td><font color=#6F9915>22.54</font></td>
<td><font color=#6F9915>-6.058</font></td>
<td><font color=#6F9915>78.82%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q51</font></td>
<td><font color=#6F9915>12.71</font></td>
<td><font color=#6F9915>8.32</font></td>
<td><font color=#6F9915>-4.390</font></td>
<td><font color=#6F9915>65.46%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q52</font></td>
<td><font color=#6F9915>1.22</font></td>
<td><font color=#6F9915>1.01</font></td>
<td><font color=#6F9915>-0.213</font></td>
<td><font color=#6F9915>82.61%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q53</font></td>
<td><font color=#6F9915>1.86</font></td>
<td><font color=#6F9915>1.74</font></td>
<td><font color=#6F9915>-0.128</font></td>
<td><font color=#6F9915>93.12%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q54</font></td>
<td><font color=#6F9915>3.27</font></td>
<td><font color=#6F9915>3.06</font></td>
<td><font color=#6F9915>-0.219</font></td>
<td><font color=#6F9915>93.30%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q55</font></td>
<td><font color=#6F9915>1.02</font></td>
<td><font color=#6F9915>0.98</font></td>
<td><font color=#6F9915>-0.043</font></td>
<td><font color=#6F9915>95.75%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q56</font></td>
<td><font color=#6F9915>4.61</font></td>
<td><font color=#6F9915>4.27</font></td>
<td><font color=#6F9915>-0.346</font></td>
<td><font color=#6F9915>92.51%</font></td>
</tr>
<tr>
<td><font color=#F92663>q57</font></td>
<td><font color=#F92663>8.39</font></td>
<td><font color=#F92663>8.43</font></td>
<td><font color=#F92663>0.041</font></td>
<td><font color=#F92663>100.49%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q58</font></td>
<td><font color=#6F9915>2.52</font></td>
<td><font color=#6F9915>2.52</font></td>
<td><font color=#6F9915>-0.008</font></td>
<td><font color=#6F9915>99.68%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q59</font></td>
<td><font color=#6F9915>14.36</font></td>
<td><font color=#6F9915>13.85</font></td>
<td><font color=#6F9915>-0.514</font></td>
<td><font color=#6F9915>96.42%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q60</font></td>
<td><font color=#6F9915>7.22</font></td>
<td><font color=#6F9915>4.58</font></td>
<td><font color=#6F9915>-2.636</font></td>
<td><font color=#6F9915>63.49%</font></td>
</tr>
<tr>
<td><font color=#F92663>q61</font></td>
<td><font color=#F92663>5.36</font></td>
<td><font color=#F92663>6.91</font></td>
<td><font color=#F92663>1.543</font></td>
<td><font color=#F92663>128.78%</font></td>
</tr>
<tr>
<td><font color=#F92663>q62</font></td>
<td><font color=#F92663>4.60</font></td>
<td><font color=#F92663>5.46</font></td>
<td><font color=#F92663>0.854</font></td>
<td><font color=#F92663>118.56%</font></td>
</tr>
<tr>
<td><font color=#F92663>q63</font></td>
<td><font color=#F92663>1.85</font></td>
<td><font color=#F92663>1.91</font></td>
<td><font color=#F92663>0.066</font></td>
<td><font color=#F92663>103.55%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q64</font></td>
<td><font color=#6F9915>48.79</font></td>
<td><font color=#6F9915>48.49</font></td>
<td><font color=#6F9915>-0.303</font></td>
<td><font color=#6F9915>99.38%</font></td>
</tr>
<tr>
<td><font color=#F92663>q65</font></td>
<td><font color=#F92663>13.99</font></td>
<td><font color=#F92663>15.70</font></td>
<td><font color=#F92663>1.708</font></td>
<td><font color=#F92663>112.21%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q66</font></td>
<td><font color=#6F9915>4.09</font></td>
<td><font color=#6F9915>3.11</font></td>
<td><font color=#6F9915>-0.979</font></td>
<td><font color=#6F9915>76.06%</font></td>
</tr>
<tr>
<td><font color=#F92663>q67</font></td>
<td><font color=#F92663>352.23</font></td>
<td><font color=#F92663>353.82</font></td>
<td><font color=#F92663>1.592</font></td>
<td><font color=#F92663>100.45%</font></td>
</tr>
<tr>
<td><font color=#F92663>q68</font></td>
<td><font color=#F92663>3.55</font></td>
<td><font color=#F92663>3.62</font></td>
<td><font color=#F92663>0.075</font></td>
<td><font color=#F92663>102.11%</font></td>
</tr>
<tr>
<td><font color=#F92663>q69</font></td>
<td><font color=#F92663>6.89</font></td>
<td><font color=#F92663>9.38</font></td>
<td><font color=#F92663>2.491</font></td>
<td><font color=#F92663>136.16%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q70</font></td>
<td><font color=#6F9915>11.89</font></td>
<td><font color=#6F9915>8.84</font></td>
<td><font color=#6F9915>-3.044</font></td>
<td><font color=#6F9915>74.39%</font></td>
</tr>
<tr>
<td><font color=#F92663>q71</font></td>
<td><font color=#F92663>2.28</font></td>
<td><font color=#F92663>2.28</font></td>
<td><font color=#F92663>0.003</font></td>
<td><font color=#F92663>100.12%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q72</font></td>
<td><font color=#6F9915>189.26</font></td>
<td><font color=#6F9915>187.72</font></td>
<td><font color=#6F9915>-1.547</font></td>
<td><font color=#6F9915>99.18%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q73</font></td>
<td><font color=#6F9915>2.47</font></td>
<td><font color=#6F9915>2.29</font></td>
<td><font color=#6F9915>-0.188</font></td>
<td><font color=#6F9915>92.42%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q74</font></td>
<td><font color=#6F9915>21.57</font></td>
<td><font color=#6F9915>21.11</font></td>
<td><font color=#6F9915>-0.455</font></td>
<td><font color=#6F9915>97.89%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q75</font></td>
<td><font color=#6F9915>23.78</font></td>
<td><font color=#6F9915>23.43</font></td>
<td><font color=#6F9915>-0.350</font></td>
<td><font color=#6F9915>98.53%</font></td>
</tr>
<tr>
<td><font color=#F92663>q76</font></td>
<td><font color=#F92663>7.14</font></td>
<td><font color=#F92663>7.32</font></td>
<td><font color=#F92663>0.187</font></td>
<td><font color=#F92663>102.62%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q77</font></td>
<td><font color=#6F9915>1.99</font></td>
<td><font color=#6F9915>1.85</font></td>
<td><font color=#6F9915>-0.143</font></td>
<td><font color=#6F9915>92.79%</font></td>
</tr>
<tr>
<td><font color=#F92663>q78</font></td>
<td><font color=#F92663>39.27</font></td>
<td><font color=#F92663>40.94</font></td>
<td><font color=#F92663>1.671</font></td>
<td><font color=#F92663>104.25%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q79</font></td>
<td><font color=#6F9915>3.46</font></td>
<td><font color=#6F9915>3.38</font></td>
<td><font color=#6F9915>-0.086</font></td>
<td><font color=#6F9915>97.51%</font></td>
</tr>
<tr>
<td><font color=#F92663>q80</font></td>
<td><font color=#F92663>10.72</font></td>
<td><font color=#F92663>10.89</font></td>
<td><font color=#F92663>0.164</font></td>
<td><font color=#F92663>101.53%</font></td>
</tr>
<tr>
<td><font color=#F92663>q81</font></td>
<td><font color=#F92663>4.37</font></td>
<td><font color=#F92663>4.55</font></td>
<td><font color=#F92663>0.186</font></td>
<td><font color=#F92663>104.26%</font></td>
</tr>
<tr>
<td><font color=#F92663>q82</font></td>
<td><font color=#F92663>6.12</font></td>
<td><font color=#F92663>6.34</font></td>
<td><font color=#F92663>0.226</font></td>
<td><font color=#F92663>103.70%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q83</font></td>
<td><font color=#6F9915>4.86</font></td>
<td><font color=#6F9915>1.49</font></td>
<td><font color=#6F9915>-3.371</font></td>
<td><font color=#6F9915>30.63%</font></td>
</tr>
<tr>
<td><font color=#F92663>q84</font></td>
<td><font color=#F92663>3.11</font></td>
<td><font color=#F92663>4.82</font></td>
<td><font color=#F92663>1.713</font></td>
<td><font color=#F92663>155.09%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q85</font></td>
<td><font color=#6F9915>7.19</font></td>
<td><font color=#6F9915>6.85</font></td>
<td><font color=#6F9915>-0.346</font></td>
<td><font color=#6F9915>95.19%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q86</font></td>
<td><font color=#6F9915>3.42</font></td>
<td><font color=#6F9915>3.24</font></td>
<td><font color=#6F9915>-0.185</font></td>
<td><font color=#6F9915>94.59%</font></td>
</tr>
<tr>
<td><font color=#F92663>q87</font></td>
<td><font color=#F92663>12.45</font></td>
<td><font color=#F92663>12.48</font></td>
<td><font color=#F92663>0.021</font></td>
<td><font color=#F92663>100.17%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q88</font></td>
<td><font color=#6F9915>19.92</font></td>
<td><font color=#6F9915>16.41</font></td>
<td><font color=#6F9915>-3.511</font></td>
<td><font color=#6F9915>82.38%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q89</font></td>
<td><font color=#6F9915>2.67</font></td>
<td><font color=#6F9915>2.61</font></td>
<td><font color=#6F9915>-0.055</font></td>
<td><font color=#6F9915>97.95%</font></td>
</tr>
<tr>
<td><font color=#F92663>q90</font></td>
<td><font color=#F92663>3.10</font></td>
<td><font color=#F92663>3.25</font></td>
<td><font color=#F92663>0.149</font></td>
<td><font color=#F92663>104.81%</font></td>
</tr>
<tr>
<td><font color=#F92663>q91</font></td>
<td><font color=#F92663>2.55</font></td>
<td><font color=#F92663>2.57</font></td>
<td><font color=#F92663>0.021</font></td>
<td><font color=#F92663>100.80%</font></td>
</tr>
<tr>
<td><font color=#F92663>q92</font></td>
<td><font color=#F92663>1.26</font></td>
<td><font color=#F92663>2.46</font></td>
<td><font color=#F92663>1.196</font></td>
<td><font color=#F92663>194.98%</font></td>
</tr>
<tr>
<td><font color=#F92663>q93</font></td>
<td><font color=#F92663>29.54</font></td>
<td><font color=#F92663>30.56</font></td>
<td><font color=#F92663>1.016</font></td>
<td><font color=#F92663>103.44%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q94</font></td>
<td><font color=#6F9915>21.44</font></td>
<td><font color=#6F9915>21.42</font></td>
<td><font color=#6F9915>-0.018</font></td>
<td><font color=#6F9915>99.92%</font></td>
</tr>
<tr>
<td><font color=#F92663>q9</font></td>
<td><font color=#F92663>79.31</font></td>
<td><font color=#F92663>81.92</font></td>
<td><font color=#F92663>2.609</font></td>
<td><font color=#F92663>103.29%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q5</font></td>
<td><font color=#6F9915>6.30</font></td>
<td><font color=#6F9915>5.38</font></td>
<td><font color=#6F9915>-0.926</font></td>
<td><font color=#6F9915>85.31%</font></td>
</tr>
<tr>
<td><font color=#F92663>q96</font></td>
<td><font color=#F92663>11.87</font></td>
<td><font color=#F92663>12.10</font></td>
<td><font color=#F92663>0.233</font></td>
<td><font color=#F92663>101.96%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q97</font></td>
<td><font color=#6F9915>2.05</font></td>
<td><font color=#6F9915>1.83</font></td>
<td><font color=#6F9915>-0.218</font></td>
<td><font color=#6F9915>89.34%</font></td>
</tr>
<tr>
<td><font color=#F92663>q98</font></td>
<td><font color=#F92663>8.74</font></td>
<td><font color=#F92663>9.29</font></td>
<td><font color=#F92663>0.552</font></td>
<td><font color=#F92663>106.31%</font></td>
</tr>
<tr>
<td><font color=#F92663>q99</font></td>
<td><font color=#F92663>8.74</font></td>
<td><font color=#F92663>9.29</font></td>
<td><font color=#F92663>0.552</font></td>
<td><font color=#F92663>106.31%</font></td>
</tr>
<tr>
<td><font color=#6F9915>total</font></td>
<td><font color=#6F9915>1909.84</font></td>
<td><font color=#6F9915>1882.45</font></td>
<td><font color=#6F9915>-27.390</font></td>
<td><font color=#6F9915>98.57%</font></td>
</tr>
</tbody>
</table>
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2137002067
https://github.com/apache/incubator-gluten/issues/5904
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "GlutenPerfBot (via GitHub)" <gi...@apache.org>.
GlutenPerfBot commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2140732909
===== Performance report for TPCH SF2000 with Velox backend, for reference only ====
<table border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td><font color=#000000>query</font></td>
<td><font color=#000000>log/native_master_05_30_2024_time.csv</font></td>
<td><font color=#000000>log/native_master_05_29_2024_588faae35_time.csv</font></td>
<td><font color=#000000>difference</font></td>
<td><font color=#000000>percentage</font></td>
</tr>
<tr>
<td><font color=#6F9915>q1</font></td>
<td><font color=#6F9915>34.62</font></td>
<td><font color=#6F9915>33.56</font></td>
<td><font color=#6F9915>-1.064</font></td>
<td><font color=#6F9915>96.93%</font></td>
</tr>
<tr>
<td><font color=#F92663>q2</font></td>
<td><font color=#F92663>23.80</font></td>
<td><font color=#F92663>23.85</font></td>
<td><font color=#F92663>0.052</font></td>
<td><font color=#F92663>100.22%</font></td>
</tr>
<tr>
<td><font color=#F92663>q3</font></td>
<td><font color=#F92663>37.04</font></td>
<td><font color=#F92663>37.37</font></td>
<td><font color=#F92663>0.338</font></td>
<td><font color=#F92663>100.91%</font></td>
</tr>
<tr>
<td><font color=#F92663>q4</font></td>
<td><font color=#F92663>32.22</font></td>
<td><font color=#F92663>32.42</font></td>
<td><font color=#F92663>0.198</font></td>
<td><font color=#F92663>100.61%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q5</font></td>
<td><font color=#6F9915>70.41</font></td>
<td><font color=#6F9915>69.83</font></td>
<td><font color=#6F9915>-0.581</font></td>
<td><font color=#6F9915>99.17%</font></td>
</tr>
<tr>
<td><font color=#F92663>q6</font></td>
<td><font color=#F92663>7.25</font></td>
<td><font color=#F92663>7.54</font></td>
<td><font color=#F92663>0.293</font></td>
<td><font color=#F92663>104.04%</font></td>
</tr>
<tr>
<td><font color=#F92663>q7</font></td>
<td><font color=#F92663>81.31</font></td>
<td><font color=#F92663>81.75</font></td>
<td><font color=#F92663>0.441</font></td>
<td><font color=#F92663>100.54%</font></td>
</tr>
<tr>
<td><font color=#F92663>q8</font></td>
<td><font color=#F92663>85.87</font></td>
<td><font color=#F92663>86.57</font></td>
<td><font color=#F92663>0.696</font></td>
<td><font color=#F92663>100.81%</font></td>
</tr>
<tr>
<td><font color=#F92663>q9</font></td>
<td><font color=#F92663>118.14</font></td>
<td><font color=#F92663>118.35</font></td>
<td><font color=#F92663>0.213</font></td>
<td><font color=#F92663>100.18%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q10</font></td>
<td><font color=#6F9915>45.74</font></td>
<td><font color=#6F9915>44.16</font></td>
<td><font color=#6F9915>-1.581</font></td>
<td><font color=#6F9915>96.54%</font></td>
</tr>
<tr>
<td><font color=#F92663>q11</font></td>
<td><font color=#F92663>21.64</font></td>
<td><font color=#F92663>22.23</font></td>
<td><font color=#F92663>0.587</font></td>
<td><font color=#F92663>102.71%</font></td>
</tr>
<tr>
<td><font color=#F92663>q12</font></td>
<td><font color=#F92663>22.83</font></td>
<td><font color=#F92663>26.72</font></td>
<td><font color=#F92663>3.894</font></td>
<td><font color=#F92663>117.06%</font></td>
</tr>
<tr>
<td><font color=#F92663>q13</font></td>
<td><font color=#F92663>52.00</font></td>
<td><font color=#F92663>53.60</font></td>
<td><font color=#F92663>1.607</font></td>
<td><font color=#F92663>103.09%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q14</font></td>
<td><font color=#6F9915>18.87</font></td>
<td><font color=#6F9915>17.59</font></td>
<td><font color=#6F9915>-1.274</font></td>
<td><font color=#6F9915>93.24%</font></td>
</tr>
<tr>
<td><font color=#F92663>q15</font></td>
<td><font color=#F92663>32.69</font></td>
<td><font color=#F92663>32.89</font></td>
<td><font color=#F92663>0.206</font></td>
<td><font color=#F92663>100.63%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q16</font></td>
<td><font color=#6F9915>13.77</font></td>
<td><font color=#6F9915>13.41</font></td>
<td><font color=#6F9915>-0.358</font></td>
<td><font color=#6F9915>97.40%</font></td>
</tr>
<tr>
<td><font color=#F92663>q17</font></td>
<td><font color=#F92663>101.66</font></td>
<td><font color=#F92663>103.62</font></td>
<td><font color=#F92663>1.969</font></td>
<td><font color=#F92663>101.94%</font></td>
</tr>
<tr>
<td><font color=#F92663>q18</font></td>
<td><font color=#F92663>143.98</font></td>
<td><font color=#F92663>144.53</font></td>
<td><font color=#F92663>0.551</font></td>
<td><font color=#F92663>100.38%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q19</font></td>
<td><font color=#6F9915>14.76</font></td>
<td><font color=#6F9915>13.59</font></td>
<td><font color=#6F9915>-1.171</font></td>
<td><font color=#6F9915>92.06%</font></td>
</tr>
<tr>
<td><font color=#F92663>q20</font></td>
<td><font color=#F92663>28.58</font></td>
<td><font color=#F92663>29.66</font></td>
<td><font color=#F92663>1.071</font></td>
<td><font color=#F92663>103.75%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q21</font></td>
<td><font color=#6F9915>265.55</font></td>
<td><font color=#6F9915>260.43</font></td>
<td><font color=#6F9915>-5.128</font></td>
<td><font color=#6F9915>98.07%</font></td>
</tr>
<tr>
<td><font color=#6F9915>q22</font></td>
<td><font color=#6F9915>14.49</font></td>
<td><font color=#6F9915>13.84</font></td>
<td><font color=#6F9915>-0.651</font></td>
<td><font color=#6F9915>95.51%</font></td>
</tr>
<tr>
<td><font color=#F92663>total</font></td>
<td><font color=#F92663>1267.19</font></td>
<td><font color=#F92663>1267.50</font></td>
<td><font color=#F92663>0.308</font></td>
<td><font color=#F92663>100.02%</font></td>
</tr>
</tbody>
</table>
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2137011200
Run Gluten Clickhouse CI
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2137043566
Run Gluten Clickhouse CI
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2139043089
Run Gluten Clickhouse CI
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2137002575
Run Gluten Clickhouse CI
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "zzcclp (via GitHub)" <gi...@apache.org>.
zzcclp merged PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org
Re: [PR] [GLUTEN-5904][CH] Convert `nan` to `null` which comes from `stddev` [incubator-gluten]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #5913:
URL: https://github.com/apache/incubator-gluten/pull/5913#issuecomment-2138772042
Run Gluten Clickhouse CI
--
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: commits-unsubscribe@gluten.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org