Results of 1 - 10 of about 15 for represent (0.002 sec.)
- Data Chunks 11720
- Data chunks represent a horizontal slice of a table. They hold a number of vectors , that can each hold up to the VECTOR_SIZE rows. The vector size can be obtained through the duckdb_vector_size function and is configurable, but is usually
...set to 2048 . Data chunks and vectors are what DuckDB uses natively to store and represent data. For this reason, the data chunk interface is the most efficient way of interfacing with DuckDB. Be aware, however, t... - https://man.mtool.work/duckdb/2.0/clients/c/data_chunk.html
- Execution Format 11303
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...to in the code as STANDARD_VECTOR_SIZE . The default STANDARD_VECTOR_SIZE is 2048 tuples. Vector Format Vectors logically represent arrays that contain data of a single type. DuckDB supports different vector formats , which allow the system to store the...same logical data with a different physical representation . This allows for a more compressed representation, and potentially allows for compressed execution throughout the sy...y stored as a contiguous array, this is the standard uncompressed vector format. For flat vectors the logical and physical representations are identical. Constant Vectors Constant vectors are physically stored as a single constant value. Constant vectors... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Blob Type 10449
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...ata with no restrictions. What the actual bytes represent is opaque to the database system. Create a BLOB value with a single byte (170): SELECT '\xAA'::BLOB; Create a BLOB value w... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Time Types 10449
- The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME WITH TIME ZONE Time of day, with time zone offset TIME_NS Time of day, nanosecond
...n rare cases, where the date part of the timestamp can be disregarded. Most applications should use the TIMESTAMP types to represent their timestamps.... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- Reading Faulty CSV Files 9596
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...ject Scans Table returns the following information: Column name Description Type scan_id The internal ID used in DuckDB to represent that scanner UBIGINT file_id A scanner might happen over multiple files, so the file_id represents a unique file in a scan...ect Errors Table returns the following information: Column name Description Type scan_id The internal ID used in DuckDB to represent that scanner, used to join with reject scans tables UBIGINT file_id The file_id represents a unique file in a scanner, use... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- NULL Values 9596
- NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as “the value of this field is unknown”. A NULL value can be inserted to any fie
... - https://man.mtool.work/duckdb/2.0/sql/data_types/nulls.html
- Timestamp Types 9596
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...offsets or time zones. Accordingly, TIMESTAMP s could be interpreted as UTC timestamps, but more commonly they are used to represent local observations of time recorded in an unspecified time zone, and operations on these types can be interpreted as simpl... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Geometry Data Type 8324
- 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
...he Simple Features standard, which is widely used in geospatial databases and GIS software. A GEOMETRY value can therefore represent 7 types of shapes: Geometry Type Description Point A single location in space, defined by its coordinates (e.g., longitude...and latitude). LineString A sequence of points connected by straight lines, representing a path or route. Polygon A set of closed rings defined by a sequence of points, representing an area such as a country...border or a building footprint. The first ring is the "shell", and "interior" rings represent holes in the polygon. MultiPoint A collection of points. MultiLineString A collection of LineStrings. MultiPolygon A colle... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Interval Type 7906
- 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.
... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Variant Functions 7906
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...ry sort key that orders a VARIANT value by the logical ordering of VARIANT values. variant_normalize(v) Return a canonical representation of a VARIANT value, so that values representing the same data share the same form. variant_group_object(key, value) A...hat VARIANT s compare and sort consistently with the corresponding native DuckDB types, rather than by their internal byte representation. | | Example | variant_comparator({'a': 1, 'b': 2}::VARIANT) | | Result | A BLOB sort key | Values are ordered first...: SELECT i FROM range(-2, 2) t(i) ORDER BY i::VARIANT; i -2 -1 0 1 variant_normalize(v) | Description | Return a canonical representation of a VARIANT value. Two VARIANT values that represent the same data normalize to the same result, regardless of how t... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
DuckDB 2.0 Documentation / man.mtool.work