Results of 1 - 10 of about 110 for Different (0.004 sec.)
- Text Functions – DuckDB 14070
- 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
...perations (insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g., a and A ) are considered different. editdist3(s1, s2) The minimum number of single-character edits (insertion...s, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., a and A ) are considered different. hamming(s1, s2) The Hamming distance between to strings, i.e., the number...of positions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., a and A... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Non-Deterministic Behavior – DuckDB 12775
- 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
...DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-threaded query execution. Other fac...tors, such as using different compilers, operating systems, and hardware architectures, can also cause changes in ordering. This page documents the case...rces of non-determinism is the set semantics used by SQL. E.g., if you run the following query repeatedly, you may get two different results: SELECT * FROM ( SELECT 'A' AS x UNION SELECT 'B' AS x ); Both results A , B and B , A are correct. Different Resu... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- Collations – DuckDB 9892
- 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
...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. These orderings are often incompatible with one another. For example,...lish the letter y comes between x and z . However, in Lithuanian the letter y comes between the i and j . For that reason, different collations are supported. The user must choose which collation they want to use when performing sorting and comparison ope...INSERT INTO names VALUES ( 'hännes' ); SELECT name FROM names WHERE name = 'hannes' ; hännes Be careful here, however, as different collations cannot be combined. This can be problematic when you want to compare columns that have a different collation sp... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Data Types – DuckDB 9194
- 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
.... Nested / Composite Types DuckDB supports five nested data types: ARRAY , LIST , MAP , STRUCT , and UNION . Each supports different use cases and has a different structure. Name Description Rules when used in a column Build from values Define in DDL/CREA...amed values, each key having the same type and each value having the same type. Keys and values can be any type and can be different types from one another. Rows may have different keys. map([1, 2], ['a', 'b']) MAP(INTEGER, VARCHAR) STRUCT A dictionary of...multiple named values, where each key is a string, but the value can be a different type for each key. Each row must have the same keys. {'i': 42, 'j': 'a'} STRUCT(i INTEGER, j VARCHAR) UNION A union of mul... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Deploying DuckDB-Wasm – DuckDB 8800
- 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
...com/duckdb/duckdb-wasm/tree/main/examples/bare-browser . JS Worker Component This is distributed as a JavaScript file in 3 different flavors, mvp , eh and threads , and needs to be served as is, and the main library components needs to be informed of the...actual location. There are 3 variants for 3 different platforms : MVP targets WebAssembly 1.0 spec EH targets WebAssembly 1.0 spec WITH Wasm-level exceptions handling added, th...ngle variant and instruct duckdb-wasm library on which one to use Wasm Worker Component Same as the JS Worker component, 3 different flavors, mvp , eh and threads , each one is needed by the relevant JS component. These WebAssembly modules needs to be ser... - https://man.mtool.work/duckdb/1.3/clients/wasm/deploying_duckdb_wasm.html
- Parquet Tips – DuckDB 8305
- 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
...of tips to help when dealing with Parquet files. Tips for Reading Parquet Files Use union_by_name When Loading Files with Different Schemas The union_by_name option can be used to unify the schema of files that have different or missing columns. For file...queries, but slow down queries that must scan the whole file like aggregations. To write a query to a Parquet file with a different row group size, run: COPY ( FROM generate_series ( 100_000 )) TO 'row-groups.parquet' ( FORMAT parquet , ROW_GROUP_SIZE 10...関連キーワード Parquet groups parquet number group files Files Tips union read thread generate series size query tips used different columns good multiple improve parameter minimum rows 関連するページ File Formats Parquet Export Parquet Import Querying Pa... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Combining Schemas – DuckDB 8203
- 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
...s instead. Below is an example of how both methods work. Union by Position By default, DuckDB unifies the columns of these different files by position . This means that the first column in each file is combined together, as well as the second column in ea...geles, CA This is equivalent to the SQL construct UNION ALL . Union by Name If you are processing multiple files that have different schemas, perhaps because columns have been added or renamed, it might be desirable to unify the columns of different files...ork, NY|Los Angeles, CA Reading these when unifying column names by position results in an error – as the two files have a different number of columns. When specifying the union_by_name option, the columns are correctly unified, and any missing values are... - https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html
- Spatial Extension – DuckDB 7810
- 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 extension is the GEOMETRY type. If you're unfamiliar with geospatial data and GIS tooling, this type probably works very different from what you'd expect. On the surface, the GEOMETRY type is a binary representation of “geometry” data made up out of set...of X and Y double precision floats). But what makes it somewhat special is that its actually used to store one of several different geometry subtypes. These are POINT , LINESTRING , POLYGON , as well as their “collection” equivalents, MULTIPOINT , MULTIL...nversion cost, so the GEOMETRY type is still the recommended type to use for now if you are planning to work with a lot of different spatial functions. GEOMETRY is not currently capable of storing additional geometry types such as curved geometries or tri... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/overview.html
- CSV Import – DuckDB 7810
- 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
..., there are a lot of inconsistencies found within CSV files that can make loading them a challenge. CSV files come in many different varieties, are often corrupt, and do not have a schema. The CSV reader needs to cope with all of these different situation.... The CSV parser only distinguishes between single-character and double-character line delimiters. Therefore, it does not differentiate between '\r' and '\n' . VARCHAR (empty) normalize_names Normalize column names. This removes any non-alphanumeric char.... BOOL true thousands Character used to identify thousands separators in numeric values. It must be a single character and different from the decimal_separator option. VARCHAR (empty) timestampformat Timestamp format used when parsing and writing timestam... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Samples – DuckDB 7810
- 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
...rs to queries faster, as they reduce the amount of data that needs to pass through the query engine. DuckDB supports three different types of sampling methods: reservoir , bernoulli and system . By default, DuckDB uses reservoir sampling when an exact num...only reservoir sampling supports sampling a fixed number of rows. Samples are probablistic, that is to say, samples can be different between runs unless the seed is specifically specified. Specifying the seed only guarantees that the sample is the same if...so incurs an additional performance penalty when multi-processing is used, since the reservoir is to be shared amongst the different threads to ensure unbiased sampling. This is not a big problem when the reservoir is very small, but becomes costly when t... - https://man.mtool.work/duckdb/1.3/sql/samples.html
DuckDB 1.3 Documentation / man.mtool.work