Results of 1 - 7 of about 7 for segment (0.004 sec.)
- Pragmas 12704
- 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
...on for the given table: Name Type Description row_group_id BIGINT column_name VARCHAR column_id BIGINT column_path VARCHAR segment_id BIGINT segment_type VARCHAR start BIGINT The start row id of this chunk count BIGINT The amount of entries in this stor...mpty unless persistent New As of DuckDB 2.0, when pragma_storage_info is called as a table function, it accepts an include_segment_info boolean parameter. When set to true , the result contains an additional segment_info VARCHAR column with per-segment...detail for some compression methods, such as the DICT_FSST mode applied (for example, DICTIONARY ): SELECT compression, segment_info FROM pragma_storage_info('table_name', include_segment_info := true); See Storage for more information. Show Database... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Geometry Data Type 10760
- 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
...here all values share the same geometry type and vertex dimensions. When a row group qualifies, DuckDB splits the geometry segment within the row group into primitive STRUCT , LIST , and DOUBLE segments that can be compressed independently using lightwe...shredding! │ geometry_db │ 6.5 MiB │ │ memory │ 0 bytes │ └───────────────┴───────────────┘ -- We can inspect what type of segments are used to store the geometry column -- in each database using the `pragma_storage_info` function. -- The geometry colum...n in `geometry_db` is stored as regular GEOMETRY segments SELECT DISTINCT(segment_type) FROM pragma_storage_info('geometry_db.points'); ---- ┌──────────────┐ │ segment_type │ │ va... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Text Functions 8797
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...R . md5_number(string) Returns the MD5 hash of the string as a HUGEINT . md5_number_lower(string) Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . md5_number_upper(string) Returns the upper 64-bit segment of the MD5 hash of...) | | Result | 152195979970564155685860391459828531600 | md5_number_lower(string) | Description | Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . | | Example | md5_number_lower('abc') | | Result | 8250560606382298838 | md5_...number_upper(string) | Description | Returns the upper 64-bit segment of the MD5 hash of the string as a UBIGINT . | | Example | md5_number_upper('abc') | | Result | 12704604231530709392 | nfc... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Execution Format 8142
- 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
...ke constant vectors, dictionary vectors are also emitted by the storage. When deserializing a dictionary compressed column segment, we store this in a dictionary vector so we can keep the data compressed during query execution. Sequence Vectors Sequence... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Utility Functions 8142
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
.... md5_number(string) Returns the MD5 hash of the string as a UHUGEINT . md5_number_lower(string) Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . md5_number_upper(string) Returns the upper 64-bit segment of the MD5 hash of... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Configuration 7924
- 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
...e database to cache external files like Parquet in memory. BOOLEAN true enable_fsst_vectors Allow scans on FSST compressed segments to emit compressed vectors to utilize late decompression. BOOLEAN false enable_geoparquet_conversion Attempt to decode/en...an_percentage * total_row_count) rows match, we perform an index scan instead of a table scan. DOUBLE 0.001 initial_column_segment_size The initial memory (in bytes) reserved for the first transient column segment. Must be a power of two. Internally, we...subtract the block header size (typically 8 bytes) for segments with or exceeding 1024 bytes. Subsequent segments double in size until reaching the block size. UBIGINT 2048 integer_divi... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Spatial Functions 7070
- 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
...ertices that have an "M" value within the start_measure and end_measure range For LINESTRING or MULTILINESTRING, if a line segment would cross either the upper or lower bound, a vertex is added by interpolating the coordinates at the "intersection" For... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work