Results of 1 - 5 of about 5 for decode (0.004 sec.)
- Querying Parquet Metadata 12225
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...the Parquet key-value metadata. Because parquet_kv_metadata returns the key and value as BLOB s that contain JSON, use the decode function to turn them into strings and the JSON extraction operators to read individual fields: SELECT decode(value)->>'$....version' AS version, decode(value)->>'$.primary_column' AS primary_column, decode(value)->>'$.columns.geometry.encoding' AS encoding FROM parquet_kv_m...etadata('file.parquet') WHERE decode(key) = 'geo'; version primary_column encoding 1.0.0 geometry WKB When the file embeds a coordinate reference system, it is... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Blob Functions 10387
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...ist_concat(list1, list2, ...) . base64(blob) Alias for to_base64 . decode(blob[, on_error]) Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid UTF-8: 'strict'...1, 2, 3] || [4, 5, 6] | | Result | [1, 2, 3, 4, 5, 6] | | Example 3 | '\xAA'::BLOB || '\xBB'::BLOB | | Result | \xAA\xBB | decode(blob[, on_error]) | Description | Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid...t, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore' (removes invalid characters). | | Example | decode('\xC3\xBC'::BLOB) | | Result | ü | | Example | decode('\xAA'::BLOB, 'replace') | | Result | ? | encode(string) | Descripti... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Text Functions 7960
- 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
...ubstring using slice conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x -..._length(string) Alias for length . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings or lists. NULL inputs are skipped. See also operator || . concat_...alue) Converts a value from hexadecimal representation to a blob. unicode(string) Returns an INTEGER representing the unicode codepoint of the first character in the string . upper(string) Converts string to upper case. url_decode(string) Decodes a URL... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Python Client API 7850
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...R']), 'unhex': ('unhex', 0, ['VARCHAR']), 'unicode': ('unicode', 0, ['VARCHAR']), 'upper': ('upper', 0, ['VARCHAR']), 'url_decode': ('url_decode', 0, ['VARCHAR']), 'url_encode': ('url_encode', 0, ['VARCHAR'])} Method name to (function, position of the...expression, parameter types). ascii ( * args : ValueOrExpr ) → Expression The Unicode code point of the first character. SQL: ascii . bin ( * args : ValueOrExpr ) → StrExpr Converts the string to binary represent...rts a value from hexadecimal representation to a blob. SQL: unhex . unicode ( * args : ValueOrExpr ) → Expression The Unicode code point of the first character, as an INTEGER. SQL: unicode . upper ( * args : ValueOrExpr ) → StrExpr Converts string to u... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Configuration 7501
- 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
...d segments to emit compressed vectors to utilize late decompression. BOOLEAN false enable_geoparquet_conversion Attempt to decode/encode geometry data in/as GeoParquet files if the spatial extension is present. BOOLEAN true enable_global_s3_configurati... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work