Results of 1 - 10 of about 25 for rather (0.027 sec.)
- JSON Type – DuckDB 14297
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...kDB supports json via the JSON logical type. The JSON logical type is interpreted as JSON, i.e., parsed, in JSON functions rather than interpreted as VARCHAR , i.e., a regular string (modulo the equality-comparison caveat at the bottom of this page). A...logical interpreted functions also back example nested Documentation Import Files Copy Markdown Type supports json parsed rather regular modulo equality 関連するページ Creating JSON Casting Nested Functions Loading JSON Union Type JSON Processing Func... - https://man.mtool.work/duckdb/1.3/data/json/json_type.html
- Interval Type – DuckDB 11490
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...12_345 ) MONTHS ) ) _ ( period ); Warning The microseconds component is split only into hours, minutes, and microseconds, rather than hours, minutes, seconds , and microseconds. Additionally, the amounts of centuries, decades, quarters, seconds, and m...2000-01-01' ), -- '2000-03-03', NOT '2000-03-01' ; Subtracting two DATE s from one another does not create an INTERVAL but rather returns the number of days between the given dates as integer value. Warning Extracting a component of the INTERVAL differ... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Text Functions – DuckDB 10793
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ormat ( 'The answer is {}' , 42 ); -- The answer is 42 Format a string using positional arguments: SELECT format ( 'I '' d rather be {1} than {0}.' , 'right' , 'happy' ); -- I'd rather be happy than right. Format Specifiers Specifier Description Exampl...tional arguments %position$formatter , e.g., the second parameter as a string is encoded as %2$s : SELECT printf ( 'I '' d rather be %2$s than %1$s.' , 'right' , 'happy' ); I'd rather be happy than right. Format Specifiers Specifier Description Example... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- CHECKPOINT Statement – DuckDB 9381
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...therwise), the space occupied by deleted rows is partially reclaimed. Note that this does not remove all deleted rows, but rather merges row groups that have a significant amount of deletes together. In the current implementation this requires ~25% of... - https://man.mtool.work/duckdb/1.3/sql/statements/checkpoint.html
- Concurrency – DuckDB 8684
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...r process. The reason for this concurrency model is to allow for the caching of data in RAM for faster analytical queries, rather than going back and forth to disk during each query. It also allows the caching of functions pointers, the database catalo... - https://man.mtool.work/duckdb/1.3/connect/concurrency.html
- Spatial Functions – DuckDB 8684
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ctangle that bounds the input geometry, finding the surrounding box that has the lowest area by using a rotated rectangle, rather than taking the lowest and highest coordinate values as per ST_Envelope(). ST_Multi Turns a single geometry into a multi g...ctangle that bounds the input geometry, finding the surrounding box that has the lowest area by using a rotated rectangle, rather than taking the lowest and highest coordinate values as per ST_Envelope(). ST_Multi Signature GEOMETRY ST_Multi ( geom GEO...tries. "Slower, but might be more memory efficient than ST_UnionAgg as each geometry is merged into the union individually rather than all at once. ST_Union_Agg Signature GEOMETRY ST_Union_Agg ( col0 GEOMETRY ) Description Computes the union of a set o... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Appender – DuckDB 8684
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e is called, all the data has been written to the database system. Date, Time and Timestamps While numbers and strings are rather self-explanatory, dates, times and timestamps require some explanation. They can be directly appended using the methods pr... - https://man.mtool.work/duckdb/1.3/data/appender.html
- Tuning Workloads – DuckDB 7987
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ts of parameters. Note that it is not a primary design goal for DuckDB to quickly execute many small queries concurrently. Rather, it is optimized for running larger, less frequent queries. Querying Remote Files DuckDB uses synchronous IO when reading... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- Indexing – DuckDB 7987
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...5× faster. Ordered Integers Another practical way to exploit ordering is to use the INTEGER type with automatic increments rather than UUID for columns queried using selective filters. In a scenario where a table contains out-of-order UUID s, DuckDB ha... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Jupyter Notebooks – DuckDB 7987
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...l taxi data from NYC. Using the Parquet format allows DuckDB to only pull the rows and columns into memory that are needed rather than downloading the entire file. DuckDB can be used to process local Parquet files as well, which may be desirable if que... - https://man.mtool.work/duckdb/1.3/guides/python/jupyter.html
DuckDB 1.3 Documentation / man.mtool.work