Results of 1 - 10 of about 19 for selected (0.001 sec.)
- Union Functions 14326
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...ntaining the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected tag of the union as an Enum . union.tag | Description | Dot notation serves as an alias for union_extract . | | Example |...tract(union, 'tag') | Description | Extract the value with the named tags from the union. NULL if the tag is not currently selected. | | Example | union_extract(s, 'k') | | Result | hello | union_value(tag := any) | Description | Create a single member U...lue(k := 'hello') | | Result | hello (of type UNION(k VARCHAR) ) | union_tag(union) | Description | Retrieve the currently selected tag of the union as an Enum . | | Example | union_tag(union_value(k := 'foo')) | | Result | 'k' |... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Syntax Highlighting 11850
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...tring constants string_constant yellow Comments comment gray Errors error red Continuation continuation gray Continuation (Selected) continuation_selected green Colors are specified by name. The following basic colors are supported by all terminals: blac...ight_colors comment cyan .highlight_colors error yellow .highlight_colors continuation blue .highlight_colors continuation_selected brightblue If you wish to start up the CLI with a different set of colors every time, you can place these commands in the... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- Directly Reading Files 9237
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...metadata such as the file size and last modified time. read_text The read_text table function reads from the selected source(s) to a VARCHAR . Each file results in a single row with the content field holding the entire content of the respec...dev/stdin ). The maximum allowed file size for read_text is 3.9 GiB. read_blob The read_blob table function reads from the selected source(s) to a BLOB : SELECT size, content, filename FROM read_blob('test/sql/table_function/files/*'); size content filen... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- USE Statement 8930
- The USE statement selects a database and optional schema, or just a schema to use as the default. Examples --- Sets the 'memory' database as the default. Will use 'main' schema implicitly or error --- if it does not exist. USE memory; --- S
...ets the 'duck.main' database and schema as the default USE duck.main; -- Sets the `main` schema of the currently selected database as the default, in this case 'duck.main' USE main; Syntax The USE statement sets a default database, schema or da... - https://man.mtool.work/duckdb/2.0/sql/statements/use.html
- List Tables 8623
- The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. CREATE TABLE tbl (i INTEGER); SHOW TABLES; name tbl SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databa
... - https://man.mtool.work/duckdb/2.0/guides/meta/list_tables.html
- FILTER Clause 8623
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
...cause y is true for that row, while the second explicitly excludes null values from x : SELECT list(x) FILTER (WHERE y) AS selected_rows, list(x) FILTER (WHERE x IS NOT NULL) AS non_null_values FROM (VALUES (NULL::INTEGER, true), (2, true), (1, false)) t...(x, y); The results are [NULL, 2] for selected_rows and [2, 1] for non_null_values . Return the following: The total number of rows The number of rows where i <= 5 The n... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
- Friendly CLI 8315
- 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
...mode light To use a mix of colors suitable for both dark and light backgrounds: .highlight_mode mixed The mode can also be selected when launching the CLI using the -dark-mode and -light-mode command line arguments : duckdb -dark-mode duckdb -light-mode... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Aggregate Functions 8315
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...t row. Unlike arg_max , NULL values of arg are not ignored and rows where val is NULL are sorted last, i.e., they are only selected if there are no other rows. If n is specified, returns a LIST containing the arg expressions for the top n rows ordered by...t row. Unlike arg_min , NULL values of arg are not ignored and rows where val is NULL are sorted last, i.e., they are only selected if there are no other rows. If n is specified, returns a LIST containing the arg expressions for the top n rows ordered by...t row. Unlike arg_max , NULL values of arg are not ignored and rows where val is NULL are sorted last, i.e., they are only selected if there are no other rows. If n is specified, returns a LIST containing the arg expressions for the top n rows ordered by... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Integration with PyTorch 8162
- PyTorch tensors can be built from DuckDB query results by exporting each result batch as Apache Arrow . This pattern is useful when training or serving models on Parquet data because DuckDB can filter and project the input before the batche
...ch.int64) print(features.shape, labels) torch.Size([2, 2]) tensor([1, 1]) DuckDB pushes the WHERE label = 1 filter and the selected columns into the dataset scan, so only the requested rows and columns are converted to tensors. The to_arrow_reader method... - https://man.mtool.work/duckdb/2.0/guides/python/pytorch.html
- UPDATE EXTENSIONS 8162
- The UPDATE EXTENSIONS statement allows synchronizing the locally installed extension state with the repository that published a given extension. This statement is the recommended way to keep up to date with new features or bug fixes being r
...e DuckDB binary, such as json , parquet and icu in the official DuckDB builds, are not updated by this statement. Updating Selected Extensions For more fine-grained control, you can also provide a list of extension names to be updated: UPDATE EXTENSIONS... - https://man.mtool.work/duckdb/2.0/sql/statements/update_extensions.html
DuckDB 2.0 Documentation / man.mtool.work