Results of 1 - 10 of about 64 for operations (0.001 sec.)
- Core Extensions 13080
- List of Core Extensions Name Description Maintainer Support tier Aliases autocomplete Autocompletion for CLI client DuckDB team avro Avro files reading DuckDB team aws AWS S3 functionality DuckDB team azure Filesystem abstraction for Azure
...team excel Excel ( .xlsx ) read/write DuckDB team fts Full-text search DuckDB team httpfs HTTP(S) and S3 - file read/write operations DuckDB team http, https, s3 iceberg Apache Iceberg table format DuckDB team icu Time zones, calendars and collations DuckD...B team inet IP-related data types and functions DuckDB team json JSON operations DuckDB team lance Lance tables read/write Third party legacy_parser Legacy PostgreSQL-derived SQL parser DuckDB team mothe...rduck MotherDuck connectivity Third party md mysql MySQL database read/write operations DuckDB team mysql_scanner odbc ODBC connectivity DuckDB team odbc_scanner parquet Parquet files read/write DuckDB team pos... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Writing to Iceberg 10883
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...Supported Operations The iceberg extension supports the following operations when used with a REST Catalog attached: CREATE/DROP SCHEMA CREATE/...DROP TABLE INSERT INTO UPDATE DELETE MERGE INTO ALTER TABLE SELECT Since these operations are supported, the following will also work: COPY FROM DATABASE duckdb_db TO iceberg_datalake; -- Or COPY FROM DATABASE ic...Schema Evolution The ALTER TABLE statement is supported against Iceberg tables, covering the most common schema-evolution operations: -- Rename the table ALTER TABLE iceberg_catalog.default.simple_table RENAME TO renamed_table; -- Add a column ALTER TABLE... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- SQLite Extension 10740
- 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
...DB, use the ATTACH statement with the sqlite or sqlite_scanner type. Attached SQLite databases support both read and write operations. For example, to attach to the sakila.db file , run: ATTACH 'sakila.db' (TYPE sqlite); USE sakila; The tables in the file...w_sqlite_database.db SQLite version 3.39.5 2022-10-14 20:58:05 sqlite> SELECT * FROM tbl; id name -- ------ 42 DuckDB Many operations on SQLite tables are supported. All these operations directly modify the SQLite database, and the result of subsequent ope...me Description Default sqlite_debug_show_queries DEBUG SETTING: print all queries sent to SQLite to stdout false Supported Operations Below is a list of supported operations. CREATE TABLE CREATE TABLE sqlite_db.tbl (id INTEGER, name VARCHAR); INSERT INTO I... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Overview 10309
- We designed DuckDB to be easy to deploy and operate. We believe that most users do not need to consult the pages of the operations manual. However, there are certain setups – e.g., when DuckDB is running in mission-critical infrastructure –
...where we would like to offer advice on how to configure DuckDB. The operations manual contains advice for these cases and also offers convenient configuration snippets such as Gitignore files. For advi... - https://man.mtool.work/duckdb/2.0/operations_manual/overview.html
- Order Preservation 9577
- For many operations, DuckDB preserves the order of rows, similarly to data frame libraries such as Pandas. Example Take the following table for example: CREATE TABLE tbl AS SELECT * FROM (VALUES (1, 'a'), (2, 'b'), (3, 'c')) t(x, y); SELECT
...nents Tip row_number() OVER () allows turning the original row order into an explicit column that can be referenced in the operations that don't preserve row order by default. On materialized tables, the rowid pseudo-column can be used to the same effect....The following operations do not guarantee that the row order is preserved: FROM with multiple tables and/or subqueries JOIN UNION USING SAMPLE Whol... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- MySQL Extension 9132
- 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.
...b (TYPE mysql); CREATE TABLE mysql_db.tbl (id INTEGER, name VARCHAR); INSERT INTO mysql_db.tbl VALUES (42, 'DuckDB'); Many operations on MySQL tables are supported. All these operations directly modify the MySQL database, and the result of subsequent opera...For example: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql, READ_ONLY); Supported Operations Below is a list of supported operations. CREATE TABLE CREATE TABLE mysql_db.tbl (id INTEGER, name VARCHAR); INSERT INTO IN... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Set Operations 8988
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...while the variants with ALL use bag semantics. Traditional set operations unify queries by column position , and require the to-be-combined queries to have the same number of input columns. If the... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Relational API on Pandas 8701
- 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
...ation from a dataframe rel = con.from_df(input_df) # chain together relational operators (this is a lazy operation, so the operations are not yet executed) # equivalent to: SELECT i, j, i*2 AS two_i FROM input_df WHERE i >= 2 ORDER BY i DESC LIMIT 2 transf... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
- Indexing 8557
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...hanges on indexed tables perform worse than their non-indexed counterparts. That is because of index maintenance for these operations. For some use cases, single-column ART indexes improve the performance of highly selective queries using the indexed colum.... Indexes and Opening Databases Indexes are serialized to disk and deserialized lazily, i.e., when reopening the database. Operations using the index will only load the required parts of the index. Therefore, having an index will not cause any slowdowns wh... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Typecasting 8557
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...though this is not possible for regular implicit casts. This combination casting occurs for comparisons ( = / < / > ), set operations ( UNION / EXCEPT / INTERSECT ), and nested type constructors ( list_value / [...] / MAP ). Casting Operations Matrix Value...d to revert to the old behavior. However, please note that this flag will be deprecated in the future. Lossy Casts Casting operations that result in loss of precision are allowed. For example, it is possible to explicitly cast a numeric type with fractiona...ELECT CAST(-1.7 AS INTEGER); -- -2 The applicable rounding rules can be found on the NUMERIC type page . Overflows Casting operations that would result in a value overflow throw an error. For example, the value 999 is too large to be represented by the TIN... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
DuckDB 2.0 Documentation / man.mtool.work