Results of 1 - 10 of about 21 for alternative (0.084 sec.)
- DBeaver SQL IDE – DuckDB 13277
- 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
...e path. Click “Test Connection”. This will then prompt you to install the DuckDB JDBC driver. If you are not prompted, see alternative driver installation instructions below. Click “Download” to download DuckDB's JDBC driver from Maven. Once download is com...d create a new SQL script. Write some SQL and click the “Execute” button. Now you're ready to fly with DuckDB and DBeaver! Alternative Driver Installation If not prompted to install the DuckDB driver when testing your connection, return to the “Connect to a...e © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Installing DBeaver Alternative Driver Installation... - https://man.mtool.work/duckdb/1.3/guides/sql_editors/dbeaver.html
- Union Type – DuckDB 12093
- 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
...n Type A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference being that these UNION types are tagged unions and thus always carr...y a discriminator “tag” which signals which alternative it is currently holding, even if the inner value itself is null. UNION types are thus more similar to C++17's std::variant...tbl1 ; u 1 two three Select all the str members: SELECT union_extract ( u , 'str' ) AS str FROM tbl1 ; str NULL two three Alternatively, you can use 'dot syntax' similarly to STRUCT s . SELECT u.str FROM tbl1 ; str NULL two three Select the currently activ... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- Iceberg Extension – DuckDB 11704
- 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
..., or unsafe characters which will be explicitly passed formatted into filenames in the logic described below. Working with Alternative Metadata Naming Conventions The iceberg extension can handle different metadata naming conventions by specifying them as a...odec . The behavior described above is provided by the default value of "v%s%s.metadata.gz,%s%smetadata.gz . If you had an alternatively named metadata file, e.g., rev-2.metadata.json.gz , the table can be read via the follow statement: SELECT * FROM iceber...g_snapshots ( 'data/iceberg/alternative_metadata_gz_naming' , version = '2' , version_name_format = 'rev-%s.metadata.json%s' , metadata_compression_codec = 'gzip'... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/overview.html
- INSERT Statement – DuckDB 8930
- 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
...s the table with the row <i: 1, j: 42> . INSERT OR IGNORE INTO The INSERT OR IGNORE INTO ... statement is a shorter syntax alternative to INSERT INTO ... ON CONFLICT DO NOTHING . For example, the following statements are equivalent: INSERT OR IGNORE INTO tb...DED .j ; SELECT * FROM tbl ; i j 1 336 INSERT OR REPLACE INTO The INSERT OR REPLACE INTO ... statement is a shorter syntax alternative to INSERT INTO ... DO UPDATE SET c1 = EXCLUDED.c1, c2 = EXCLUDED.c2, ... . That is, it updates every column of the existin... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- SQL Introduction – DuckDB 8541
- 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
...s VALUES ( 'San Francisco' , -194.0 , 53.0 ); The syntax used so far requires you to remember the order of the columns. An alternative syntax allows you to list the columns explicitly: INSERT INTO weather ( city , temp_lo , temp_hi , prcp , date ) VALUES (...order implicitly. Please enter all the commands shown above so you have some data to work with in the following sections. Alternatively, you can use the COPY statement. This is faster for large amounts of data because the COPY command is optimized for bulk...licate column name is later added to one of the tables. Join queries of the kind seen thus far can also be written in this alternative form: SELECT * FROM weather INNER JOIN cities ON weather.city = cities.name ; This syntax is not as commonly used as the o... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Syntax Highlighting – DuckDB 8152
- 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
...ellow \033[93m brightblue \033[94m brightmagenta \033[95m brightcyan \033[96m brightwhite \033[97m For example, here is an alternative set of syntax highlighting colors: .keyword brightred .constant brightwhite .comment cyan .error yellow .cont blue .cont_s... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Concurrency – DuckDB 8152
- 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
...f another process is already connected to the database (being sure to close the connection upon query completion). Another alternative would be to do multi-process transactions on a MySQL, PostgreSQL, or SQLite database, and use DuckDB's MySQL , PostgreSQL... - https://man.mtool.work/duckdb/1.3/connect/concurrency.html
- Importing Data – DuckDB 8152
- 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
...iently loaded from CSV files using several methods. The simplest is to use the CSV file's name: SELECT * FROM 'test.csv' ; Alternatively, use the read_csv function to pass along options: SELECT * FROM read_csv ( 'test.csv' , header = false ); Or use the COP.... Parquet Loading Parquet files can be efficiently loaded and queried using their filename: SELECT * FROM 'test.parquet' ; Alternatively, use the read_parquet function : SELECT * FROM read_parquet ( 'test.parquet' ); Or use the COPY statement : COPY tbl FRO...loading . JSON Loading JSON files can be efficiently loaded and queried using their filename: SELECT * FROM 'test.json' ; Alternatively, use the read_json_auto function : SELECT * FROM read_json_auto ( 'test.json' ); Or use the COPY statement : COPY tbl FR... - https://man.mtool.work/duckdb/1.3/data/overview.html
- Loops – DuckDB 8152
- 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
...fferent types of datasets can be efficiently generated. The random() function can also be used to generate random data. An alternative option is to read data from an existing CSV or Parquet file. There are several large CSV files that can be loaded from the... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/loops.html
- Glossary of Terms – DuckDB 8152
- 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
...application's process instead of running as a separate process, which is common in the traditional client–server setup. An alternative term is embeddable database management system. In general, the term “embedded database management system” should be avoide... - https://man.mtool.work/duckdb/1.3/guides/glossary.html
DuckDB 1.3 Documentation / man.mtool.work