Teague Sterling

Results 8 comments of Teague Sterling

Here's a example that I've been playing with that will compute summary stats (using `describe`) for a data frame. It's a bit long winded still. The example usage references the...

> Thanks for the example, @teaguesterling ! I should note that the whole derived datasets idea is somewhat experimental and provides multiple ways to achieve what you want; flexibility at...

It has been quite a while, and I'm no longer involved in ZINC but I believe there was an extended maintenance period that resulted in numerous services being down. It...

I'm running into this error with the json extension in 0.8.1 using R 4.2.1 as well. Counter to what was said above, only the parquet seems to be built by...

> Hey, @teaguesterling > Try to use the `FILE_EXTENSION "csv.gz"` parameter with your `COPY` command: > ```sql > COPY (FROM ...) TO 'table.csv.d' (FORMAT 'csv', COMPRESSION 'gzip', FILE_EXTENSION 'csv.gz', PARTITION_BY...

And a fifth. I was not aware of the experimental filter pushdown flag, but the extra overhead from paging made the connector far too slow to use for day-to-day queries...

I tested this in a sandbox and `SET pg_use_ctid_scan=false` along with `SET pg_experimental_filter_pushdown=true` worked well for WHERE clauses. Aggregates didn't push down, but that was not expected.

This was split up into multiple PRs