Results of 1 - 10 of about 81 for names (0.007 sec.)
- Collations – DuckDB 13851
- 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
.... When that column is then used in a comparison, the per-column collation is used to perform that comparison. CREATE TABLE names ( name VARCHAR COLLATE NOACCENT ); INSERT INTO names VALUES ( 'hännes' ); SELECT name FROM names WHERE name = 'hannes' ; h...ined. This can be problematic when you want to compare columns that have a different collation specified. SELECT name FROM names WHERE name = 'hannes' COLLATE NOCASE ; ERROR: Cannot combine types with different collation! CREATE TABLE other_names ( na...me VARCHAR COLLATE NOCASE ); INSERT INTO other_names VALUES ( 'HÄNNES' ); SELECT names.name AS name , other_names.name AS other_name FROM names , other_names WHERE names.name... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Keywords and Identifiers – DuckDB 11228
- 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
...FIER "X" , use "IDENTIFIER ""X""" . Deduplicating Identifiers In some cases, duplicate identifiers can occur, e.g., column names may conflict when unnesting a nested data structure. In these cases, DuckDB automatically deduplicates column names by ren...LECT * FROM ( SELECT UNNEST ({ 'a' : 42 , 'b' : { 'a' : 88 , 'b' : 99 }}, recursive : = true )); a a_1 b 42 88 99 Database Names Database names are subject to the rules for identifiers . Additionally, it is best practice to avoid DuckDB's two internal...database schema names , system and temp . By default, persistent databases are named after their filename without the extension. Therefore, the... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- FROM and JOIN Clauses – DuckDB 10490
- 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
...called table_name : SELECT * FROM table_name ; Select all columns from the table using the FROM -first syntax: FROM table_name SELECT * ; Select all columns using the FROM -first syntax and omitting the SELECT clause: FROM table_name ; Select all col...ns for the nations: SELECT n . * , r . * FROM l_nations n JOIN l_regions r ON ( n_regionkey = r_regionkey ); If the column names are the same and are required to be equal, then the simpler USING syntax can be used: CREATE TABLE l_regions ( regionkey I...sed on attributes that share the same name. For example, take the following example with cities, airport codes and airport names. Note that both tables are intentionally incomplete, i.e., they do not have a matching pair in the other table. CREATE TAB... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- CSV Import Tips – DuckDB 9261
- 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
...il. Provide the header option to override this behavior. SELECT * FROM read_csv ( 'flights.csv' , header = true ); Provide Names if the File Does Not Contain a Header If the file does not contain a header, names will be auto-generated by default. You...can provide your own names with the names option. SELECT * FROM read_csv ( 'flights.csv' , names = [ 'DateOfFlight' , 'CarrierName' ]); Override the...le where the table has more columns than the CSV file, you can use the INSERT INTO ... BY NAME clause : INSERT INTO tbl BY NAME SELECT * FROM read_csv ( 'input.csv' ); Sample Size If the CSV sniffer is not detecting the correct type, try increasing th... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
- Startup & Shutdown – DuckDB 9083
- 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
..._client_context ( duckdb_client_context * context ); const char * duckdb_library_version (); duckdb_value duckdb_get_table_names ( duckdb_connection connection , const char * query , bool qualified ); duckdb_create_instance_cache Creates a new databas...tensions that must return this for a compatibility check. Syntax const char * duckdb_library_version ( ); duckdb_get_table_names Get the list of (fully qualified) table names of the query. Syntax duckdb_value duckdb_get_table_names ( duckdb_connection...connection , const char * query , bool qualified ); Parameters connection : The connection for which to get the table names. query : The query for which to get the table names. qualified : Returns fully qualified table names (catalog.schema.table... - https://man.mtool.work/duckdb/1.3/clients/c/connect.html
- CSV Import – DuckDB 9083
- 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
...Must be large enough to hold four lines and can significantly impact performance. BIGINT 16 * max_line_size columns Column names and types, as a struct (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection. STRUCT...lename . Relative or absolute paths are returned depending on the path or glob pattern provided to read_csv , not just filenames. Since DuckDB v1.3.0, the filename column is added automatically as a virtual column and this option is only kept for comp...values are read as zero-length strings instead of NULL s. VARCHAR[] [] header First line of each file contains the column names. BOOL false hive_partitioning Interpret the path as a Hive partitioned path . BOOL (auto-detected) ignore_errors Ignore an... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Types – DuckDB 8838
- 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
...ype value_type ); duckdb_logical_type duckdb_create_union_type ( duckdb_logical_type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_struct_type ( duckdb_logical_type * member_types , const char **...member_names , idx_t member_count ); duckdb_logical_type duckdb_create_enum_type ( const char ** member_names , idx_t member_count ); d...cal_type . Syntax duckdb_logical_type duckdb_create_union_type ( duckdb_logical_type * member_types , const char ** member_names , idx_t member_count ); Parameters member_types : The array of union member types. member_names : The union member names.... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Timestamp Types – DuckDB 8592
- 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
...etween Strings and Naïve / Time Zone-Aware Timestamps The conversion between strings without UTC offsets or IANA time zone names and WITHOUT TIME ZONE types is unambiguous and straightforward. The conversion between strings with UTC offsets or time zo...ne names and WITH TIME ZONE types is also unambiguous, but requires the ICU extension to handle time zone names. When strings witho...ut UTC offsets or time zone names are converted to a WITH TIME ZONE type, the string is interpreted in the configured time zone. Conversely, when strings wi... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- CREATE TABLE Statement – DuckDB 8264
- 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
...ELECT (CTAS): CREATE TABLE t1 AS SELECT 42 AS i , 84 AS j ; Create a table from a CSV file (automatically detecting column names and types): CREATE TABLE t1 AS SELECT * FROM read_csv ( 'path/file.csv' ); We can use the FROM -first syntax to omit SELEC...read_csv ( 'path/file.csv' ); Copy the schema of t2 to t1 : CREATE TABLE t1 AS FROM t2 LIMIT 0 ; Note that only the column names and types are copied to t2 , other pieces of information (indexes, constraints, default values, etc.) are not copied. Temp...be spilled to disk if memory becomes constrained. Create a temporary table from a CSV file (automatically detecting column names and types): CREATE TEMP TABLE t1 AS SELECT * FROM read_csv ( 'path/file.csv' ); Allow temporary tables to off-load excess... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- Complete API – DuckDB 8182
- 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
..._client_context ( duckdb_client_context * context ); const char * duckdb_library_version (); duckdb_value duckdb_get_table_names ( duckdb_connection connection , const char * query , bool qualified ); Configuration duckdb_state duckdb_create_config (...ype value_type ); duckdb_logical_type duckdb_create_union_type ( duckdb_logical_type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_struct_type ( duckdb_logical_type * member_types , const char **...member_names , idx_t member_count ); duckdb_logical_type duckdb_create_enum_type ( const char ** member_names , idx_t member_count ); d... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work