Results of 1 - 10 of about 11 for basis (0.001 sec.)
- Interval Type 14385
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...Units that aren't months , days , or microseconds are converted to equivalent amounts in the next smaller of these three basis units. SELECT INTERVAL 1 YEAR, -- single unit using YEAR keyword; stored as 12 months INTERVAL (random() * 10) YEAR, -- pa...e the unit in the string or use a more granular unit; e.g., INTERVAL '1.5 years' or INTERVAL 18 MONTHS . Three independent basis units are necessary because a month does not correspond to a fixed amount of days (February has fewer days than March) and...units. To demonstrate this, the following query generates an INTERVAL called period by summing random amounts of the three basis units. It then extracts the aforementioned six parts from period , adds them back together, and confirms that the result i... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Core Extensions 8962
- 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
...support status. Primary extensions are covered by community support . Secondary extensions are supported on a best-effort basis. That said, they still receive frequent bugfixes/updates and are shipped with new DuckDB releases. Backup Repository The c... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Troubleshoot 8588
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
...source for the target, so it requires a working C++ cross-compiler for that target and is supported only on a best-effort basis. When cross-compilation is difficult to set up, link against a prebuilt library for the target with DUCKDB_LIB_DIR instead... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Legacy Authentication Scheme for S3 API 8588
- 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
...paths. Aside from the global S3 configuration described above, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of credentials, regions, etc. These are used by including them on the S3 URI as quer... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Importing Data 8588
- The first step to using a database system is to insert data into that system. DuckDB can directly connect to many popular data sources and offers several data ingestion methods that allow you to easily and efficiently fill up the database.
...ch “root directories” relative paths are expanded on. If file_search_path is not set, the working directory is used as the basis for relative paths. File Formats CSV Loading Data can be efficiently loaded from CSV files using several methods. The simp... - https://man.mtool.work/duckdb/2.0/data/overview.html
- Unofficial and Unsupported Platforms 8588
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- Crashes 8393
- DuckDB is thoroughly tested via an extensive test suite. However, bugs can still occur and these can sometimes lead to crashes. This page contains practical information on how to troubleshoot DuckDB crashes. Types of Crashes There are a few
...rately. If the multi-step approach still exhibits the crash at some step, then the query that triggers the crash is a good basis for a minimal reproducible example. If the multi-step approach works and the multi-step process no longer crashes, try to... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- CSV Auto Detection 8001
- 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
...SCRIBE result.) The sniff_csv() function's Column field returns a struct with column names and types that can be used as a basis for overriding types. Header Detection Header detection works by checking if the candidate header row deviates from the ot... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Storage Versions and Format 8001
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...0.10 . Certain files created by DuckDB 0.10 can be read by DuckDB 0.9. Forward compatibility is provided on a best effort basis. While stability of the storage format is important – there are still many improvements and innovations that we want to ma... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Pragmas 7806
- 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
...created by an instance like so: SET default_block_size = '16384'; It is also possible to set the block size on a per-file basis, see ATTACH for details.... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
DuckDB 2.0 Documentation / man.mtool.work