Results of 1 - 8 of about 8 for throwing (0.002 sec.)
- Map Type 13248
- 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
...a MAP of VARCHAR to INT is valid). MAP s may not have duplicate keys. MAP s return NULL if a key is not found rather than throwing an error as structs do. In contrast, STRUCT s must have string keys, but each value may have a different type. See the dat... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- PostgreSQL Extension Functions 9344
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...s used, then some of the worker threads are unable to obtain a connection - they return without doing any work and without throwing an error thread_local_cache_enabled ( BOOLEAN ): whether caching the connections caching in thread-local cache is enabled;... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Loading JSON 9344
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...e file pattern or file list matches no files, return an empty result (with a single empty column of type BOOL ) instead of throwing an error. Added in DuckDB 2.0. BOOL false compression The compression type for the file. By default this will be detected... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Typecasting 9344
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...is supported, it is not possible for this particular value. TRY_CAST can be used to convert the value into NULL instead of throwing an error. Varchar The VARCHAR type acts as a universal target: any arbitrary value of any arbitrary type can always be cas... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- PostgreSQL Extension 8061
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...er than 38 as VARCHAR instead of DOUBLE false pg_numeric_nan_as_null Read PostgreSQL NUMERIC NaN values as NULL instead of throwing an error true pg_oauth_token OAuth bearer token for PostgreSQL OAUTHBEARER authentication. Takes priority over the PGOAUTH... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- CSV Import 8061
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...e file pattern or file list matches no files, return an empty result (with a single empty column of type BOOL ) instead of throwing an error. Not available in the COPY statement. Added in DuckDB 2.0. BOOL false allow_quoted_nulls Allow the conversion of... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Reading and Writing Parquet Files 8061
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...e file pattern or file list matches no files, return an empty result (with a single empty column of type BOOL ) instead of throwing an error. Added in DuckDB 2.0. BOOL false binary_as_string Parquet files generated by legacy writers do not correctly set... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Connect 6759
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...Instances and Instance Caching . jdbc_ignore_unsupported_options Silently ignore unsupported connection options instead of throwing an error. jdbc_jfr_memory_monitor Enable JFR memory monitoring for the connection's database instance. See Memory Monitori... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work