Results of 1 - 10 of about 23 for byte (0.002 sec.)
- Data Types 15617
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...andard and hence might not be accepted by other database engines. Name Aliases Description BIGINT INT8 , LONG Signed eight-byte integer BIT BITSTRING String of 1s and 0s BLOB BYTEA , BINARY , VARBINARY Variable-length binary data BIGNUM Variable-leng...n width (precision) and scale, defaults to prec = 18 and scale = 3 DOUBLE FLOAT8 Double precision floating-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, see the GEOMETRY data t...ype HUGEINT Signed sixteen-byte integer INTEGER INT4 , INT , SIGNED Signed four-byte integer INTERVAL Date / time delta JSON JSON object (via the json ext... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Reading Faulty CSV Files 10523
- 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
...MAXIMUM : DuckDB has a parameter that sets the maximum line size a CSV file can have, which by default is set to 2,000,000 bytes. Assuming our scanner is set to max_line_size = 25 , the line Pedro Holanda, 01-01-1992 would produce an error, as it exc...eeds 25 bytes. INVALID ENCODING : DuckDB supports UTF-8 strings, UTF-16 and Latin-1 encodings. Lines containing other characters will p...used to join with reject scans tables UBIGINT line Line number, from the CSV File, where the error occurred. UBIGINT line_byte_position Byte Position of the start of the line, where the error occurred. UBIGINT byte_position Byte Position where the e... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- Troubleshoot 8613
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...Run Queries for the full example. Scanning JSON Values Starting with v2, scanning a JSON value directly into a string or []byte is no longer supported. Scan into any or into the duckdb.Composite wrapper instead, as shown in Run Queries . If a plain s...tring or byte result is needed and the JSON structure is not, cast the column to ::VARCHAR or ::BLOB in SQL before scanning. Further Rea... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Utility Functions 8613
- 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
.... nullif(a, b) Return NULL if a = b , else return a . Equivalent to CASE WHEN a = b THEN NULL ELSE a END . parse_formatted_bytes(string) Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on inva...'abc') | | Result | 152195979970564155685860391459828531600 | md5_number_lower(string) | Description | Returns the lower 8 bytes of the MD5 hash of string as a UBIGINT . | | Example | md5_number_lower('abc') | | Result | 8250560606382298838 | md5_num...ber_upper(string) | Description | Returns the upper 8 bytes of the MD5 hash of string as a UBIGINT . | | Example | md5_number_upper('abc') | | Result | 12704604231530709392 | nextva... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Backup Extension Repositories 8495
- The core and community extension repositories have backup servers (see duckdb-backup.org ): Repository Primary server Backup server core http://extensions.duckdb.org http://extensions.duckdb-backup.org community http://community-extensions.
...duckdb.org http://community-extensions.duckdb-backup.org The backup servers serve byte-identical binaries, so signature checks are unaffected. Automatic Fallback Fallback is automatic: if the primary server is... - https://man.mtool.work/duckdb/2.0/operations_manual/backup_extension_repositorie...
- Bitstring Type 8495
- Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A bitstring value requires 1 byte for each group of 8 bits, plus a fixed amount to sto
... - https://man.mtool.work/duckdb/2.0/sql/data_types/bitstring.html
- Blob Type 8378
- 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 B...LOB value with three bytes (170, 171, 172): SELECT '\xAA\xAB\xAC'::BLOB; Create a BLOB value with two bytes (65, 66): SELECT 'AB'::BLOB; A BLOB valu...g of hexadecimal digits prefixed with X . The number of hex digits must be even. For example, create a BLOB value with two bytes (202, 254): SELECT X'CAFE'; New Starting with DuckDB 2.0, X'…' literals are BLOB values. In earlier versions, X'CAFE' was... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- JSON Type 8277
- DuckDB supports json via the JSON logical type. For example: SELECT '[1, null, {"key": "value"}]'::JSON; [1, null, {"key": "value"}] Logically, the JSON type is similar to a VARCHAR , but with the restriction that it must be valid JSON. Phy
...red as a VARCHAR . For example, you can't parse invalid JSON: SELECT 'unquoted'::JSON; Conversion Error: Malformed JSON at byte 0 of input: unexpected character. Input: "unquoted" Instead, what you probably want here is SELECT '"quoted"'::JSON . Sinc... - https://man.mtool.work/duckdb/2.0/data/json/json_type.html
- Timestamp with Time Zone Functions 8277
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...imestamptz, timestamptz) The earlier of two timestamps. now() Current date and time (start of current transaction). timetz_byte_comparable(timetz) Converts a TIME WITH TIME ZONE to a UBIGINT sort key. to_timestamp(double) Converts seconds since the e...Current date and time (start of current transaction). | | Example | now() | | Result | 2022-10-08 12:44:46.122-07 | timetz_byte_comparable(timetz) | Description | Converts a TIME WITH TIME ZONE to a UBIGINT sort key. | | Example | timetz_byte_compara... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- DuckDB Wasm Client 7825
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...TTP(S) servers and in-memory buffers uniformly. Because DuckDB understands file formats such as Parquet, it reads only the bytes a query needs rather than downloading an entire file: SELECT count(*) FROM 'file.parquet' can be answered from the file m...d behavior depends on which httpfs path serves the request. The JavaScript httpfs implementation fetches only the required byte ranges, but reading through the built-in httpfs extension may currently download the whole file instead (see duckdb-wasm i... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
DuckDB 2.0 Documentation / man.mtool.work