[
https://issues.apache.org/jira/browse/ARROW-15312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17484718#comment-17484718
]
Dewey Dunnington commented on ARROW-15312:
------------------------------------------
Seems related to the filter pushdown into the Parquet reader! If we write
Parquet with {{write_statistics = FALSE}} we can trigger this too.
{code:R}
library(arrow, warn.conflicts = FALSE)
library(dplyr, warn.conflicts = FALSE)
path <- tempfile()
df <- tibble(
integers = 1:3,
col_with_na_and_one_val = c(0L, 0L, NA_integer_)
)
# should return one row
write_parquet(df, path, write_statistics = TRUE)
open_dataset(path) %>%
filter(is.na(col_with_na_and_one_val)) %>%
collect()
#> # A tibble: 0 × 2
#> # … with 2 variables: integers <int>, col_with_na_and_one_val <int>
write_parquet(df, path, write_statistics = FALSE)
open_dataset(path) %>%
filter(is.na(col_with_na_and_one_val)) %>%
collect()
#> # A tibble: 1 × 2
#> integers col_with_na_and_one_val
#> <int> <int>
#> 1 3 NA
{code}
> [R][C++] filtering a Parquet dataset with is.na() misses some rows
> ------------------------------------------------------------------
>
> Key: ARROW-15312
> URL: https://issues.apache.org/jira/browse/ARROW-15312
> Project: Apache Arrow
> Issue Type: Bug
> Components: R
> Affects Versions: 6.0.1
> Environment: R 4.1.2 on Windows
> arrow 6.0.1
> dplyr 1.0.7
> Reporter: Pierre Gramme
> Priority: Blocker
> Fix For: 8.0.0, 7.0.1
>
>
> Hi !
> I just found an issue when querying an Arrow dataset with dplyr, filtering on
> is.na(...)
> It seems linked to columns containing only one distinct value and some NA's.
> Can you also reproduce the following?
>
> {code:java}
> library(arrow)
> library(dplyr)
>
> ds_path = "test-arrow-na"
> df = tibble(x=1:3, y=c(0L, 0L, NA_integer_), z=c(0L, 1L, NA_integer_))
>
> df %>% arrow::write_dataset(ds_path)
>
> # OK: Collect then filter: returns row 3, as expected
> arrow::open_dataset(ds_path) %>% collect() %>% filter(is.na(y))
> # ERROR: Filter then collect (on y) returns a tibble with no row
> arrow::open_dataset(ds_path) %>% filter(is.na(y)) %>% collect()
>
> # OK: Filter then collect (on z) returns row 3, as expected
> arrow::open_dataset(ds_path) %>% filter(is.na(z)) %>% collect() {code}
>
> Thanks
> Pierre
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
