Results of 1 - 10 of about 19 for duplicate (0.005 sec.)
- Set Operations – DuckDB 13899
- 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
...o the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates, while the variants with ALL use bag semantics. Traditional set operations unify queries by column position , and require...lause throws an error. Vanilla UNION (Set Semantics) The vanilla UNION clause follows set semantics, therefore it performs duplicate elimination, i.e., only unique rows will be included in the result. SELECT * FROM range ( 2 ) t1 ( x ) UNION SELECT * FROM...( x ); x 2 1 0 UNION ALL (Bag Semantics) UNION ALL returns all rows of both queries following bag semantics, i.e., without duplicate elimination. SELECT * FROM range ( 2 ) t1 ( x ) UNION ALL SELECT * FROM range ( 3 ) t2 ( x ); x 0 1 0 1 2 UNION [ALL] BY N... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- CREATE INDEX Statement – DuckDB 12055
- 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
...idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films ( id ); Create index s_idx that allows for duplicate values on column revenue of table films : CREATE INDEX s_idx ON films ( revenue ); Create index if it does not yet exist:...integers : CREATE INDEX i_index ON integers (( j + k )); Parameters Name Description UNIQUE Causes the system to check for duplicate values in the table when the index is created (if data already exist) and each time data is added. Attempts to insert or u...pdate data that would result in duplicate entries will generate an error. name The name of the index to be created. table The name of the table to be indexed. colum... - https://man.mtool.work/duckdb/1.3/sql/statements/create_index.html
- Constraints – DuckDB 10193
- 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
...HAR ); INSERT INTO students VALUES ( 1 , 'Student 1' ); INSERT INTO students VALUES ( 1 , 'Student 2' ); Constraint Error: Duplicate key "id: 1" violates primary key constraint CREATE TABLE students ( id INTEGER , name VARCHAR , PRIMARY KEY ( id , name ))...1' ); INSERT INTO students VALUES ( 1 , 'Student 2' ); INSERT INTO students VALUES ( 1 , 'Student 1' ); Constraint Error: Duplicate key "id: 1, name: Student 1" violates primary key constraint In order to enforce this property efficiently, an ART index i...t 1' , ' [email protected] ' ); INSERT INTO students VALUES ( 2 , 'Student 2' , ' [email protected] ' ); Constraint Error: Duplicate key "email: [email protected] " violates unique constraint. INSERT INTO students ( id , name ) VALUES ( 3 , 'Student 3' );... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Python Client API – DuckDB 9152
- 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 can be used in queries cursor ( self : duckdb.duckdb.DuckDBPyConnection ) → duckdb.duckdb.DuckDBPyConnection ¶ Create a duplicate of the current connection decimal_type ( self : duckdb.duckdb.DuckDBPyConnection , width : int , scale : int ) → duckdb.du...yConnection , type_str : str ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a type object by parsing the ‘type_str' string duplicate ( self : duckdb.duckdb.DuckDBPyConnection ) → duckdb.duckdb.DuckDBPyConnection ¶ Create a duplicate of the current connect...sed in queries duckdb. cursor ( * , connection : duckdb.DuckDBPyConnection = None ) → duckdb.DuckDBPyConnection ¶ Create a duplicate of the current connection duckdb. decimal_type ( width : int , scale : int , * , connection : duckdb.DuckDBPyConnection =... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- SQL Introduction – DuckDB 8947
- 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
...t you'd always get the results shown above if you do: SELECT * FROM weather ORDER BY city , temp_lo ; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather ; city San Francisco Hayward Here again, the...94.000 Since the columns all had different names, the parser automatically found which table they belong to. If there were duplicate column names in the two tables you'd need to qualify the column names to show which one you meant, as in: SELECT weather.c...r.city ; It is widely considered good style to qualify all column names in a join query, so that the query won't fail if a duplicate column name is later added to one of the tables. Join queries of the kind seen thus far can also be written in this altern... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Java JDBC Client – DuckDB 8332
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...Additional connections can be created using the DriverManager . A more efficient mechanism is to call the DuckDBConnection#duplicate() method: Connection conn2 = (( DuckDBConnection ) conn ). duplicate (); Multiple connections are allowed, but mixing read... - https://man.mtool.work/duckdb/1.3/clients/java.html
- Appender – DuckDB 7922
- 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
...nstraint violation, it fails and returns the following error: Constraint Error: PRIMARY KEY or UNIQUE constraint violated: duplicate key "..." In this case, the entire append operation fails and no rows are inserted. Appender Support in Other Clients The... - https://man.mtool.work/duckdb/1.3/data/appender.html
- Overview of DuckDB Internals – DuckDB 7922
- 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
...Rewriter : Simplifies expressions, performs constant folding Filter Pushdown : Pushes filters down into the query plan and duplicates filters over equivalency sets. Also prunes subtrees that are guaranteed to be empty (because of filters that statically e...k is used. Common Sub Expressions : Extracts common subexpressions from projection and filter nodes to prevent unnecessary duplicate execution. In Clause Rewriter : Rewrites large static IN clauses to a MARK join or INNER join. Column Binding Resolver The... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- GROUP BY Clause – DuckDB 7922
- 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
...( income ) FROM addresses GROUP BY city , street_name ; GROUP BY ALL Examples Group by city and street_name to remove any duplicate values: SELECT city , street_name FROM addresses GROUP BY ALL ; Compute the average income per city per street_name. Since... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/groupby.html
- Timestamp Issues – DuckDB 7718
- 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 one by one because the underlying binning computation computes all parts, so picking out the ones in the list is avoids duplicate calls to the slow ICU function. Also notice that we are leveraging the DATE cast rules from the previous section to bound... - https://man.mtool.work/duckdb/1.3/guides/sql_features/timestamps.html
DuckDB 1.3 Documentation / man.mtool.work