⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 11 for layout (0.012 sec.)
OpenHarmony 12553
DuckDB supports building for OpenHarmony (OHOS) AArch64 (ARM64) on a best-effort basis. On this platform, DuckDB reports the platform name openharmony_arm64 . Prebuilt binaries and extensions are not distributed for this platform. Prerequis ... release page can be used for cross-compilation. The repository ships a toolchain file that handles both the Linux x64 SDK layout and the on-device SDK layout. Set OHOS_SDK to the native directory of the SDK: export OHOS_SDK=/path/to/ohos-sdk/linux/nat ...
https://man.mtool.work/duckdb/2.0/dev/building/openharmony.html
Geometry Data Type 10615
Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i ... ed independently using lightweight algorithms - far more efficiently than storing variable-size binary blobs. The shredded layout depends on the geometry type: POINT - STRUCT(X DOUBLE, Y DOUBLE) (and/or Z, M) LINESTRING - STRUCT(X DOUBLE, Y DOUBLE)[] P ... AS geom FROM range(0, 1000) AS rx(x), range(0, 1000) AS ry(y); -- Checkpoint the database to persist the data and storage layout to disk CHECKPOINT; -- Attach a second database ATTACH 'shredded_db.db' AS shredded_db; USE shredded_db; -- This time, set ... y)::GEOMETRY AS geom FROM range(0, 1000) AS rx(x), range(0, 1000) AS ry(y); -- Checkpoint to persist the data and storage layout to disk, and apply shredding CHECKPOINT; -- Now check the storage layout and memory usage of the geometry column in both a ...
https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
Information Schema 10615
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 ... information for columns is information_schema.columns . It lists the columns present in the database and has the following layout: Column Description Type Example table_catalog Name of the database containing the table (always the current database). VA ... view is information_schema.schemata . It lists the catalogs and the schemas present in the database and has the following layout: Column Description Type Example catalog_name Name of the database that the schema is contained in. VARCHAR 'my_db' schema ... tion for tables and views is information_schema.tables . It lists the tables present in the database and has the following layout: Column Description Type Example table_catalog The catalog the table or view belongs to. VARCHAR 'my_db' table_schema The ...
https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
Statically Linking Extensions 9637
This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in ... fills a duckdb_extension_descriptor declared in the new public header duckdb_static_extension.h . The descriptor carries a layout version, so the engine refuses an archive whose descriptor layout it does not support, with a clear message instead of mis ...
https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
Share a DuckDB Database That Only Stores Views 8997
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 ... nd the S3 API are read-only , so the catalog cannot be modified in place. Query performance depends on the network and the layout of the referenced files . The tips for querying remote files apply. 他のマニュアルの関連ページ Linux JM services(5) Django ...
https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
Window Functions 8997
DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o ... History" AS FROM 'power-plant-generation-history.csv'; After partitioning by plant and ordering by date, it will have this layout: Plant Date MWh Boston 2019-01-02 564337 Boston 2019-01-03 507405 Boston 2019-01-04 528523 Boston 2019-01-05 469538 Boston ... lauses can be specified in the same SELECT , and each will be computed separately. Often, however, we want to use the same layout for multiple window functions. The WINDOW clause can be used to define a named window that can be shared between multiple ... NTERVAL 3 DAYS PRECEDING AND INTERVAL 3 DAYS FOLLOWING) ORDER BY 1, 2; The three window functions will also share the data layout, which will improve performance. Multiple windows can be defined in the same WINDOW clause by comma-separating them: SELEC ...
https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
Dot Commands 8037
Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac ... ighter By default, the result highlighting makes a few small modifications: Bold column names. NULL values are greyed out. Layout elements are grayed out. The highlighting of each of the components can be customized using the .highlight_colors command. ... For example: .highlight_colors layout red .highlight_colors column_type yellow .highlight_colors column_name yellow bold_underline .highlight_colors numeric_val ...
https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
Partitioned Writes 7699
Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde ... TH option gives full control over the subdirectory that each partition is written to, replacing the default col=value Hive layout. By default, the PARTITION_BY clause writes each partition to a col=value subdirectory following the Hive partitioning con ...
https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
Struct Data Type 7059
Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys. ... The names of the struct entries are part of the schema . Each row in a STRUCT column must have the same layout. The names of the struct entries are case-insensitive. STRUCT s are typically used to nest multiple columns into a single ...
https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
Configuration 6739
DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi ... sion name. BOOLEAN false arrow_output_list_view Whether the export to the Arrow format should use ListView as the physical layout for LIST columns. BOOLEAN false arrow_output_version Whether strings should be produced by DuckDB in Utf8View format inste ...
https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work