Results of 1 - 10 of about 117 for Names (0.002 sec.)
- Collations 14288
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
.... 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ännes...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 (name...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 = ot... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Keywords and Identifiers 10500
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...b_views)) still uses double quotes. 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...m ⟨database⟩.⟨schema⟩.⟨table⟩.⟨column⟩ , and any leading part can be omitted when the remaining name is unambiguous. Table names can likewise be qualified as ⟨database⟩.⟨schema⟩.⟨table⟩ . When a name is not fully qualified, DuckDB resolves it using th...h, and each entry may be a bare schema or a ⟨catalog⟩.⟨schema⟩ pair. For a detailed description of how database and schema names are resolved, including the default database and schema and how to change the search path, see Name Qualification on the A... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- FROM and JOIN Clauses 9387
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...e regions 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 IN...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...LE city_airport (city_name VARCHAR, iata VARCHAR); CREATE TABLE airport_names (iata VARCHAR, airport_name VARCHAR); INSERT INTO city_airport VALUES ('Amsterdam', 'AMS'), ('Rotterdam', 'RTM'), ('Eindho... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- CSV Import Tips 9087
- Below is a collection of tips to help when attempting to import complex CSV files. In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the hea
...t fail. 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 Types...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 the s... - https://man.mtool.work/duckdb/2.0/data/csv/tips.html
- Timestamp Types 9087
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...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. When strings with UTC offse... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Startup & Shutdown 8787
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...ow_options ( duckdb_arrow_options * arrow_options ); 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/2.0/clients/c/connect.html
- CSV Import 8712
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...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 of the s...lename . Relative or absolute paths are returned depending on the path or glob pattern provided to read_csv , not just filenames. Since DuckDB 1.3.0, the filename column is added automatically as a virtual column and this option is only kept for compa...to detect the schema when reading multiple files. Set to -1 to sniff all files. BIGINT 10 force_not_null A list of column names whose values are not matched against the NULL string (see nullstr or null ). In the default case where the NULL string is... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Unnesting 8712
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...licitly passing false , recursion is disabled. In that case, other additional parameters such as max_depth and keep_parent_names are effectively ignored max_depth : UINT32 , default: 1 . This controls how many levels of recursion should at most be app...ed. Values greater than 1 imply recursion, and in such cases recursive need not be explicitly passed as true . keep_parent_names : BOOLEAN , default: false . Whether to create column names using the keys of all ancestor members. This argument is appli...x, generate_subscripts(l, 1) AS index FROM (VALUES ([1, 2, 3]), ([4, 5])) tbl(l); x index 1 1 2 2 3 3 4 1 5 2 Keep Column Names When Recursively Unnesting The keep_parent_names parameter can be used to retain the parent column names when recursively... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Autocomplete 8500
- The shell offers context-aware autocomplete of SQL queries through the autocomplete extension . autocomplete is triggered by pressing Tab . Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by
...wards. autocompletion can be reverted by pressing ESC twice. The shell autocompletes four different groups: Keywords Table names and table functions Column names and scalar functions File names The shell looks at the position in the SQL statement to d... - https://man.mtool.work/duckdb/2.0/clients/cli/autocomplete.html
- Types 8200
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...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/2.0/clients/c/types.html
DuckDB 2.0 Documentation / man.mtool.work