Results of 1 - 10 of about 51 for even (0.012 sec.)
- Relational API – DuckDB 17565
- 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
...onnect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp fr...onnect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp fr...onnect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp fr... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Numeric Functions – DuckDB 10131
- 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
...cosine of x . cot(x) Computes the cotangent of x . degrees(x) Converts radians to degrees. divide(x, y) Alias for x // y . even(x) Round to next even number by rounding away from zero. exp(x) Computes e ** x . factorial(x) See the ! operator. Compute...ower of y . radians(x) Converts degrees to radians. random() Returns a random number x in the range 0.0 <= x < 1.0 . round_even(v NUMERIC, s INTEGER) Alias of roundbankers(v, s) . Round to s decimal places using the rounding half to even rule . Value...ans to degrees. Example degrees(pi()) Result 180 divide(x, y) Description Alias for x // y . Example divide(5, 2) Result 2 even(x) Description Round to next even number by rounding away from zero. Example even(2.9) Result 4 exp(x) Description Compute... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Samples – DuckDB 8287
- 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
...it makes sense to specify the bernoulli sampling option instead, which applies the probability to each row independently. Even then, you'll sometimes get more and sometimes less than the specified percentage of the number of rows, but it is much les...ed (i.e., SET threads = 1 ). In the case of multiple threads running over a sample, samples are not necessarily consistent even with a fixed seed. reservoir Reservoir sampling is a stream sampling technique that selects a random sample by keeping a r...d with a chance equal to the specified percentage. As a result, bernoulli sampling can return a different number of tuples even if the same percentage is specified. The expected number of rows is equal to the specified percentage of the table, but th... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Typecasting – DuckDB 7868
- 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
...lenient than regular implicit casts. For example, a BOOL value may be cast to INT (with true mapping to 1 and false to 0 ) even though this is not possible for regular implicit casts. This combination casting occurs for comparisons ( = / < / > ), set...ibes which conversions are supported. When implicit casting is allowed, it implies that explicit casting is also possible. Even though a casting operation is supported based on the source and target data type, it does not necessarily mean the cast op...nversion Error: Type INT32 with value 999 can't be cast because the value is out of range for the destination type INT8 So even though the cast operation from INTEGER to TINYINT is supported, it is not possible for this particular value. TRY_CAST can... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Reading and Writing Parquet Files – DuckDB 7733
- 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
...you apply a filter to a column that is scanned from a Parquet file, the filter will be pushed down into the scan, and can even be used to skip parts of the file using the built-in zonemaps. Note that this will depend on whether or not your Parquet f...SION zstd , COMPRESSION_LEVEL 1 ); Write to Parquet file with key-value metadata : COPY ( SELECT 42 AS number , true AS is_even ) TO 'kv_metadata.parquet' ( FORMAT parquet , KV_METADATA { number : 'Answer to life, universe, and everything' , is_even... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- Complete API – DuckDB 7583
- 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
...do not yet have a fully functional alternative. Therefore, they will not removed before the alternative is available, and even then, there will be a grace period of a few minor versions before removing them. The reason that the methods are already d...succeed unless there is a malloc failure. Note that duckdb_destroy_config should always be called on the resulting config, even if the function returns DuckDBError . Syntax duckdb_state duckdb_create_config ( duckdb_config * out_config ); Parameters...ing duckdb_result_error . Note that after running duckdb_query , duckdb_destroy_result must be called on the result object even if the query fails, otherwise the error stored within the result will not be freed correctly. Syntax duckdb_state duckdb_q... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Interval Type – DuckDB 7508
- 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
...:00:00' - INTERVAL '3 days 23 hours' , -- wraps; equals TIME '03:00:00' ; Adding an INTERVAL to a DATE returns a TIMESTAMP even when the INTERVAL has no microseconds component. The result is the same as if the DATE was cast to a TIMESTAMP (which sets...s and the months basis unit to 30 days, or 30 * 24 * 60 * 60 * 1e6 microseconds. As a result, INTERVAL s can compare equal even when they are functionally different, and the ordering of INTERVAL s is not always preserved when they are added to dates... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- CREATE TABLE Statement – DuckDB 7448
- 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
...connection to DuckDB is closed they will be automatically dropped. Temporary tables reside in memory rather than on disk (even when connecting to a persistent DuckDB), but if the temp_directory configuration is set when connecting or with a SET comm...shorthand for dropping the existing table and then creating the new one. Create a table with two integer columns (i and j) even if t1 already exists: CREATE OR REPLACE TABLE t1 ( i INTEGER , j INTEGER ); IF NOT EXISTS The IF NOT EXISTS syntax will on... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- R-Tree Indexes – DuckDB 7373
- 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
...common that you want to filter rows based on their spatial relationship with a specific region of interest. Unfortunately, even though DuckDB's vectorized execution engine is pretty fast, this sort of operation does not scale very well to large datas...aded into memory and stay there for the duration of the database connection. However, all memory used by the R-tree index (even during bulk-loading) is tracked by DuckDB, and will count towards the memory limit set by the memory_limit configuration p...ssolved and all the entries reinserted from the top of the tree. This is a common operation in R-tree implementations to prevent the tree from becoming too unbalanced. R-Tree Table Functions The rtree_index_dump(VARCHAR) table function can be used to... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- DuckDB Wasm – DuckDB 7298
- 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
...as a limited amount of memory available. WebAssembly limits the amount of available memory to 4 GB and browsers may impose even stricter limits. Pages in This Section 関連キーワード DuckDB Wasm WebAssembly client Documentation amount memory available... - https://man.mtool.work/duckdb/1.3/clients/wasm/overview.html
DuckDB 1.3 Documentation / man.mtool.work