Results of 1 - 10 of about 18 for reset (0.013 sec.)
- SET and RESET Statements 13692
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...O keyword: SET threads TO 1; Change configuration option to default value: RESET threads; Retrieve configuration value: SELECT current_setting('threads'); Set the default collation for the session: SET S...default threads globally: SET GLOBAL threads = 4; Syntax SET updates a DuckDB configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value. Scopes Configuration options can h...ave different scopes: GLOBAL : Configuration value is used (or reset) across the entire DuckDB instance. SESSION : Configuration value is used (or reset) only for the current session attached... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- ALTER TABLE Statement 10998
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...g data violates the constraint, the statement fails: Constraint Error: Data contains duplicates on indexed column(s) SET / RESET (Table Options) This feature was introduced in DuckDB 1.5. Modify table options after table creation. Set table options: A...LTER TABLE my_table SET ('option_name' = 'value'); Reset table options to their defaults: ALTER TABLE my_table RESET ('option_name'); The SET clause assigns values to table option...s as key-value pairs. The RESET clause removes options or restores them to their default values, depending on the catalog implementation. Multiple options... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- SET VARIABLE and RESET VARIABLE Statements 10878
- DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIABLE statements. Variable Scopes DuckDB supports two levels of variable scopes: Scope Description SESSION Variables with a SESSION scope are local to
...rom the session variable of the same name. This also lets variables act as default values for prepared statements . Syntax RESET VARIABLE The RESET VARIABLE statement unsets a variable. SET VARIABLE my_var = 30; RESET VARIABLE my_var; SELECT getvariab... - https://man.mtool.work/duckdb/2.0/sql/statements/set_variable.html
- Data Chunks 10500
- Data chunks represent a horizontal slice of a table. They hold a number of vectors , that can each hold up to the VECTOR_SIZE rows. The vector size can be obtained through the duckdb_vector_size function and is configurable, but is usually
..._type * types , idx_t column_count ); void duckdb_destroy_data_chunk ( duckdb_data_chunk * chunk ); void duckdb_data_chunk_reset ( duckdb_data_chunk chunk ); idx_t duckdb_data_chunk_get_column_count ( duckdb_data_chunk chunk ); duckdb_vector duckdb_da...d duckdb_destroy_data_chunk ( duckdb_data_chunk * chunk ); Parameters chunk : The data chunk to destroy. duckdb_data_chunk_reset Resets a data chunk, clearing the validity masks and setting the cardinality of the data chunk to 0. After calling this me..._vector_get_validity and duckdb_vector_get_data to obtain current data and validity pointers Syntax void duckdb_data_chunk_reset ( duckdb_data_chunk chunk ); Parameters chunk : The data chunk to reset. duckdb_data_chunk_get_column_count Retrieves the... - https://man.mtool.work/duckdb/2.0/clients/c/data_chunk.html
- Profiling 8424
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...in the profiling output. The following pragmas are available and can be set using either PRAGMA or SET . They can also be reset using RESET , followed by the setting name. For more information, see the “Profiling” section of the pragmas page. Setting... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Dot Commands 8184
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...: .progress_bar --add "{align:right}{min_size:20}{color:red}Time: {sql:select (current_time::varchar).split('.')[1]}{color:reset} " .progress_bar --add commands are additive, issuing multiple --add calls will stack additional components on the progres...rnal Cache Usage: {sql:select format_bytes(memory_usage_bytes) from duckdb_memory() where tag='EXTERNAL_FILE_CACHE'}{color:reset}" To reset all existing progress bar components: .progress_bar --clear Syntax Highlighters The DuckDB CLI client has a syn... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Configuration 8184
- 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
...ng the RESET statement . The values of configuration options can be queried via the current_setting() scalar function or using the duck...of total threads used by the system. BIGINT GLOBAL Show a list of all available settings: SELECT * FROM duckdb_settings(); Reset the memory limit of the system back to the default: RESET memory_limit; Secrets Manager DuckDB has a Secrets manager , whi... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Friendly CLI 8064
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
..._element:prompt_connect}{setting:connect_name_prefix}{highlight_element:prompt}{setting:current_database_and_schema}{color:reset} D While the session is connected to a remote database with CONNECT , {setting:connect_name_prefix} shows the remote datab... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Reference 7944
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...o settings below are global-scoped ( SET GLOBAL ). A plain SET on these is forwarded to the global slot automatically. Use RESET GLOBAL to restore the default, a plain RESET only clears the session view and the auth path will keep reading the stale gl... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- DBeaver SQL IDE 7824
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...es” tab, then click on the DuckDB driver and click “Download/Update”. If you do not see the DuckDB driver, first click on “Reset to Defaults”. Click “Download” to download DuckDB's JDBC driver from Maven. Once download is complete, click “OK”, then re... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
DuckDB 2.0 Documentation / man.mtool.work