[ 
https://issues.apache.org/jira/browse/ARROW-14722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated ARROW-14722:
-----------------------------------
    Labels: pull-request-available  (was: )

> [R] dplyr::arrange converts number values to negative 
> ------------------------------------------------------
>
>                 Key: ARROW-14722
>                 URL: https://issues.apache.org/jira/browse/ARROW-14722
>             Project: Apache Arrow
>          Issue Type: Bug
>    Affects Versions: 6.0.0
>            Reporter: Mislav Zorko
>            Priority: Blocker
>              Labels: pull-request-available
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> ```
> {code:java}
> # Load libraries
> library(arrow)
> library(dplyr)
> # Store table
> file_path <- tempfile()
> write_parquet(dplyr::tibble(a = 1:10, b = "A"), file_path)
> # Read table 
> my_table <- read_parquet(file_path)
> # Table looks normal
> my_table
> # A tibble: 10 x 2
> #       a b    
> #   <int> <chr>
> # 1     1 A    
> # 2     2 A    
> # 3     3 A    
> # 4     4 A    
> # 5     5 A    
> # 6     6 A    
> # 7     7 A    
> # 8     8 A    
> # 9     9 A    
> # 10    10 A  
> # First arrange changes number values to negative
> my_table %>% arrange(dplyr::desc(a)) 
> # A tibble: 10 x 2
> #       a b    
> #   <int> <chr>
> # 1   -10 A    
> # 2    -9 A    
> # 3    -8 A    
> # 4    -7 A    
> # 5    -6 A    
> # 6    -5 A    
> # 7    -4 A    
> # 8    -3 A    
> # 9    -2 A    
> # 10   -1 A   
> # Even underlying data is changed!!!
> my_table
> # A tibble: 10 x 2
> #       a b    
> #   <int> <chr>
> # 1   -10 A    
> # 2    -9 A    
> # 3    -8 A    
> # 4    -7 A    
> # 5    -6 A    
> # 6    -5 A    
> # 7    -4 A    
> # 8    -3 A    
> # 9    -2 A    
> # 10   -1 A   
> # Second arrange changes it back
> my_table %>% arrange(dplyr::desc(a)) 
> my_table
> # A tibble: 10 x 2
> #       a b    
> #   <int> <chr>
> # 1     1 A    
> # 2     2 A    
> # 3     3 A    
> # 4     4 A    
> # 5     5 A    
> # 6     6 A    
> # 7     7 A    
> # 8     8 A    
> # 9     9 A    
> # 10    10 A  
> {code}
> ```



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to