Results of 1 - 9 of about 9 for something (0.003 sec.)
- NULL Values 12438
- NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as “the value of this field is unknown”. A NULL value can be inserted to any fie
...when used with AND and OR . For details, see the Boolean Type documentation . NULL and IN / NOT IN The behavior of ... IN ⟨something with a NULL⟩ is different from ... IN ⟨something with no NULLs⟩ . For details, see the IN documentation . NULL and Aggrega... - https://man.mtool.work/duckdb/2.0/sql/data_types/nulls.html
- ALTER DATABASE Statement 10946
- 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
...ASE old_name RENAME TO new_name; Check if a database exists and rename it: ALTER DATABASE IF EXISTS non_existent RENAME TO something_else;... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- Secrets Manager 10641
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...( TYPE s3, KEY_ID 'my_secret_key2', SECRET 'my_secret_value2', SCOPE 's3://⟨my-other-bucket⟩' ); Now, if the user queries something from s3://⟨my-other-bucket⟩/something , secret secret2 will be chosen automatically for that request. To see which secret... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Tableau – A Data Visualization Tool 8538
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...Tableau\Drivers . Linux: Copy it to /opt/tableau/tableau_driver/jdbc . Using the PostgreSQL Dialect If you just want to do something simple, you can try connecting directly to the JDBC driver and using the Tableau-provided PostgreSQL dialect. Create a Duc... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Writing to Iceberg 8250
- 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.
...DB-Iceberg only supports merge-on-read semantics . If a table has write.update.mode or write.delete.mode properties set to something other than merge-on-read , the operation fails. Unsupported Operations The following are not yet supported by the DuckDB i... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Prepared Statements 7944
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
..., &stmt) == DuckDBError) { // handle error } duckdb_bind_int32(stmt, 1, 42); duckdb_execute_prepared(stmt, &result); // do something with result // clean up duckdb_destroy_result(&result); duckdb_destroy_prepare(&stmt); After calling duckdb_prepare , the... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- PIVOT Statement 7944
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...s example, we are pivoting numeric values, but the first function works very well for pivoting out a text column. (This is something that is difficult to do in a spreadsheet pivot table, but easy in DuckDB!) This query produces a result that is identical... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Geometry Data Type 7351
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...m CRS definitions in a database such that DuckDB can use them to resolve CRS identifiers for geometry columns, but this is something we are considering for the future. Working with Geometries in Different Coordinate Reference Systems One benefit of tracki... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Python Client API 6740
- 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
...ntropy . first ( * args : ValueOrExpr ) → Expression The first value seen. Order it with .over() or sort to make that mean something. SQL: first . fragment ( ) → str The SQL for this node, parenthesised so precedence cannot change what it means. get_name... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work