Results of 1 - 9 of about 9 for Retrieving (0.001 sec.)
- Array Type 11881
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...n: CREATE TABLE array_table (id INTEGER, arr INTEGER[3]); INSERT INTO array_table VALUES (10, [1, 2, 3]), (20, [4, 5, 6]); Retrieving Values from Arrays Retrieving one or more values from an array can be accomplished using brackets and slicing notation, or... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- List Type 11504
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...th an INTEGER list column and a VARCHAR list column: CREATE TABLE list_table (int_list INTEGER[], varchar_list VARCHAR[]); Retrieving from Lists Retrieving one or more values from a list can be accomplished using brackets and slicing notation, or through l... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Struct Data Type 10731
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...'b': 2}, b := 3, c := 4) AS s; Alternatively, struct_insert also allows adding new fields but not updating existing ones. Retrieving from Structs Retrieving a value from a struct can be accomplished using dot notation, bracket notation, or through struct...quivalent. This returns 1: SELECT struct_extract({'x space': 1, 'y': 2, 'z': 3}, 'x space'); unnest / STRUCT.* Rather than retrieving a single key from a struct, the unnest special function can be used to retrieve all keys from a struct as separate columns... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
- JSON Overview 8807
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...E example (j JSON); INSERT INTO example VALUES ('{ "family": "anatidae", "species": [ "duck", "goose", "swan", null ] }'); Retrieving JSON Data Retrieve the family key's value: SELECT j.family FROM example; "anatidae" Extract the family key's value with a... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- Map Type 8430
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...]}; Create a table with a map column that has INTEGER keys and DOUBLE values: CREATE TABLE tbl (col MAP(INTEGER, DOUBLE)); Retrieving from Maps MAP values can be retrieved using the map_extract_value function or bracket notation: SELECT MAP {'key1': 5, 'ke... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Profile and Monitor 7657
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- PHP Client 7657
- The DuckDB PHP client is a tertiary client and is maintained by a third-party. Client API for PHP, focused on performance. The DuckDB PHP client uses the official C API internally through FFI , achieving good benchmark results. This library
...------- The function we used here, DuckDB::sql() , performs the query in a new in-memory database which is destroyed after retrieving the result. This is not the most common use case, let's see how to get a persistent connection. Connection $duckDB = DuckD... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php.html
- Reading Faulty CSV Files 7261
- 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
...SELECT name FROM read_csv('faulty.csv', columns = {'name': 'VARCHAR', 'age': 'INTEGER'}); Outputs: name Pedro Oogie Boogie Retrieving Faulty CSV Lines Being able to read faulty CSV files is important, but for many data cleaning operations, it is also neces... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- ODBC Extension Functions 6884
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...( BOOLEAN , default: false ): read long VARCHAR or VARBINARY values as a single read (used when a driver does not support Retrieving Variable-Length Data in Parts ) var_len_params_long_threshold_bytes ( UINTEGER , default: 4000 ): a length threshold after... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work