| ==== |
| ---- QUERY |
| # IMPALA-6527, IMPALA-6538: NaN values lead to incorrect filtering. |
| # When the first value is NaN in a column chunk, Impala might choose it as min_value and |
| # max_value for statistics. In this case the min/max filter should be ignored. |
| # 'min_max_is_nan' is written by an old writer, therefore it contains invalid statistics. |
| select * from min_max_is_nan where val > 0 |
| ---- RESULTS |
| 42 |
| ==== |
| ---- QUERY |
| # IMPALA-6527, IMPALA-6538: NaN values lead to incorrect filtering |
| # test equality predicate |
| select * from min_max_is_nan where val = 42 |
| ---- RESULTS |
| 42 |
| ==== |
| ---- QUERY |
| # IMPALA-6527: NaN values lead to incorrect filtering |
| # test predicate that is true for NaN |
| select * from min_max_is_nan where not val >= 0 |
| ---- RESULTS |
| NaN |
| ==== |
| ---- QUERY |
| # IMPALA-6527: NaN values lead to incorrect filtering |
| # test predicate that is true for NaN |
| select * from min_max_is_nan where val != 0 |
| ---- RESULTS |
| NaN |
| 42 |
| ==== |