Results of 1 - 10 of about 29 for necessary (0.001 sec.)
- Interval Type 13248
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...LECT INTERVAL 1 YEAR, -- single unit using YEAR keyword; stored as 12 months INTERVAL (random() * 10) YEAR, -- parentheses necessary for variable amounts; -- stored as integer number of months INTERVAL '1 month 1 day', -- string type necessary for multipl...e string or use a more granular unit; e.g., INTERVAL '1.5 years' or INTERVAL 18 MONTHS . Three independent basis units are necessary because a month does not correspond to a fixed amount of days (February has fewer days than March) and a day doesn't corre... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Time Functions 12807
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...lue without a time zone. | | Example | current_localtime() | | Result | 06:09:59.988 | | Alias | localtime (no parentheses necessary) | date_diff(part, starttime, endtime) | Description | The number of part boundaries between starttime and endtime , inclu...ime zone as TIMETZ . | | Example | get_current_time() | | Result | 06:09:59.988+2 | | Alias | current_time (no parentheses necessary) | make_time(bigint, bigint, double) | Description | The time for the given parts. | | Example | make_time(13, 34, 27.1234... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Multiple Connections 9675
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- Out-of-Memory Issues 9675
- Configuration Options If you are experiencing out-of-memory issues with DuckDB, try tweaking the following configuration options: Reduce the number of threads using the SET threads = ... command. Setting the memory limit lower than the defa
...hey will take up more memory during processing – hence, using the most restrictive types possible when creating columns is necessary to reduce memory consumption. Indexes can significantly increase memory consumption. Additionally, they are currently not... - https://man.mtool.work/duckdb/2.0/guides/performance/oom.html
- Catch C/C++ Tests 9234
- While we prefer the sqllogic tests for testing most functionality, for certain tests only SQL is not sufficient. This typically happens when you want to test the C++ API. When using pure SQL is really not an option it might be necessary to
... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/catch.html
- EXPORT and IMPORT DATABASE Statements 9234
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...re found in the database. It contains any CREATE SCHEMA , CREATE TABLE , CREATE VIEW and CREATE SEQUENCE commands that are necessary to re-construct the database. Warning In DuckDB 2.0.0, triggers are not included in the export, and COPY FROM DATABASE doe... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Hive Partitioning 8777
- Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, mont
...s on the partition keys are automatically pushed down into the files. This way the system skips reading files that are not necessary to answer a query. For example, consider the following query on the above dataset: SELECT * FROM read_parquet('orders/*/*/... - https://man.mtool.work/duckdb/2.0/data/partitioning/hive_partitioning.html
- ODBC Extension Functions 8337
- 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) ->
..., params_handle BIGINT, params STRUCT) -> BIGINT Binds specified parameter values to the specified parameters handle. Only necessary with 2-step parameters binding, see Query parameters for details. Parameters: conn_handle ( BIGINT ): ODBC connection hand...ze=32, max_records_in_transaction=42); odbc_create_params odbc_create_params() -> BIGINT Creates a parameters handle. Only necessary with 2-step parameters binding, see Query parameters for details. Parameters: None. Returns: Parameters handle ( BIGINT ).... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Set Operations 8337
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...number of columns. Implicit casting to one of the returned types is performed to combine columns of different types where necessary. If this is not possible, the UNION clause throws an error. Vanilla UNION (Set Semantics) The vanilla UNION clause follows... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Troubleshoot 7880
- 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
...r: bash CC=⟨c_cross_compiler⟩ CGO_ENABLED=1 go build Windows Setup On Windows you need a compatible version of gcc and the necessary runtime libraries. One way is MSYS2 : install it, then open an MSYS2 shell and install the UCRT64 toolchain: pacman -S min... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work