Results of 1 - 10 of about 11 for though (0.003 sec.)
- Typecasting 13300
- 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
...nt than regular implicit casts. For example, a BOOL value may be cast to INT (with true mapping to 1 and false to 0 ) even though this is not possible for regular implicit casts. This combination casting occurs for comparisons ( = / < / > ), set operat...TE E I I I TIME E I E TIMESTAMP E E E I I E TIMESTAMP WITH TIME ZONE E E E I E TIME WITH TIME ZONE E E I INTERVAL E I Even though a casting operation is supported based on the source and target data type, a cast operation may still fail at runtime if i...ion Error: Type INT32 with value 999 can't be cast because the value is out of range for the destination type INT8 So even though the cast operation from INTEGER to TINYINT is supported, it is not possible for this particular value. TRY_CAST can be use... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Statically Linking Extensions 11415
- 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
...ENSIONS='json;parquet;icu' could not reuse the object files of a build with CORE_EXTENSIONS='json;parquet;icu;tpch' , even though one is a subset of the other. DuckDB 2.0 modularized this into a link-time decision ( duckdb#25814 ). Each extension is co...fail at runtime. For example, SELECT to_minutes(5) reports that the function exists in the core_functions extension, even though that extension was linked in. A program can also skip the generated loader and call duckdb_register_static_extension direc... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Legacy Authentication Scheme for S3 API 9531
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...cessKey2&s3_secret_access_key=secretKey2' t2; Configuration Some additional configuration options exist for the S3 upload, though the default values should suffice for most use cases. Additionally, most of the configuration options can be set via envir... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Spatial Functions 8588
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...they hear "longitude"/"latitude" or "GPS coordinates"), which is defined as having a [latitude, longitude] axis order even though [longitude, latitude] is commonly used in practice (e.g. in GeoJSON ). More details available in the PROJ documentation ....ys_xy` parameter to force the input geometry to be interpreted as having -- a [northing, easting] axis order instead, even though the source coordinate -- reference system definition (WGS84) says otherwise. SELECT ST_Transform( -- note the axis order i...of sibling files that are required to open the file. E.g., the ESRI Shapefile driver requires a .shx file to be present. Although most of the time these can be discovered automatically. spatial_filter_box BOX_2D If set to a BOX_2D, the table function w... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- S3 API Support 8108
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...part_col_b=⟨val⟩/data_⟨thread_number⟩.parquet Configuration Some additional configuration options exist for the S3 upload, though the default values should suffice for most use cases. Name Description Default s3_uploader_max_parts_per_file Used for par... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- R-Tree Indexes 8108
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...ial relationship with a specific region of interest. Unfortunately, even though DuckDB's vectorized execution engine is pretty fast, this sort of operation does not scale very well to large datasets as... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- CSV Auto Detection 8108
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...e specified using the auto_type_candidates option, in order of priority: Types TINYINT SMALLINT INTEGER DECIMAL FLOAT Even though the set of data types that can be automatically detected may appear quite limited, the CSV reader can be configured to rea... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Tuning Workloads 8108
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...re again on every query. To reuse cached data regardless of these headers, set enable_external_file_cache explicitly, even though it is enabled by default: SET enable_external_file_cache = true; Cached data is still validated against the remote file as...tion will work best, but a connection pool may also be used. Using multiple connections can parallelize some operations, although it is typically not necessary. DuckDB does attempt to parallelize as much as possible within each individual query, but it... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- Pragmas 7646
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...plications can also access profiling information through API calls, in which case users can disable any other output. Even though the parameter reads no_output , it is essential to note that this only affects printing to the configurable output. When a... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- SQL Introduction 7646
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...correct because the lists of columns from the weather and cities tables are concatenated. In practice this is undesirable, though, so you will probably want to list the output columns explicitly rather than using * : SELECT city, temp_lo, temp_hi, prcp... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
DuckDB 2.0 Documentation / man.mtool.work