Results of 1 - 10 of about 37 for separated (0.005 sec.)
- Relational API 16401
- 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
...n_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.sql(""" S...mns 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_conn.sql("".... 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: '' Window... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Unit Tester Configuration 9282
- 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
...-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 configurati...ruct 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 <string> Sk...ip tests which match named tag (as singleton set; multiple sets are OR'd) --skip-tag-set <comma-separated strings> Skip tests which match all named tags (multiple sets are OR'd) --sort-style <none|rowsort|valuesort> Default sort... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- CLI Charting with YouPlot 9282
- 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
...ng data from stdin . It takes tab-separated (or delimiter of your choice) data and can easily generate various types of plots including bar, line, histogram and scatt.... 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 instructions for YouPlot can be found on the m...ITH (FORMAT csv, HEADER)" \ | uplot bar -d, -H -t "Top 10 Purchase Dates" This tells uplot to draw a bar plot, use a comma-separated delimiter ( -d, ), that the data has a header ( -H ), and give the plot a title ( -t ). Additional Example: stdin + stdout... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Dot Commands 9076
- 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...de .timer ⟨on/off⟩ ⟨DIGITS⟩ Turn SQL timer on or off , with DIGITS decimals for the real time (default: 3). SQL statements separated by ; but not separated via newline are measured together .ui_command ⟨COMMAND⟩ Set the command executed by the -ui argumen...de MODE is one of: 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 html HTML <table> code insert SQL ins... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Output Formats 8966
- 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
...s 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> code inse...e list Values delimited by | markdown Markdown table format quote Escape answers as for SQL table ASCII-art 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 app...r example, .mode csv will set the separator to a comma ( , ). Using .separator "|" will then convert the output to be pipe-separated. .mode csv SELECT 1 AS col_1, 2 AS col_2 UNION ALL SELECT 10 AS col1, 20 AS col_2; col_1,col_2 1,2 10,20 .separator "|" SE... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- CREATE MACRO Statement 8855
- 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
...o 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: ⟨paramete...to be defined "in the front"; any 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...not possible to add, remove, or 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... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Configuration 8240
- 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
...e 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 search path..._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 access, e...tem. 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., cpp, capi,... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Azure Extension 8240
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...sts to the DuckDB HTTP log when it is enabled. See Logging . BOOLEAN true azure_http_logging_redact_query_params Semicolon-separated list of URL query parameter names (case-sensitive) whose values are redacted in the HTTP log. VARCHAR sig azure_http_loggi...ng_redact_headers Semicolon-separated list of header names (case-insensitive) whose values are redacted in the HTTP log, for both requests and responses. VARCHA...'⟨storage_account_name⟩' ); DuckDB also allows specifying a specific chain using the CHAIN keyword. This takes a semicolon-separated list ( a;b;c ) of providers that will be tried in order. For example: CREATE SECRET secret4 ( TYPE azure, PROVIDER credent... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- sqllogictest Introduction 8145
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...cted to return a single row with two columns (indicated by query II ). The values of the row are expected to be 42 and 84 (separated by a tab character). For more information on query result verification, see the result verification section . The top of e...several other systems have adopted them as well. Parsing sqllogictests is intentionally simple. All statements have to be separated by empty lines. For that reason, writing a syntax highlighter is not extremely difficult. A syntax highlighter exists for... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Result Verification 8035
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...alues separated by tabs. For example, query II SELECT 42, 84 UNION ALL SELECT 10, 20; ---- 42 84 10 20 For legacy reasons the letters R an...lue-Wise Result Ordering The result values of a query can be either supplied in row-wise order, with the individual values separated by tabs, or in value-wise order. In value wise order the individual values of the query must appear in row, column order e... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
DuckDB 2.0 Documentation / man.mtool.work