Results of 1 - 10 of about 37 for what (0.005 sec.)
- Versioning of Extensions – DuckDB 13386
- 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
.... For example, at the time of writing this, the version of the vss extension is an unstable extension of version 690bfc5 . What to expect from an extension that has a version number in the unstable format? The state of the source code of the extensio...or example, at the time of writing this, the version of the delta extension is a pre-release extension of version v0.1.0 . What to expect from an extension that has a version number in the pre-release format? The extension is compiled from the source...e tested in nightly builds before being grouped into a release and pushed to the core repository. Release notes describing what has been added each release should be available to make it easy to understand the difference between versions. Stable Exte... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- Spatial Extension – DuckDB 11728
- 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
...the GEOMETRY type. If you're unfamiliar with geospatial data and GIS tooling, this type probably works very different from what you'd expect. On the surface, the GEOMETRY type is a binary representation of “geometry” data made up out of sets of verti...ces (pairs of X and Y double precision floats). But what makes it somewhat special is that its actually used to store one of several different geometry subtypes. These are POINT ,...Pages in This Section 関連キーワード spatial type extension types geometry these geospatial different used Spatial DuckDB what actually store subtypes These well based standard couple functions Documentation Core Extensions Copy 関連するページ GDAL... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/overview.html
- Numeric Types – DuckDB 11728
- 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
...same storage size, UTINYINT is 1 byte, SMALLINT is 2 bytes, etc. But sometimes you need numbers that are even bigger than what is supported by a HUGEINT ! For these situations the VARINT type can come in handy, as the VARINT type has a much bigger l...ating-point types stores inputs that cannot be represented exactly as approximations. However, it can be harder to predict what inputs are affected by this. For example, it is not surprising that 1.3::DECIMAL(1, 0) - 0.7::DECIMAL(1, 0) != 0.6::DECIMA...ation carefully for corner cases (ranges, infinities, underflows, invalid operations) that may be handled differently from what you expect and you should familiarize yourself with common floating-point pitfalls. The article “What Every Computer Scien... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Querying Parquet Metadata – DuckDB 9408
- 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
...internal details of the Parquet file such as the statistics of the different columns. This can be useful for figuring out what kind of skipping is possible in Parquet files, or even to obtain a quick overview of what the different columns contain: S... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Guides – DuckDB 9408
- 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
...read a text file Performance My workload is slow (troubleshooting guide) How to design the schema for optimal performance What is the ideal hardware environment for DuckDB What performance implications do Parquet files and (compressed) CSV files hav... - https://man.mtool.work/duckdb/1.3/guides/overview.html
- Overview of DuckDB Internals – DuckDB 9408
- 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
...can be e.g., a reference to a column, an addition operator or a constant value. The type of the ParsedExpression indicates what it represents, e.g., a comparison is represented as a ComparisonExpression . ParsedExpressions do not have types, except f...DIFFERENCE ). SQL Statement The SQLStatement represents a complete SQL statement. The type of the SQL Statement represents what kind of statement it is (e.g., StatementType::SELECT represents a SELECT statement). A single SQL string can be transforme... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- SQL Introduction – DuckDB 9076
- 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
...n type the command aligned differently than above, or even all on one line. Two dash characters ( -- ) introduce comments. Whatever follows them is ignored up to the end of the line. SQL is case-insensitive about keywords and identifiers. When return...ow it here to help you understand the following topics. Now we will figure out how we can get the Hayward records back in. What we want the query to do is to scan the weather table and for each row to find the matching cities row(s). If no matching r...highest low-temperature reading anywhere with: SELECT max ( temp_lo ) FROM weather ; max(temp_lo) 46 If we wanted to know what city (or cities) that reading occurred in, we might try: SELECT city FROM weather WHERE temp_lo = max ( temp_lo ); But thi... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- AsOf Join – DuckDB 8745
- 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
...Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Guides / SQL Features Copy Markdown AsOf Join What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay bet...Report content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article What is an AsOf Join? Portfolio Example Data Set Inner AsOf Joins Outer AsOf Joins AsOf Joins with the USING Keyword Clarificat... - https://man.mtool.work/duckdb/1.3/guides/sql_features/asof_join.html
- Samples – DuckDB 8745
- 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
...g a dataset faster, as often you might not be interested in the exact answers to queries, but only in rough indications of what the data looks like and what is in the data. Samples allow you to get approximate answers to queries faster, as they reduc... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Spatial Functions – DuckDB 8098
- 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 account, but is also the slowest. Example -- Note: the coordinates are in WGS84 and [latitude, longitude] axis order -- Whats the distance between New York and Amsterdam (JFK and AMS airport)? SELECT st_distance_spheroid ( st_point ( 40.6446 , -73...orce the input and output geometries to be interpreted as having a [easting, northing] coordinate axis order regardless of what the source and target coordinate system definition says. This is particularly useful when transforming to/from the WGS84/E...PSG:4326 coordinate system (what most people think of when they hear "longitude"/"latitude" or "GPS coordinates"), which is defined as having a [latitude,... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
DuckDB 1.3 Documentation / man.mtool.work