[jira] [Commented] (ARROW-17208) Removing files after reading them in R

["Neal Richardson (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-17208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17571547#comment-17571547 ] 

Neal Richardson commented on ARROW-17208:
-----------------------------------------

Thanks for the report. Could you please share your session information? There are some reports from Windows that sound similar to this (ARROW-17002, ARROW-16421).

> Removing files after reading them in R
> --------------------------------------
>
>                 Key: ARROW-17208
>                 URL: https://issues.apache.org/jira/browse/ARROW-17208
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: R
>    Affects Versions: 7.0.1
>            Reporter: Wytze Gelderloos
>            Priority: Minor
>
> In R it's not possible to delete the files eventhough the dataframe is cleared from the R environment. 
>  
> write.csv(mtcars, file = "mtcars.csv", quote = FALSE, row.names = FALSE)
> df <- arrow::to_duckdb(arrow::open_dataset("mtcars.csv", format = "csv", delimiter = ","))
> df <- df %>% select(c("mpg", "disp", "drat", "wt")) %>% collect()
> ## Do some checks on df.
> rm(df)
> file.remove("mtcars.csv")
> The `file.remove` leads to a Permission Denied error eventhough the dataframe is cleared from the R environment. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)