Results of 1 - 10 of about 10 for intersect (0.006 sec.)
- Set Operations 14015
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...NAME follows set semantics (therefore it performs duplicate elimination), whereas UNION ALL BY NAME follows bag semantics. INTERSECT The INTERSECT clause can be used to select all rows that occur in the result of both queries. Vanilla INTERSECT (Set Seman...tics) Vanilla INTERSECT performs duplicate elimination, so only unique rows are returned. SELECT * FROM range(2) t1(x) INTERSECT SELECT * FROM ran...ge(6) t2(x); x 0 1 INTERSECT ALL (Bag Semantics) INTERSECT ALL follows bag semantics, so duplicates are returned. SELECT unnest([5, 5, 6, 6, 6, 6, 7, 8... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Geometry Functions 9868
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...hat can be used with GEOMETRY values. Operator Description Example Result && Returns true if the geometries bounding boxes intersect. Equivalent to ST_Intersects_Extent . 'POINT(5 5)'::GEOMETRY && 'LINESTRING(0 0, 10 20)'::GEOMETRY true Built-in Geometry...n Binary (WKB) representation of the geometry ST_AsWKT Returns the Well-Known Text (WKT) representation of the geometry ST_Intersects_Extent Returns true if the geometries bounding boxes intersect ST_CRS Returns the Coordinate Reference System (CRS) ident...tation of the geometry | | Example | ST_AsText('POINT(1 2)'::GEOMETRY) | | Result | POINT (1 2) | | Alias | ST_AsText | ST_Intersects_Extent function | Description | Returns true if the geometries bounding boxes intersect | | Example | 'POINT(5 5)'::GEOME... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- R-Tree Indexes 8634
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...bottom, it is possible to very quickly search a R-tree-indexed table for only those rows where the indexed geometry column intersect a specific region of interest, as you can skip searching entire sub-trees if the bounding rectangles of their parent nodes...don't intersect the query region at all. Once the leaf nodes are reached, only the specific rows whose geometries intersect the query regi...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_CoveredB... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- List Functions 8634
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...as_all . array_has_any(list1, list2) Alias for list_has_any . array_indexof(list, element) Alias for list_position . array_intersect(list1, list2) Alias for list_intersect . array_length(list) Alias for length . array_pop_back(list) Returns the list witho...) Alias for list_position . list_inner_product(list1, list2) Computes the inner product between two same-sized lists. list_intersect(list1, list2) Returns a list of all the elements that exist in both list1 and list2 , without duplicates. list_kurtosis(li...-sized lists. | | Example | list_inner_product([1, 2, 3], [1, 2, 3]) | | Result | 14.0 | | Alias | list_dot_product | list_intersect(list1, list2) | Description | Returns a list of all the elements that exist in both list1 and list2 , without duplicates.... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Spatial Functions 8366
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...tePoint Computes the closest point on a LINESTRING to a given POINT and returns the interpolated M value of that point. ST_Intersection Returns the intersection of two geometries ST_Intersects Returns true if the geometries intersect ST_Intersects_Extent...Returns true if the extent of two geometries intersects ST_IsClosed Check if a geometry is 'closed' ST_IsEmpty Returns true if the geometry is "empty". ST_IsRing Returns true if..."noded" MultiLinestring, produced by combining a collection of input linestrings and adding additional vertices where they intersect. ST_Normalize Returns the "normalized" representation of the geometry ST_NumGeometries Returns the number of component geo... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Overview of DuckDB Internals 8098
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...ion or a subquery. QueryNode The QueryNode represents either (1) a SELECT statement, or (2) a set operation (i.e., UNION , INTERSECT or DIFFERENCE ). SQL Statement The SQLStatement represents a complete SQL statement. The type of the SQL Statement represe... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Python Client API 8009
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...; a name of more than three parts needs SQL (INSERT INTO) for now. Detailed examples can be found at Relational API page . intersect ( other_rel : DuckDBPyRelation ) → DuckDBPyRelation Create the set intersection of this relation object with another relat...', 'T[]']), 'histogram': ('list_histogram', 0, []), 'inner_product': ('list_inner_product', 0, ['DOUBLE[]', 'DOUBLE[]']), 'intersect': ('list_intersect', 0, ['T[]', 'T[]']), 'kurtosis': ('list_kurtosis', 0, []), 'kurtosis_pop': ('list_kurtosis_pop', 0, []...OrExpr ) → Expression Computes the inner product between two same-sized lists. Arguments: list2. SQL: list_inner_product . intersect ( * args : ValueOrExpr ) → ListExpr The distinct elements present in both lists. Arguments: list2. SQL: list_intersect . k... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- PEG Parser 8009
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...suggestions. You can cycle through the options using TAB : «animals_db» D FROM ducks WHERE habitat IS IS ISNULL ILIKE ⌊IN⌋ INTERSECT LIKE Extensible Grammar Because the grammar is part of the parser, extensions can extend the tokenizer, add grammar rules,... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Relational API 7919
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...bject by the filter in filter_expr. group_by Begin a grouped aggregation; continue with .agg(...) . head The first n rows. intersect Create the set intersection of this relation object with another relation object in other_rel. join Join the relation obje...│ t-shirt │ clothing │ 8 │ false │ │ 3 │ jacket │ clothing │ 65 │ true │ └───────┴─────────┴──────────┴───────┴──────────┘ intersect intersect(self, other_rel: DuckDBPyRelation) -> DuckDBPyRelation Create the set intersection of this relation object with...another relation object in other_rel. The intersection is INTERSECT ALL , so duplicates count: a row that appears three times in this relation and twice in other_rel appears... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Typecasting 7740
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...r regular implicit casts. This combination casting occurs for comparisons ( = / < / > ), set operations ( UNION / EXCEPT / INTERSECT ), and nested type constructors ( list_value / [...] / MAP ). Casting Operations Matrix Values of a particular data type c... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work