- using R version 4.3.3 (2024-02-29 ucrt)
- using platform: x86_64-w64-mingw32 (64-bit)
- R was compiled by
gcc.exe (GCC) 12.3.0
GNU Fortran (GCC) 12.3.0
- running under: Windows Server 2022 x64 (build 20348)
- using session charset: UTF-8
- checking for file 'parquetize/DESCRIPTION' ... OK
- checking extension type ... Package
- this is package 'parquetize' version '0.5.7'
- package encoding: UTF-8
- checking package namespace information ... OK
- checking package dependencies ... OK
- checking if this is a source package ... OK
- checking if there is a namespace ... OK
- checking for hidden files and directories ... OK
- checking for portable file names ... OK
- checking whether package 'parquetize' can be installed ... OK
See the install log for details.
- checking installed package size ... OK
- checking package directory ... OK
- checking 'build' directory ... OK
- checking DESCRIPTION meta-information ... OK
- checking top-level files ... OK
- checking for left-over files ... OK
- checking index information ... OK
- checking package subdirectories ... OK
- checking R files for non-ASCII characters ... OK
- checking R files for syntax errors ... OK
- checking whether the package can be loaded ... [3s] OK
- checking whether the package can be loaded with stated dependencies ... [2s] OK
- checking whether the package can be unloaded cleanly ... [2s] OK
- checking whether the namespace can be loaded with stated dependencies ... [2s] OK
- checking whether the namespace can be unloaded cleanly ... [3s] OK
- checking loading without being on the library search path ... [3s] OK
- checking use of S3 registration ... OK
- checking dependencies in R code ... OK
- checking S3 generic/method consistency ... OK
- checking replacement functions ... OK
- checking foreign function calls ... OK
- checking R code for possible problems ... [7s] OK
- checking Rd files ... [1s] OK
- checking Rd metadata ... OK
- checking Rd cross-references ... OK
- checking for missing documentation entries ... OK
- checking for code/documentation mismatches ... OK
- checking Rd \usage sections ... OK
- checking Rd contents ... OK
- checking for unstated dependencies in examples ... OK
- checking installed files from 'inst/doc' ... OK
- checking files in 'vignettes' ... OK
- checking examples ... [13s] ERROR
Running examples in 'parquetize-Ex.R' failed
The error most likely occurred in:
> ### Name: csv_to_parquet
> ### Title: Convert a csv or a txt file to parquet format
> ### Aliases: csv_to_parquet
>
> ### ** Examples
>
>
> # Conversion from a local csv file to a single parquet file :
>
> csv_to_parquet(
+ path_to_file = parquetize_example("region_2022.csv"),
+ path_to_parquet = tempfile(fileext=".parquet")
+ )
Reading data...
Writing data...
✔ Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpAjzjKE\file285e4705e1155.parquet
Writing data...
Reading data...
>
> # Conversion from a local txt file to a single parquet file :
>
> csv_to_parquet(
+ path_to_file = parquetize_example("region_2022.txt"),
+ path_to_parquet = tempfile(fileext=".parquet")
+ )
Reading data...
Writing data...
✔ Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpAjzjKE\file285e4447f5000.parquet
Writing data...
Reading data...
>
> # Conversion from a local csv file to a single parquet file and select only
> # few columns :
>
> csv_to_parquet(
+ path_to_file = parquetize_example("region_2022.csv"),
+ path_to_parquet = tempfile(fileext = ".parquet"),
+ columns = c("REG","LIBELLE")
+ )
Reading data...
Writing data...
✔ Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpAjzjKE\file285e448ed2c87.parquet
Writing data...
Reading data...
>
> # Conversion from a local csv file to a partitioned parquet file :
>
> csv_to_parquet(
+ path_to_file = parquetize_example("region_2022.csv"),
+ path_to_parquet = tempfile(fileext = ".parquet"),
+ partition = "yes",
+ partitioning = c("REG")
+ )
Reading data...
Writing data...
✔ Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpAjzjKE\file285e4748c6a31.parquet
Writing data...
Reading data...
>
> # Conversion from a URL and a zipped file (csv) :
>
> csv_to_parquet(
+ path_to_file = "https://www.nomisweb.co.uk/output/census/2021/census2021-ts007.zip",
+ filename_in_zip = "census2021-ts007-ctry.csv",
+ path_to_parquet = tempfile(fileext = ".parquet")
+ )
Error in curl_download(path, tempfile(fileext = file_ext(path))) :
Timeout was reached [www.nomisweb.co.uk]: Failed to connect to www.nomisweb.co.uk port 443 after 10008 ms: Timeout was reached
Calls: csv_to_parquet ... download_extract -> curl_download -> raise_libcurl_error
Execution halted
- checking for unstated dependencies in 'tests' ... OK
- checking tests ... [23s] ERROR
Running 'testthat.R' [22s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> # This file is part of the standard setup for testthat.
> # It is recommended that you do not modify it.
> #
> # Where should you do additional test configuration?
> # Learn more about the roles of various files in:
> # * https://r-pkgs.org/tests.html
> # * https://testthat.r-lib.org/reference/test_package.html#special-files
>
> library(testthat)
> library(parquetize)
>
> test_check("parquetize")
i checking: D:/RCompile/CRANpkg/lib/4.3/parquetize/extdata/iris.sqlite
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc13387dde
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc1c4c743c
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc608574d5
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc3bdf4ae5
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc42636cc7
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc5b6c677e
Writing data...
Reading data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc654e4dc7
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc1cfd3678
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc47201ee7
Writing data...
Reading data...
Reading data...
Writing data in part-1-49.parquet...
Reading data...
Writing data in part-50-98.parquet...
Reading data...
Writing data in part-99-147.parquet...
Reading data...
Writing data in part-148-150.parquet...
v Parquet dataset is available under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc665d735e/
Writing data in part-148-150.parquet...
Reading data...
Writing data in part-1-42.parquet...
Reading data...
Writing data in part-43-84.parquet...
Reading data...
Writing data in part-85-126.parquet...
Reading data...
Writing data in part-127-150.parquet...
v Parquet dataset is available under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc4bff5aa3/
Writing data in part-127-150.parquet...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc54883761
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc3292ec2
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc26412ec5
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc35487a8b
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc2ee5512d
Writing data...
Reading data...
v The test_data parquet file is available under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc18a23d36
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc103d1657
Writing data...
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc20a5608b
Writing data...
Reading data...
Reading data...
Reading data...
Writing data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc5c8d6664
Writing data...
Writing data...
Reading data...
Writing data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326ccf23428
Writing data...
Writing data...
Reading data...
Writing file326cc35362b81-1-50.parquet...
Reading data...
Writing file326cc35362b81-51-100.parquet...
Reading data...
Writing file326cc35362b81-101-150.parquet...
Reading data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc35362b81/
Reading data...
Reading data...
Writing file326cc6fc91db4-1-150.parquet...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc6fc91db4/
Writing file326cc6fc91db4-1-150.parquet...
Reading data...
Writing file326cc1efb633d-1-150.parquet...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc1efb633d/
Writing file326cc1efb633d-1-150.parquet...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc35a851d2
Writing data...
Reading data...
v The D:/RCompile/CRANpkg/lib/4.3/haven/examples/iris.sas7bdat file is available in parquet format under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc35a851d2
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc5275455
Writing data...
Reading data...
v The D:/RCompile/CRANpkg/lib/4.3/haven/examples/iris.sav file is available in parquet format under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc5275455
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc7d8b69e3
Writing data...
Reading data...
v The D:/RCompile/CRANpkg/lib/4.3/haven/examples/iris.dta file is available in parquet format under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc7d8b69e3
Reading data...
Reading data...
Writing file326cc19f5207f-1-50.parquet...
Reading data...
Writing file326cc19f5207f-51-100.parquet...
Reading data...
Writing file326cc19f5207f-101-150.parquet...
Reading data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc19f5207f/
Reading data...
Reading data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc48e82e80
Writing data...
Reading data...
v The D:/RCompile/CRANpkg/lib/4.3/haven/examples/iris.sas7bdat file is available in parquet format under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc48e82e80
Reading data...
Reading data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc4b911992
Writing data...
Reading data...
v The D:/RCompile/CRANpkg/lib/4.3/haven/examples/iris.sas7bdat file is available in parquet format under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc4b911992
Reading data...
Reading data...
Writing file326cc7924446f-1-50.parquet...
Reading data...
Writing file326cc7924446f-51-100.parquet...
Reading data...
Writing file326cc7924446f-101-150.parquet...
Reading data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc7924446f/
Reading data...
Writing data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc91d177b/file326cc91d177b.parquet
Writing data...
Writing data...
Writing data...
Writing data...
v Data are available in parquet file under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc6e11212a
Writing data...
Writing data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc29234f49
Writing data...
Reading data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc22ac28bc/
Reading data...
Reading data...
Writing file326cc7a3a187d-1-50.parquet...
Reading data...
Writing file326cc7a3a187d-51-100.parquet...
Reading data...
Writing file326cc7a3a187d-101-150.parquet...
Reading data...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc7a3a187d/
Reading data...
Reading data...
Writing file326cc713e218a-1-43.parquet...
Reading data...
Writing file326cc713e218a-44-86.parquet...
Reading data...
Writing file326cc713e218a-87-129.parquet...
Reading data...
Writing file326cc713e218a-130-150.parquet...
v Data are available in parquet dataset under D:\temp\2025_03_10_01_50_00_13582\RtmpGo6WYU\file326cc713e218a/
Writing file326cc713e218a-130-150.parquet...
[ FAIL 1 | WARN 0 | SKIP 3 | PASS 192 ]
══ Skipped tests (3) ═══════════════════════════════════════════════════════════
• On CRAN (3): 'test-csv_to_parquet.R:54:3', 'test-download_extract.R:16:3',
'test-download_extract.R:43:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Error ('test-csv_to_parquet.R:33:3'): Checks url_to_csv argument is deprecated ──
<curl_error_operation_timedout/curl_error/error/condition>
Error in `curl_download(path, tempfile(fileext = file_ext(path)))`: Timeout was reached [github.com]: Failed to connect to github.com port 443 after 10016 ms: Timeout was reached
Backtrace:
▆
1. ├─testthat::expect_warning(...) at test-csv_to_parquet.R:33:3
2. │ └─testthat:::expect_condition_matching(...)
3. │ └─testthat:::quasi_capture(...)
4. │ ├─testthat (local) .capture(...)
5. │ │ └─base::withCallingHandlers(...)
6. │ └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
7. ├─parquetize::csv_to_parquet(...)
8. │ └─parquetize::download_extract(path_to_file, filename_in_zip)
9. │ └─curl::curl_download(path, tempfile(fileext = file_ext(path)))
10. └─curl:::raise_libcurl_error(...)
[ FAIL 1 | WARN 0 | SKIP 3 | PASS 192 ]
Error: Test failures
In addition: Warning message:
call dbDisconnect() when finished working with a connection
Execution halted
- checking for unstated dependencies in vignettes ... OK
- checking package vignettes in 'inst/doc' ... OK
- checking re-building of vignette outputs ... [4s] OK
- checking PDF version of manual ... [16s] OK
- checking HTML version of manual ... [3s] OK
- DONE
Status: 2 ERRORs