Results of 1 - 10 of about 39 for about (0.004 sec.)
- DuckDB_% Metadata Functions – DuckDB 17197
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Meta Queries Copy Markdown DuckDB_% Metadata Functions 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...at are not marked as internal: SELECT * FROM duckdb_views ; duckdb_columns The duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains...decimal separator). INTEGER The information_schema.columns system view provides a more standardized way to obtain metadata about database columns, but the duckdb_columns function also returns metadata about DuckDB internal objects. (In fact, informati... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Dutch Railway Datasets – DuckDB 9037
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...YES NULL NULL NULL Stop:Departure cancelled BOOLEAN YES NULL NULL NULL Datasets Yearly Data Sets The yearly data sets are about 350 MB each. 2019 2020 2021 2022 2023 2024 Monthly Data Sets The monthly data sets are about 30 MB each. 2024-01 2024-02 2...ワード Stop Service datasets cancelled Datasets services delay Arrival Departure Dutch Railway column Station time Sets sets about Documentation Guides Snippets Copy Markdown Examples documentation often 関連するページ Hugging Face Support USE Statement... - https://man.mtool.work/duckdb/1.3/guides/snippets/dutch_railway_datasets.html
- SQL Introduction – DuckDB 8504
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...characters ( -- ) introduce comments. Whatever follows them is ignored up to the end of the line. SQL is case-insensitive about keywords and identifiers. When returning identifiers, their original cases are preserved . In the SQL command, we first sp...94-11-27 San Francisco -194.000 53.000 San Francisco 43 57 0.0 1994-11-29 San Francisco -194.000 53.000 Observe two things about the result set: There is no result row for the city of Hayward. This is because there is no matching entry in the cities t...ard 37 which gives us the same results for only the cities that have all temp_lo values below 40. Finally, if we only care about cities whose names begin with S , we can use the LIKE operator: SELECT city , max ( temp_lo ) FROM weather WHERE city LIKE... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- JSON Overview – DuckDB 8191
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...-loaded on first use. If you would like to install or load it manually, please consult the “Installing and Loading” page . About JSON JSON is an open standard file format and data interchange format that uses human-readable text to store and transmit...Report content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article About JSON JSONPath and JSON Pointer Syntax Indexing Examples Loading JSON Writing JSON JSON Data Type Retrieving JSON Data Usin... - https://man.mtool.work/duckdb/1.3/data/json/overview.html
- List Functions – DuckDB 8191
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t. list_reverse_sort(list) Sorts the elements of the list in reverse order. See the Sorting Lists section for more details about the NULL sorting order. list_reverse(list) Reverses the list. list_select(value_list, index_list) Returns a list based on...are accepted. See slicing . list_sort(list) Sorts the elements of the list. See the Sorting Lists section for more details about the sorting order and the NULL sorting order. list_transform(list, lambda) Returns a list that is the result of applying t...rse_sort(list) Description Sorts the elements of the list in reverse order. See the Sorting Lists section for more details about the NULL sorting order. Example list_reverse_sort([3, 6, 1, 2]) Result [6, 3, 2, 1] Alias array_reverse_sort list_reverse(... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Integration with Ibis – DuckDB 7972
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...… │ … │ … │ … │ └───────────┴────────────────┴───────────────┴───────────────────┴─────────────┴───────┘ You can read more about selectors in the docs! order_by order_by arranges the values of one or more columns in ascending or descending order. By d...with aggregate . There's nothing stopping us from putting all of these concepts together to ask questions of the data. How about: What was the largest female penguin (by body mass) on each island in the year 2008? penguins . filter (( penguins . sex =...────────┼──────────────────┤ │ Biscoe │ 5200 │ │ Torgersen │ 3800 │ │ Dream │ 3900 │ └───────────┴──────────────────┘ What about the largest male penguin (by body mass) on each island for each year of data collection? penguins . filter ( penguins . se... - https://man.mtool.work/duckdb/1.3/guides/python/ibis.html
- Storage Versions and Format – DuckDB 7972
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...to keep data stored in DuckDB files around and guarantees that you will be able to read the files without having to worry about which version the file was written with or having to convert files between versions. Forward Compatibility Forward compati...to Move between Storage Formats When you update DuckDB and open an old database file, you might encounter an error message about incompatible storage formats, pointing to this page. To move your database(s) to newer format you only need the older and... - https://man.mtool.work/duckdb/1.3/internals/storage.html
- Information Schema – DuckDB 7768
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...re 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's information schema . Tables character_sets :...se NULL for other types of constraints. VARCHAR 'YES' Catalog Functions Several functions are also provided to see details about the catalogs and schemas that are configured in the database. Function Description Example Result current_catalog() Return... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Pragmas – DuckDB 7659
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...pecific table: PRAGMA table_info ( 'table_name' ); CALL pragma_table_info ( 'table_name' ); table_info returns information about the columns of the table with name table_name . The exact format of the table returned is given below: cid INTEGER , -- ci...e and memory size of each database: PRAGMA database_size ; CALL pragma_database_size (); database_size returns information about the file and memory size of each database. The column types of the returned results are given below: database_name VARCHAR... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Benchmarks – DuckDB 7659
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nning benchmarks on DuckDB, please make sure you are using the latest version (preferably the preview build ). If in doubt about your benchmark results, feel free to contact us at [email protected] . Disclaimer on Benchmarks Note that the benchmark re... - https://man.mtool.work/duckdb/1.3/guides/performance/benchmarks.html
DuckDB 1.3 Documentation / man.mtool.work