[jira] [Comment Edited] (ARROW-15602) [R] can't read timestamp with timezone from CSV (or other delimited) file

["Dragoș Moldovan-Grünfeld (Jira)" <ji...@apache.org>]

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

Dragoș Moldovan-Grünfeld edited comment on ARROW-15602 at 3/8/22, 10:12 AM:
----------------------------------------------------------------------------

Just to add to your example, reading without any {{col_types}} specification seems to work fine:
{code:r}
arrow::read_csv_arrow(tf, col_names = "x", skip = 1)
#> # A tibble: 1 × 1
#>   x                  
#>   <dttm>             
#> 1 2004-04-01 03:00:00
{code}
I think it might also be related to ARROW-14477. Have you tried with timezone as string? I think support for timezone as offset is a bit trickier.


was (Author: dragosmg):
Just to add to your example, reading without any {{col_types}} specification seems to work fine:
{code:r}
arrow::read_csv_arrow(tf, col_names = "x", skip = 1)
#> # A tibble: 1 × 1
#>   x                  
#>   <dttm>             
#> 1 2004-04-01 03:00:00
{code}

I think it might also be related to ARROW-14477

> [R] can't read timestamp with timezone from CSV (or other delimited) file
> -------------------------------------------------------------------------
>
>                 Key: ARROW-15602
>                 URL: https://issues.apache.org/jira/browse/ARROW-15602
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: R
>         Environment: R version 4.1.2 (2021-11-01)
> Platform: x86_64-pc-linux-gnu (64-bit)
> Running under: Ubuntu 20.04.3 LTS
>            Reporter: SHIMA Tatsuya
>            Priority: Major
>
> The following values in a csv file can be read as timestamp by `pyarrow.csv.read_csv` and `readr::read_csv`, but not by `arrow::read_csv_arrow`.
> {code}
> "x"
> "2004-04-01T12:00+09:00"
> {code}



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