Results of 1 - 7 of about 7 for Predicate (0.006 sec.)
- R-Tree Indexes – DuckDB 11832
- 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
...whose geometries intersect the query region have to be fetched from disk, and the often much more expensive exact spatial predicate check (and any other filters) only have to be executed for these rows. What Are the Limitations of R-Tree Indexes in DuckD...only be used to perform "index scans" when the table is filtered (using a WHERE clause) with one of the following spatial predicate functions (as they all imply intersection): ST_Equals , ST_Intersects , ST_Touches , ST_Crosses , ST_Within , ST_Contains..., ST_Overlaps , ST_Covers , ST_CoveredBy , ST_ContainsProperly . One of the arguments to the spatial predicate function must be a “constant” (i.e., an expression whose result is known at query planning time). This is because the quer... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- inet Extension – DuckDB 11250
- 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
...broadcast(cidr) 192.168.1.5/24 192.168.1.0/24 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::/96 <<= Predicate Is subnet contained by or equal to subnet? CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '192.168.1.0/24' ), (...cidr (CAST('192.168.1.5/32' AS INET) «= cidr) 192.168.1.5/24 true 127.0.0.1 false 2001:db8:3c4d:15::1a2f:1a2b/96 false >>= Predicate Does subnet contain or equal subnet? CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '192.168.1.0/24' ), ( '127.0...────────────────┘ 関連キーワード cidr ffff network inet subnet host netmask address broadcast extension addresses Computes Predicate equal escape varchar unescape Documentation Core Extensions Copy Markdown Extension defines type 関連するページ Environmen... - https://man.mtool.work/duckdb/1.3/core_extensions/inet.html
- Boolean Type – DuckDB 10069
- 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
...n the WHERE and HAVING clauses of a SQL statement to filter out tuples from the result. In this case, tuples for which the predicate evaluates to true will pass the filter, and tuples for which the predicate evaluates to false or NULL will be filtered out...関連キーワード Boolean values truth tuples table integers Logical statement created conjunctions example used filter case predicate evaluates filtered Below conjunction Operators Documentation Types Copy Markdown Type 関連するページ NULL Values Logical O... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
- FROM and JOIN Clauses – DuckDB 8524
- 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
...ult row has the columns from both relations. A join uses a rule to match pairs of rows from each relation. Often this is a predicate, but there are other implied rules that may be specified. Outer Joins Rows that do not have any matches can still be retur...equivalent to omitting the JOIN clause: SELECT a . * , b . * FROM a , b ; Conditional Joins Most joins are specified by a predicate that connects attributes from one side to attributes from the other side. The conditions can be explicitly specified using...CT n . * , r . * FROM l_nations n JOIN l_regions r USING ( regionkey ); The expressions do not have to be equalities – any predicate can be used: Return the pairs of jobs where one ran longer but cost less: SELECT s1.t_id , s2.t_id FROM west s1 , west s2... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- Parquet Tips – DuckDB 7361
- 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
...more opportunities to compress the data. DuckDB can read Parquet row groups in parallel even within the same file and uses predicate pushdown to only scan the row groups whose metadata ranges match the WHERE clause of the query. However there is some over... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Comparisons – DuckDB 7361
- 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 below in the cases where both a , x and y are of the same type, as BETWEEN will cast all of its inputs to the same type. Predicate Description a BETWEEN x AND y equivalent to x <= a AND a <= y a NOT BETWEEN x AND y equivalent to x > a OR a > y expressio... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Indexing – DuckDB 7161
- 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
...cally creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan operators and computing aggregations use zonemaps. If a filter criterion (like WHERE column1 = 123 ) is... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work