Results of 1 - 10 of about 21 for comma (0.004 sec.)
- Relational API 15611
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...unction_parameter : str, default: '' Optional parameters to pass into the function. * projected_columns : str, default: '' Comma-separated list of columns to include in the result. Example import duckdb duckdb_conn = duckdb.connect() rel = duckdb_conn...l columns or expressions; among several arguments, each string names one column. * groups : str, keyword-only, default: '' Comma-separated list of columns to include in the GROUP BY . Example import duckdb duckdb_conn = duckdb.connect() rel = duckdb_c...ession. Parameters expression : str The column or expression from which to retrieve any value. * groups : str, default: '' Comma-separated list of columns to include in the GROUP BY ; cannot be combined with window_spec . * window_spec : str, default:... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Unit Tester Configuration 9539
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...unittest --checkpoint-on-shutdown unittest --no-checkpoint-on-shutdown # other types unittest --checkpoint-wal-size 100000 Command line options --settings , --on-init and --init-script can be used to specify DuckDB configuration . Configuration File A...rate --select-tag <string> Select tests which match named tag (as singleton set; multiple sets are OR'd) --select-tag-set <comma-separated strings> Select tests which match all named tags (multiple sets are OR'd) --settings <list[struct]> Set DuckDB c...n , struct should have keys name and value --skip-compiled , --no-skip-compiled Skip compiled tests --skip-error-messages <comma-separated strings> Skip rather than fail tests that fail with a message that contains any of these substrings --skip-tag <... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- CREATE MACRO Statement 9184
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...call to another table function. Declaring Parameters Macros may declare parameters. The parameter declarations appear as a comma-separated list between the parentheses before the AS keyword. The simplified syntax for a single parameter declaration is:...parameters with default values appear "at the back". Multiple parameter declarations are separated from one another with a comma. Overloading Macros support overloading: A single CREATE MACRO statement can define multiple implementations (sometimes ca...alter individual implementations after the macro is created. Multiple implementations are separated from one another by a comma. Each implementation must have a unique parameter-type signature: that is, in one CREATE MACRO statement, all implementati... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- CLI Charting with YouPlot 8744
- DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi
...uding bar, line, histogram and scatter. With DuckDB, you can write to the console ( stdout ) by using the TO '/dev/stdout' command. And you can also write comma-separated values by using WITH (FORMAT csv, HEADER) . Installing YouPlot Installation inst...f /dev/stdout . The syntax looks like this: sql COPY (⟨query⟩) TO '/dev/stdout' WITH (FORMAT csv, HEADER); The full DuckDB command below outputs the query in CSV format with a header: batch duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchas...with dates and number of purchases made by somebody on that date. Using the query above, we'll pipe the data to the uplot command to draw a plot of the Top 10 Purchase Dates. duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchases FROM read_j... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Configuration 8642
- 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
...ference in their descriptions, both options operate on this same search path: search_path sets the entire search path as a comma-separated list of entries. schema is a convenience option that sets the search path to a single entry. Each entry in the s...tamptz_casts Disable casting from timestamp to timestamptz. BOOLEAN false disabled_compression_methods Disable a specific, comma-separated set of compression methods. VARCHAR disabled_filesystems Disable specific file systems, thereby preventing their...ileSystem. VARCHAR disabled_log_types Sets the list of disabled log types. VARCHAR disabled_optimizers Disable a specific, comma-separated set of optimizers. VARCHAR duckdb_api Specifies which client API/binding opened the database connection, e.g., c... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Output Formats 8558
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...Formats Mode Description ascii Columns/rows delimited by 0x1F and 0x1E box Tables using unicode box-drawing characters csv Comma-separated values column Output in columns (See .width ) duckbox Tables with extensive features (default) html HTML <table>...table tabs Tab-separated values tcl TCL list elements trash No output Changing the Output Format Use the vanilla .mode dot command to query the appearance currently in use. .mode current output mode: duckbox Use the .mode dot command with an argument...g_ducks | |----------------------| | quacking intensifies | The output appearance can also be adjusted with the .separator command. If using an export mode that relies on a separator ( csv or tabs for example), the separator will be reset when the mod... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- List Functions 8304
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...ist_sort . array_to_string(list, delimiter) Concatenates list/array elements using an optional delimiter . array_to_string_comma_default(array) Concatenates list/array elements with a comma delimiter. array_transform(list, lambda(x)) Alias for list_tr...3], '-') | | Result | 1-2-3 | | Example 2 | array_to_string(['aa', 'bb', 'cc'], '') | | Result | aabbcc | array_to_string_comma_default(array) | Description | Concatenates list/array elements with a comma delimiter. | | Example | array_to_string_comm... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- COPY Statement 8118
- 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
...... FROM imports data into DuckDB from an external file. COPY ... TO writes data from DuckDB to an external file. The COPY command can be used for CSV , PARQUET and JSON files. COPY ... FROM COPY ... FROM imports data from an external file into an exi...le that are not in the column list, COPY ... FROM will insert the default values for those columns. Copy the contents of a comma-separated file test.csv without a header into the table test : COPY test FROM 'test.csv'; Copy the contents of a comma-sep...sence of a header are automatically detected: COPY lineitem FROM 'lineitem.tbl' (AUTO_DETECT true); Read the contents of a comma-separated file names.csv into the name column of the category table. Any other columns of this table are filled with their... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Install Script 8033
- You can install the DuckDB CLI client using an install script. Linux and macOS To use the DuckDB install script on Linux and macOS, run: curl https://install.duckdb.org | bash Click to see the output of the install script. % Total % Receive
..., the install script can also install the DuckDB C/C++ headers and libraries using the DUCKDB_INSTALL variable. It takes a comma-separated list of components: cli (default), static and shared . For example, to install the static library and the CLI, r...more details, see Linking Extensions . Windows On Windows, we provide a beta install script. To use it, run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://instal... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/install_sc...
- Dot Commands 7949
- 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
...e separated, after the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands mu...gle line, and no whitespace may occur before the period. No semicolon is required at the end of the line. To see available commands, use the .help command. List of Dot Commands Command Description .about Prints version, description and license informa...to DIRECTORY .changes ⟨on/off⟩ Show number of rows changed by SQL .columns Column-wise rendering of query results .connect_command ⟨COMMAND⟩ Set the command executed by the -connect argument .databases List names and files of attached databases .decim... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work