ericemc3

Reading a remote parquet file with a simple WHERE clause results in loading more than twice its size.

3

### What happens? My remote parquet file weighs 7,2 Mo. If i read it with a simple WHERE, more than 15 Mo pass through the network. ### To Reproduce `CREATE...

insertCSVFromPath options and incorrect typing

6

I have a csv file with zip codes (CODGEO) that look like integers  but actually contain characters. Is there a simple way with insertCSVFromPath() to specifiy CODGEO as a...

Could DuckDBClient load (CSV) files by URL ?

1

I'd like an equivalent of `gentoo = d3.csv("https://portal.edirepository.org/nis/dataviewer?packageid=knb-lter-pal.220.7&entityid=e03b43c924f226486f2f0ab6709d2381", d3.autoType)` with DuckDBClient. both ``` DuckDBClient.of({ gentoo: "https://portal.edirepository.org/nis/dataviewer?packageid=knb-lter-pal.220.7&entityid=e03b43c924f226486f2f0ab6709d2381" }) ``` and ``` DuckDBClient.of({ gentoo: { file: "https://portal.edirepository.org/nis/dataviewer?packageid=knb-lter-pal.220.7&entityid=e03b43c924f226486f2f0ab6709d2381" } }) ``` won't work....

update DuckDbClient with DuckDb v 0.8

2

Last DuckDb releases (as of 0.8.0) include PIVOT and UNPIVOT, both very useful SQL features for reshaping data.

Performance issue with parquet and a simple filter

6

### What happens? Six equivalent requests on a big parquet file (26 M records), sorted by a quadkey column. The first two take about 1 second. The next 4 take...

Allow messages translations in gradethis/R/message_generators.R

2

grade_this_code error messages are smart but in english...

Here is a reprex ```{r insee_cc0} question_text( "Please enter proper URL (file download)", allow_retry = TRUE, answer("https://www.insee.fr/fr/statistiques/fichier/4171585/base-cc-serie-histo-2016-xls.zip", correct = TRUE) ) ``` if i copy https://www.insee.fr/fr/statistiques/fichier/4171585/base-cc-serie-histo-2016-xls.zip i get: Incorrect

readxl versus openxlsx

6

Cette affirmation pose la supériorité de openxlsx::read.xlsx sur readxl::read_excel : > Il est recommandé d’utiliser la fonction [read_excel()](https://readxl.tidyverse.org/reference/read_excel.html) du package readxl pour importer des fichiers xls. Cette fonction peut également...

I'd like to translate them in French. Other labels can be modified within `question_parsons`, but apparently not these ones. I tried with a parameter `text = c('drag alternative','construct alternative')` but...

to avoid ST_Dump(geom).unnest(recursive := true) + flaten(list())...