Results of 1 - 7 of about 7 for category (0.004 sec.)
- Relational API 13413
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
..., 'hammer', 'tools', 42, TRUE), (5, 'screwdriver', 'tools', 7, TRUE), (6, 'drill', 'tools', 89, TRUE) ) AS items(id, item, category, price, in_stock) """) rel.set_alias("my_relation").alias Result 'my_relation' columns Return a list containing the names..., 'hammer', 'tools', 42, TRUE), (5, 'screwdriver', 'tools', 7, TRUE), (6, 'drill', 'tools', 89, TRUE) ) AS items(id, item, category, price, in_stock) """) rel.columns Result ['id', 'item', 'category', 'price', 'in_stock'] describe describe(self) -> DuckD..., 'hammer', 'tools', 42, TRUE), (5, 'screwdriver', 'tools', 7, TRUE), (6, 'drill', 'tools', 89, TRUE) ) AS items(id, item, category, price, in_stock) """) rel.describe() Result ┌─────────┬────────────────────┬─────────┬──────────┬───────────────────┬────... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- SQLite Extension 9269
- 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
...but the underlying data is read directly from the SQLite tables in the file at query time. SHOW TABLES; name actor address category city country customer customer_list film film_actor film_category film_list film_text inventory language payment rental sa...les_by_film_category sales_by_store staff staff_list store You can query the tables using SQL, e.g., using the example queries from sakila-exam...ples.sql : SELECT cat.name AS category_name, sum(ifnull(pay.amount, 0)) AS revenue FROM category cat LEFT JOIN film_category flm_cat ON cat.category_id = flm_cat... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- DuckDB_% Metadata Functions 8451
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...des metadata about DuckDB's keywords and reserved words. Column Description Type keyword_name The keyword. VARCHAR keyword_category The category of the keyword: reserved (cannot be used as an identifier without quoting), unreserved (can be used as an ide...) returns only regular settings and omits debug-only and deprecated ones. The debug and deprecated parameters select which category to return instead: for example, duckdb_settings(deprecated := true) returns the deprecated settings and duckdb_settings(de...ame of this data type. The same logical_type may be referenced by several types having different type_name s. VARCHAR type_category The category to which this type belongs. Data types within the same category generally expose similar behavior when values... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- COPY Statement 8215
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...header into the table test : COPY test FROM 'test.csv'; Copy the contents of a comma-separated file with a header into the category table: COPY category FROM 'categories.csv' (HEADER); Copy the contents of lineitem.tbl into the lineitem table, where the...FROM 'lineitem.tbl' (AUTO_DETECT true); Read the contents of a comma-separated file names.csv into the name column of the category table. Any other columns of this table are filled with their default value: COPY category(name) FROM 'names.csv'; Read the... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Variant Functions 8197
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...t_typeof(v) Return the full type of a VARIANT value, including nested structure. variant_type(v) Return the top-level type category of a VARIANT value. variant_keys(v) Return the keys of a VARIANT object as a list. variant_extract(v, field) Extract a nes...riant_typeof('{"a": 1}'::JSON::VARIANT) | | Result | OBJECT(a) | variant_type(v) | Description | Return the top-level type category of a VARIANT value. | | Example | variant_type('{"a": 1}'::JSON::VARIANT) | | Result | OBJECT | variant_keys(v) | Descript... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- Troubleshoot 8015
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...ng DuckDB Errors The client returns a *duckdb.Error for errors reported by DuckDB. Use errors.As to handle these errors by category without parsing their messages: _, err := db.Exec(query) if err != nil { var duckdbError *duckdb.Error if errors.As(err, &... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- FILTER Clause 7979
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
...not work as expected when using an aggregate function that does not ignore NULL values. The first function falls into this category, so FILTER is preferred in this case. “Pivot” the data out by year (move each year out to a separate column): SELECT first... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work