Results of 1 - 10 of about 48 for Blob (0.006 sec.)
- Blob Functions 14525
- 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 handli...ce' (replaces invalid characters with ? ), or 'ignore' (removes invalid characters). encode(string) Converts the string to BLOB . Converts UTF-8 characters into literal encoding. from_base64(string) Converts a base64 encoded string to a character str...ing ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . hex(blob) Converts blob to VARCHAR using hexadec... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Blob Type 12026
- 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 with three bytes (170, 171, 172): SELECT '\xAA\xA...B\xAC'::BLOB; Create a BLOB value with two bytes (65, 66): SELECT 'AB'::BLOB; A BLOB value can also be created using a hex string liter...al, which is a string 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 v... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Directly Reading Files 10345
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...ent as valid UTF-8. If read_text attempts to read a file with invalid UTF-8, DuckDB throws an error suggesting to use read_blob instead. read_text also supports reading from pipes (e.g., /dev/stdin ). The maximum allowed file size for read_text is 3....9 GiB. read_blob The read_blob table function reads from the selected source(s) to a BLOB : SELECT size, content, filename FROM read_blob('...; size content filename 178 PK\x03\x04\x0A\x00\x00\x00\x00\x00\xACi=X\x14t\xCE\xC7\x0A… test/sql/table_function/files/four.blob 12 Hello World! test/sql/table_function/files/one.txt 2 42 test/sql/table_function/files/three.txt 10 F\xC3\xB6\xC3\xB6 B\... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- COPY Statement 9936
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
....csv' WITH DELIMITER '|' CSV HEADER; COPY ... TO COPY ... TO exports data from DuckDB to an external CSV, Parquet, JSON or BLOB file. It has mostly the same set of options as COPY ... FROM , however, in the case of COPY ... TO the options specify how.... BIGINT 122880 KV_METADATA Custom key-value metadata to embed in the file footer, supplied as a STRUCT of keys to values. BLOB values are written as raw bytes; other values are cast to string. STRUCT (empty) SHREDDING A STRUCT mapping VARIANT column...AT json, ARRAY false); -- RETURNS: /* {"id":1,"name":"Alice","numbers":[1,2,3]} {"id":2,"name":"Bob","numbers":[4,5,6]} */ BLOB Options The BLOB format option allows you to select a single column of a DuckDB table into a .blob file. The column must b... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Azure Extension 9769
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...ret with the storage account name is enough (see the CONFIG provider ). Then you can query Azure storage as follows: Azure Blob Storage Allowed URI schemes: az or azure SELECT count(*) FROM 'az://⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; Glo...OM 'az://⟨my_container⟩/⟨path⟩/**'; Or with a fully qualified path syntax: SELECT count(*) FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; SELECT * FROM 'az://⟨my_storage_account⟩.blob.core.win...OM 'abfss://⟨my_filesystem⟩@⟨my_storage_account⟩.dfs.core.windows.net/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; Writing to Azure Blob Storage You can write data directly to Azure Blob or ADLSv2 Storage using the COPY statement . -- Write query results to a... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Spatial Functions 9163
- 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
...fragment or path ST_AsText Returns the geometry as a WKT string ST_AsWKB Returns the geometry as a WKB (Well-Known-Binary) blob ST_Azimuth Returns the azimuth (a clockwise angle measured from north) of two points in radian. ST_Boundary Returns the "b...ST_GeomFromText Deserialize a GEOMETRY from a WKT encoded string ST_GeomFromWKB Deserializes a GEOMETRY from a WKB encoded blob ST_GeometryType Returns a GEOMETRY_TYPE enum identifying the input geometry type. Possible enum return types are: POINT ,...geometry, optionally taking direction into account. ST_LineString2DFromWKB Deserialize a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substring of a line between two fractions of total 2D length. ST_LocateAlong Returns a point or... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Text Functions 8542
- 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
...(see Pattern Matching ). string ^@ search_string Alias for starts_with . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2, ...) . array_extract(str...band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Alias for to_base64 . bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a st...s based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . greatest(arg1, ...) Returns the largest value in... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Values 8300
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...s ( duckdb_timestamp_ns input ); duckdb_value duckdb_create_interval ( duckdb_interval input ); duckdb_value duckdb_create_blob ( const uint8_t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_u..._interval duckdb_get_interval ( duckdb_value val ); duckdb_logical_type duckdb_get_value_type ( duckdb_value val ); duckdb_blob duckdb_get_blob ( duckdb_value val ); duckdb_bit duckdb_get_bit ( duckdb_value val ); duckdb_uhugeint duckdb_get_uuid ( du...meters input : The interval value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_blob Creates a value from a blob Syntax duckdb_value duckdb_create_blob ( const uint8_t * data , idx_t length ); Parameters dat... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Querying Parquet Metadata 8254
- 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
...e_offset BIGINT data_page_offset BIGINT total_compressed_size BIGINT total_uncompressed_size BIGINT key_value_metadata MAP(BLOB, BLOB) bloom_filter_offset BIGINT bloom_filter_length BIGINT min_is_exact BOOLEAN max_is_exact BOOLEAN row_group_compresse...tadata('test.parquet'); Below is a table of the columns returned by parquet_kv_metadata . Field Type file_name VARCHAR key BLOB value BLOB GeoParquet Metadata GeoParquet files store their geospatial metadata (the primary geometry column, its encoding...m, and more) under the geo key of 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 individua... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Complete API 8133
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...t col , idx_t row ); duckdb_string duckdb_value_string_internal ( duckdb_result * result , idx_t col , idx_t row ); duckdb_blob duckdb_value_blob ( duckdb_result * result , idx_t col , idx_t row ); bool duckdb_value_is_null ( duckdb_result * result ,...ckdb_prepared_statement prepared_statement , idx_t param_idx , const char * val , idx_t length ); duckdb_state duckdb_bind_blob ( duckdb_prepared_statement prepared_statement , idx_t param_idx , const void * data , idx_t length ); duckdb_state duckdb...s ( duckdb_timestamp_ns input ); duckdb_value duckdb_create_interval ( duckdb_interval input ); duckdb_value duckdb_create_blob ( const uint8_t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_u... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
DuckDB 2.0 Documentation / man.mtool.work