Results of 1 - 10 of about 35 for underlying (0.002 sec.)
- Share a DuckDB Database That Only Stores Views 13159
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...catalog: anyone who attaches it sees a set of named, ready-to-query relations, while the underlying data stays in its original location and format. This is useful for publishing a curated “semantic layer” over a data lake,...ns FROM catalog.stations; Consumers need the httpfs extension and, for s3:// sources, credentials that grant access to the underlying data. Limitations Consumers must be able to access both the catalog file and every data source that its views reference. C... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- MySQL Extension 11186
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...e key file Reading MySQL Tables The tables in the MySQL database can be read as if they were normal DuckDB tables, but the underlying data is read directly from MySQL at query time. SHOW ALL TABLES; name signed_integers SELECT * FROM signed_integers; t s m...if modifications are not desired, ATTACH can be run with the READ_ONLY property which prevents making modifications to the underlying database. For example: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql, READ_ONLY);... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Information Schema 10788
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...n DuckDB. VARCHAR NULL user_defined_type_catalog If the table is a typed table, the name of the database that contains the underlying data type (always the current database), else NULL . Currently unimplemented. VARCHAR NULL user_defined_type_schema If the...table is a typed table, the name of the schema that contains the underlying data type, else NULL . Currently unimplemented. VARCHAR NULL user_defined_type_name If the table is a typed table, the nam...e of the underlying data type, else NULL . Currently unimplemented. VARCHAR NULL is_insertable_into YES if the table is insertable into, NO if... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- PostgreSQL Extension 10391
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...S p (TYPE postgres); Usage The tables in the PostgreSQL database can be read as if they were normal DuckDB tables, but the underlying data is read directly from PostgreSQL at query time. SHOW ALL TABLES; name uuids SELECT * FROM uuids; u 6d3d2541-710b-4bde...if modifications are not desired, ATTACH can be run with the READ_ONLY property which prevents making modifications to the underlying database. For example: ATTACH 'dbname=postgresscanner' AS postgres_db (TYPE postgres, READ_ONLY); Below is a list of suppo... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- SQLite Extension 9595
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...CH 'sakila.db' (TYPE sqlite); USE sakila; The tables in the file can be read as if they were normal DuckDB tables, but the underlying data is read directly from the SQLite tables in the file at query time. SHOW TABLES; name actor address category city coun... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Relational API on Pandas 9197
- DuckDB offers a relational API that can be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can poin
...t to any underlying storage format that DuckDB can read, such as CSV or Parquet files, etc.). Here we show a simple example of reading from a... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
- CREATE VIEW Statement 9197
- The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT
...f the same name already exists, it is replaced. CREATE SECURE VIEW defines a view that does not leak information about the underlying tables through statistics or query plans. Regular views can expose data that the view query would filter out (for example... - https://man.mtool.work/duckdb/2.0/sql/statements/create_view.html
- Vectors 8799
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...ata_chunk_get_size ). All vectors that belong to a data chunk have the same size. Primitive Types For primitive types, the underlying array can be obtained using the duckdb_vector_get_data method. The array can then be accessed using the correct native typ...ameters vector : The vector Return Value The size of the child list duckdb_list_vector_set_size Sets the total size of the underlying child-vector of a list vector. Syntax duckdb_state duckdb_list_vector_set_size ( duckdb_vector vector , idx_t size ); Para...The duckdb state. Returns DuckDBError if the vector is nullptr. duckdb_list_vector_reserve Sets the total capacity of the underlying child-vector of a list. After calling this method, you must call duckdb_vector_get_validity and duckdb_vector_get_data to... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- PIVOT Statement 8799
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...l combinations of unique countries and unique cities receive their own column. Some combinations may not be present in the underlying data, so those columns are populated with NULL values. PIVOT cities ON country, name USING sum(population); year NL_Amster...NULL NULL NULL 8175 608 2020 1158 NULL NULL NULL 8772 738 To pivot only the combinations of values that are present in the underlying data, use an expression in the ON clause. Multiple expressions and/or columns may be provided. Here, country and name are... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Troubleshoot 8020
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
...the crate, so nothing else is needed to build, and it is the simplest choice for most applications. Without bundled , the underlying libduckdb-sys crate links against a DuckDB library already on the system, which it locates through pkg-config or, on the M... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work