Results of 1 - 10 of about 74 for existing (0.001 sec.)
- Excel Import 11048
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...om a SELECT statement: CREATE TABLE new_tbl AS SELECT * FROM read_xlsx('test_excel.xlsx', sheet = 'Sheet1'); Loading to an Existing Table To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT *...eet = 'Sheet1'); Alternatively, you can use the COPY statement with the XLSX format option to import an Excel file into an existing table: COPY tbl FROM 'test_excel.xlsx' (FORMAT xlsx, SHEET 'Sheet1'); When using the COPY statement to load an Excel file...into an existing table, the types of the columns in the target table will be used to coerce the types of the cells in the Excel sheet. Impo... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Troubleshooting of Extensions 10742
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...ore info, visit https://duckdb.org/docs/current/extensions/troubleshooting?version=v2.0.0&platform=osx_arm64&extension=non_existing There are multiple scenarios for which an extension might not be available in a given extension repository at a given time... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- ALTER TABLE Statement 10575
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...unique constraint to a column of a table: ALTER TABLE integers ADD UNIQUE (j); Syntax ALTER TABLE changes the schema of an existing table. All the changes made by ALTER TABLE fully respect the transactional semantics, i.e., they will not be visible to ot...f a column: ALTER TABLE integers ALTER COLUMN i DROP DEFAULT; The SET/DROP DEFAULT clause modifies the DEFAULT value of an existing column. Note that this does not modify any existing data in the column. Dropping the default is equivalent to setting the...DD [CONSTRAINT ⟨name⟩] PRIMARY KEY and ADD [CONSTRAINT ⟨name⟩] UNIQUE clauses add a primary key or unique constraint to an existing table. Add a primary key to a column of a table: ALTER TABLE integers ADD PRIMARY KEY (i); Add a primary key to multiple c... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- ALTER VIEW Statement 10421
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Migrating to DuckDB 2.0 9934
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...2.0.0 cannot read, and the next step of the lambda syntax transition. This page provides guidance on migrating existing deployments to DuckDB 2.0.0. Before You Migrate Before migrating to DuckDB 2.0.0, assess whether your workload is mission-...its end of life on November 17, 2026. Bestpractice In all cases, we recommend setting up a shadow system that tracks your existing workload. This lets you test DuckDB 2.0.0 in an environment outside of your production system before switching over. For s...ated by v2.0.0 uses this format ( storage version 69 ). The other direction keeps working: DuckDB 2.0.0 can read and write existing database files created by earlier versions. These files keep their storage version when v2.0.0 writes to them, so they rem... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- JSON Import 9781
- To read data from a JSON file, use the read_json function in the FROM clause of a query: SELECT * FROM read_json('input.json'); To create a new table using the result from a query, use CREATE TABLE AS from a SELECT statement: CREATE TABLE n
...ew_tbl AS SELECT * FROM read_json('input.json'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_json('input.json'); Altern...atively, the COPY statement can also be used to load data from a JSON file into an existing table: COPY tbl FROM 'input.json'; For additional options, see the JSON Loading reference and the COPY statement documenta... - https://man.mtool.work/duckdb/2.0/guides/file_formats/json_import.html
- CSV Import 9460
- To read data from a CSV file, use the read_csv function in the FROM clause of a query: SELECT * FROM read_csv('input.csv'); Alternatively, you can omit the read_csv function and let DuckDB infer it from the extension: SELECT * FROM 'input.c
...'s optional FROM -first syntax to omit SELECT * : CREATE TABLE new_tbl AS FROM read_csv('input.csv'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_csv('input.csv'); Alternat...ively, the COPY statement can also be used to load data from a CSV file into an existing table: COPY tbl FROM 'input.csv'; For additional options, see the CSV import reference and the COPY statement documentatio... - https://man.mtool.work/duckdb/2.0/guides/file_formats/csv_import.html
- Import from Pandas 8986
- CREATE TABLE ... AS and INSERT INTO can be used to create a table from any query. We can then create tables or insert into existing tables by referring to the Pandas DataFrame in the query. There is no need to register the DataFrames manual
...duckdb.sql("INSERT INTO my_table BY NAME SELECT * FROM my_df") Alternatively, the append method appends a DataFrame to an existing table directly, without writing a SQL query. Pass by_name=True to match columns by name rather than by position: con = duc... - https://man.mtool.work/duckdb/2.0/guides/python/import_pandas.html
- Struct Functions 8819
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...ract the entry from a STRUCT or TUPLE using an index (1-based). struct_insert(struct, name := any, ...) Add field(s) to an existing STRUCT . struct_keys(struct) Return the names of the entries of a STRUCT as a list. struct_pack(name := any, ...) Create a...ry within the STRUCT (1-based), or NULL if not found. struct_update(struct, name := any, ...) Add or update field(s) of an existing STRUCT . struct_values(struct) Return the values of a STRUCT as a TUPLE . struct.entry | Description | Dot notation that s...': 10, 'v2': 20, 'v3': 3}, 2) | | Result | 20 | struct_insert(struct, name := any, ...) | Description | Add field(s) to an existing STRUCT . | | Example | struct_insert({'a': 1}, b := 2) | | Result | {'a': 1, 'b': 2} | struct_keys(struct) | Description |... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Parquet Import 8666
- To read data from a Parquet file, use the read_parquet function in the FROM clause of a query: SELECT * FROM read_parquet('input.parquet'); Alternatively, you can omit the read_parquet function and let DuckDB infer it from the extension: SE
...TABLE ... AS SELECT statement : CREATE TABLE new_tbl AS SELECT * FROM read_parquet('input.parquet'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_parquet('input.parquet');...Alternatively, use the COPY statement to load data from a Parquet file into an existing table: COPY tbl FROM 'input.parquet' (FORMAT parquet); Adjusting the Schema on the Fly You can load a Parquet file into a... - https://man.mtool.work/duckdb/2.0/guides/file_formats/parquet_import.html
DuckDB 2.0 Documentation / man.mtool.work