Results of 1 - 10 of about 36 for unique (0.003 sec.)
- Constraints – DuckDB 15072
- 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
...NULL ); INSERT INTO students VALUES ( NULL ); Constraint Error: NOT NULL constraint failed: students.name Primary Key and Unique Constraint Primary key or unique constraints define a column, or set of columns, that are a unique identifier for a row in...the table. The constraint enforces that the specified columns are unique within a table, i.e., that at most one row contains the given values for the set of columns. CREATE TABLE students ( id IN...y constraint In order to enforce this property efficiently, an ART index is automatically created for every primary key or unique constraint that is defined in the table. Primary key constraints and unique constraints are identical except for two point... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Information Schema – DuckDB 12156
- 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
...raint is defined on. For a foreign key constraint, this view identifies the columns that the foreign key references. For a unique or primary key constraint, this view identifies the constrained columns. Column Description Type Example table_catalog Nam...m_id' ordinal_position Ordinal position of the column within the constraint key (count starts at 1). INTEGER 1 position_in_unique_constraint For a foreign-key constraint, ordinal position of the referenced column within its unique constraint (count sta...he schema containing the constraint. VARCHAR main constraint_name Name of the constraint. VARCHAR exam_id_students_id_fkey unique_constraint_catalog Name of the database that contains the unique or primary key constraint that the foreign key constraint... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- SELECT Clause – DuckDB 9366
- 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 root FROM table_name ; Use prefix aliases: SELECT res : col1 + col2 , root : sqrt ( col1 ) FROM table_name ; Select all unique cities from the addresses table: SELECT DISTINCT city FROM addresses ; Return the total number of rows in the addresses ta...d using regular expressions or lambda functions. See the star expression page for more details. DISTINCT Clause Select all unique cities from the addresses table: SELECT DISTINCT city FROM addresses ; The DISTINCT clause can be used to return only the...CT ON ( country ) city , population FROM cities ORDER BY population DESC ; The DISTINCT ON clause returns only one row per unique value in the set of expressions as defined in the ON clause. If an ORDER BY clause is present, the row that is returned is... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Full-Text Search – DuckDB 8922
- 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
...LL speaker VARCHAR YES NULL NULL NULL text_entry VARCHAR YES NULL NULL NULL The text of each line is in text_entry , and a unique key for each line is in line_id . Creating a Full-Text Search Index First, we create the index, specifying the table name,...the unique id column, and the column(s) to index. We will just index the single column text_entry , which contains the text of the li...ull-text searching from JSON” blog post . The Columns are: line_id, play_name, line_number, speaker, text_entry. We need a unique key for each row in order for full-text searching to work. The line_id KL/2.4.132 means King Lear, Act 2, Scene 4, Line 13... - https://man.mtool.work/duckdb/1.3/guides/sql_features/full_text_search.html
- Set Operations – DuckDB 8922
- 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
...ON (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 range ( 3 ) t2 ( x ); x 2 1 0...in the result of both queries. Vanilla INTERSECT (Set Semantics) Vanilla INTERSECT performs duplicate elimination, so only unique rows are returned. SELECT * FROM range ( 2 ) t1 ( x ) INTERSECT SELECT * FROM range ( 6 ) t2 ( x ); x 0 1 INTERSECT ALL (B...Vanilla EXCEPT (Set Semantics) Vanilla EXCEPT follows set semantics, therefore, it performs duplicate elimination, so only unique rows are returned. SELECT * FROM range ( 5 ) t1 ( x ) EXCEPT SELECT * FROM range ( 2 ) t2 ( x ); x 2 3 4 EXCEPT ALL (Bag S... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- DuckDB_% Metadata Functions – DuckDB 8605
- 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
...name) of the table object that defines the column. BIGINT column_name The SQL name of the column. VARCHAR column_index The unique position of the column within its table. INTEGER comment A comment created by the COMMENT ON statement . VARCHAR internal...INT constraint_type Indicates the type of constraint. Applicable values are CHECK , FOREIGN KEY , PRIMARY KEY , NOT NULL , UNIQUE . VARCHAR constraint_text The definition of the constraint expressed as a SQL-phrase. (Not necessarily a complete or synta...ent A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) is_unique true if the index was created with the UNIQUE modifier, false if it was not. BOOLEAN is_primary Always false . BOOLEAN exp... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- CREATE INDEX Statement – DuckDB 8495
- 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
...INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films ( id ); Create index s_idx...the sum of columns j and k from table 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 ti... - https://man.mtool.work/duckdb/1.3/sql/statements/create_index.html
- Summarize – DuckDB 8384
- 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
...a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 , q50 , q75 , count ), and return these along the column name, column type, and the percentage of NULL v...extension . INSTALL tpch ; LOAD tpch ; CALL dbgen ( sf = 1 ); SUMMARIZE lineitem ; column_name column_type min max approx_unique avg std q25 q50 q75 count null_percentage l_orderkey INTEGER 1 6000000 1508227 3000279.604204982 1732187.8734803519 150944...r_Trek-Season_1.csv' ; 関連キーワード table column query summarize example tpch command used number aggregates over approx unique count type percentage values order lineitem using extension summary Documentation Guides Meta 関連するページ query and que... - https://man.mtool.work/duckdb/1.3/guides/meta/summarize.html
- List Functions – DuckDB 8384
- 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
...lt of applying the lambda function to each element of the input list. See the Lambda Functions page for more details. list_unique(list) Counts the unique elements of a list. list_value(any, ...) Create a LIST containing the argument values. list_where(...ple list_transform([4, 5, 6], x -> x + 1) Result [5, 6, 7] Aliases array_transform , apply , list_apply , array_apply list_unique(list) Description Counts the unique elements of a list. Example list_unique([1, 1, NULL, -3, 1, 5]) Result 3 Alias array_u... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- INSERT Statement – DuckDB 8288
- 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
...rt the default value into a column: INSERT INTO tbl ( i ) VALUES ( 1 ), ( DEFAULT ), ( 3 ); Assuming tbl has a primary key/unique constraint, do nothing on conflict: INSERT OR IGNORE INTO tbl ( i ) VALUES ( 1 ); Or update the table with the new values...fault value. ON CONFLICT Clause An ON CONFLICT clause can be used to perform a certain action on conflicts that arise from UNIQUE or PRIMARY KEY constraints. An example for such a conflict is shown in the following example: CREATE TABLE tbl ( i INTEGER...: Constraint Error: NOT NULL constraint failed: t1.val2 Composite Primary Key When multiple columns need to be part of the uniqueness constraint, use a single PRIMARY KEY clause including all relevant columns: CREATE TABLE t1 ( id1 INTEGER , id2 INTEGE... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
DuckDB 1.3 Documentation / man.mtool.work