Results of 1 - 3 of about 3 for scanners (0.001 sec.)
- SQL on Apache Arrow 11905
- DuckDB can query multiple different types of Apache Arrow objects. DuckDB pushes the filters of a query that it can translate, such as comparisons, into the scan of an Arrow dataset. Arrow tables, record batches, scanners and RecordBatchRea
...and return as an Arrow Table results = con.sql("SELECT * FROM my_arrow_dataset WHERE i = 2").to_arrow_table() Apache Arrow Scanners Arrow Scanners stored as variables can also be queried as if they were regular tables. Scanners read over a dataset and se... - https://man.mtool.work/duckdb/2.0/guides/python/sql_on_arrow.html
- Data Import 8185
- Recommended Import Methods When importing data from other systems to DuckDB, there are several considerations to take into account. We recommend importing using the following order: For systems which are supported by a DuckDB scanner extens
...ion, it's preferable to use the scanner. DuckDB currently offers scanners for MySQL , PostgreSQL and SQLite , as well as a generic ODBC scanner . If there is a bulk export feature in the data sour... - https://man.mtool.work/duckdb/2.0/guides/performance/import.html
- Data Ingestion 7775
- This page contains examples for data ingestion to Python using DuckDB. First, import the DuckDB package: import duckdb Then, proceed with any of the following sections. CSV Files CSV files can be read using the read_csv function, called eit
...es of Apache Arrow objects including tables , record batches, arrays and chunked arrays, datasets , RecordBatchReaders and scanners . See the Python guides for more examples. The filters of a query are pushed into Arrow datasets and Polars LazyFrames. Ta...bles, record batches, readers, scanners and Polars DataFrames are read whole, and the filter applies to what they return. A RecordBatchReader can be read once. A... - https://man.mtool.work/duckdb/2.0/clients/python/data_ingestion.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work