Results of 1 - 10 of about 12 for Rename (0.004 sec.)
- ALTER DATABASE Statement 12770
- Warning The ALTER DATABASE statement is not supported in DuckDB 2.0.0: ALTER DATABASE ⟨old_name⟩ RENAME TO ⟨new_name⟩ fails with Parser Error: syntax error at or near "RENAME" . To rename an attached database, DETACH it and ATTACH it again
...with a different alias. Syntax RENAME DATABASE The following scenarios are not supported when renaming a DuckDB database with ALTER DATABASE : Renaming a databa...certain reserved keywords such as system or temp . Renaming a database to the same name of a database attached in memory. Rename a database from old_name to new_name : ALTER DATABASE old_name RENAME TO new_name; Check if a database exists and rename i...t: ALTER DATABASE IF EXISTS non_existent RENAME TO something_else;... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- ALTER TABLE Statement 12593
- 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
...LE integers ALTER COLUMN i SET NOT NULL; Drop the not- NULL constraint: ALTER TABLE integers ALTER COLUMN i DROP NOT NULL; Rename a table: ALTER TABLE integers RENAME TO integers_old; Rename a column of a table: ALTER TABLE integers RENAME i TO ii; Add...ntics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. RENAME TABLE Rename a table: ALTER TABLE integers RENAME TO integers_old; The RENAME TO clause renames an entire table, changing...schema. Note that any views that rely on the table are not automatically updated. New As of DuckDB 2.0, ALTER TABLE ⟨view⟩ RENAME TO ⟨new_name⟩ can also rename a view, for compatibility with PostgreSQL. The equivalent ALTER VIEW ⟨view⟩ RENAME TO ⟨new_n... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- ALTER VIEW Statement 8843
- 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
- Star Expression 8702
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...place specific columns by alternative expressions. SELECT * REPLACE (col1 / 1_000 AS col1, col2 / 1_000 AS col2) FROM tbl; RENAME Clause RENAME allows you to replace specific columns. SELECT * RENAME (col1 AS height, col2 AS width) FROM tbl; Column Fil...lumns with Regular Expressions in a COLUMNS Expression The matches of capture groups in regular expressions can be used to rename matching columns. The capture groups are one-indexed; \0 is the original column name. For example, to select the first thr...(1-based) index of the column. COLUMNS -clause lambdas allow the execution of arbitrary expressions in order to select and rename columns. SELECT COLUMNS(lambda c: c LIKE '%num%') FROM numbers; number 10 20 NULL COLUMNS List COLUMNS also supports passi... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
- Writing to Iceberg 8437
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...on The ALTER TABLE statement is supported against Iceberg tables, covering the most common schema-evolution operations: -- Rename the table ALTER TABLE iceberg_catalog.default.simple_table RENAME TO renamed_table; -- Add a column ALTER TABLE iceberg_ca...talog.default.renamed_table ADD COLUMN col3 DOUBLE; -- Rename a column ALTER TABLE iceberg_catalog.default.renamed_table RENAME COLUMN col2 TO...name; -- Drop a column ALTER TABLE iceberg_catalog.default.renamed_table DROP COLUMN col3; -- Change the type of a column ALTER TABLE iceberg_catalog.default.renamed_table ALTER COLUMN col... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Lakehouse Formats 8295
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...dates ✅ ✅ ❌ ✅ Upserting ✅ ✅ ❌ ✅ Create table ✅ ✅ ✅ ✅ Create table with partitions ✅ ✅ ✅ ❌ Attaching to a catalog ✅ ✅ ✅ * ✅ Rename table ✅ ✅ ❌ ❌ Rename columns ✅ ✅ ❌ ✅ Add/drop columns ✅ ✅ ❌ ✅ Alter column type ✅ ✅ ❌ ✅ Compaction and maintenance ✅ ✅ ❌ ✅... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- Relational API 7977
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...ry Run the given SQL query in sql_query on the view named virtual_table_name that refers to the relation object. set_alias Rename the relation object to new alias. shape Tuple of # of rows, # of columns in relation. show Display a summary of the data....────┐ │ max_price │ │ int32 │ ├───────────┤ │ 89 │ └───────────┘ set_alias set_alias(self, alias: str) -> DuckDBPyRelation Rename the relation object to new alias. Parameters alias : str The alias name to assign to the relation. Example import duckdb d...ivot Turn the given values of column into columns holding aggregate ; the values are explicit. project Alias of select() . rename Rename columns, given as old=new. sample A random subset: n rows, or percent of them, with seed repeating a draw. select P... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- VALUES Clause 7977
- The VALUES clause is used to specify a fixed number of rows. The VALUES clause can be used as a stand-alone statement, as part of the FROM clause, or as input to an INSERT INTO statement. Examples Generate two rows and directly return them:
...VALUES ('Amsterdam', 1), ('London', 2); Generate two rows as part of a FROM clause, and rename the columns: SELECT * FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id); Generate two rows and insert them in... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/values.html
- Expression API 7676
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...│ c │ │ int64 │ int64 │ ├───────┼───────┤ │ 1 │ 42 │ │ 2 │ 21 │ │ 3 │ 13 │ │ 4 │ 14 │ └───────┴───────┘ star(exclude=..., rename=...) also renames columns, as in star(exclude="b", rename={"c": "total"}) . Constant Expression This expression contains a... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Python Client API 7676
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...oss', ‘positional', ‘natural' and ‘asof'. With suffix , a column of the right side whose name the left side already has is renamed with the suffix appended. Detailed examples can be found at Relational API page . lag ( expression : str , window_spec :...) → DuckDBPyRelation Computes the dense rank within the partition. Detailed examples can be found at Relational API page . rename ( ** columns : str ) → DuckDBPyRelation Rename columns, given as old=new. Detailed examples can be found at Relational API...ing based on type(s). Detailed examples can be found at Relational API page . set_alias ( alias : str ) → DuckDBPyRelation Rename the relation object to new alias. Detailed examples can be found at Relational API page . shape Tuple of # of rows, # of c... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
DuckDB 2.0 Documentation / man.mtool.work