Results of 1 - 4 of about 4 for chaining (0.001 sec.)
- Functions 12445
- Function Syntax Function Chaining via the Dot Operator DuckDB supports the dot syntax for function chaining. This allows the function call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...) . For example, take the followi
...]) breed(goose_name); Using with Literals and Arrays String literals and array access operations can be used with function chaining directly: SELECT 'hello world'.replace(' ', '_'); SELECT m[1].map_entries() FROM (VALUES ([MAP {'hello': 42}, MAP {'world'...: 42}])) t(m); To apply function chaining to numeric literals, you must surround the literal with parentheses, e.g.: SELECT (2).sqrt(); In the absence of these pare...(); ), DuckDB returns a Parser Error for the function call: Parser Error: syntax error at or near "(" Limitations Function chaining via the dot operator is limited to scalar functions and is not supported for table functions. For example, the following c... - https://man.mtool.work/duckdb/2.0/sql/functions/overview.html
- Integration with Ibis 8229
- Ibis is a Python dataframe library that supports 20+ backends, with DuckDB as the default. Ibis with DuckDB provides a Pythonic interface for SQL with great performance. Warning Ibis 12.0.0 and earlier do not support DuckDB 2.0. The example
...51.094118 │ 212 │ │ … │ … │ … │ … │ … │ └───────────┴───────────┴────────┴──────────────────────┴────────────────────────┘ Chaining It All Together We've already chained some Ibis calls together. We used mutate to create a new column and then select to o...nly view a subset of the new table. We were just chaining group_by with aggregate . There's nothing stopping us from putting all of these concepts together to ask questions of the... - https://man.mtool.work/duckdb/2.0/guides/python/ibis.html
- Friendly SQL 8136
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
.... Filename expansion (globbing) , e.g.: FROM 'my-data/part-*.parquet' Functions and Expressions Dot operator for function chaining : SELECT ('hello').upper() String formatters: the format() function with the fmt syntax and the printf() function List com... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Collations 8136
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...hElLO'; true SELECT 'hello' = 'hëllo'; false SELECT 'hello' COLLATE NOACCENT = 'hëllo'; true Collations can be combined by chaining them using the dot operator. Note, however, that not all collations can be combined together. In general, the NOCASE colla... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work