Results of 1 - 10 of about 37 for until (0.002 sec.)
- Python DB API 12691
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...ata ingestion page for other options. Open Results execute() starts the statement and returns the connection. A query runs until its first rows are ready, so an error up to that point raises from execute() , and an error further into the query raises...t. Any other statement, INSERT ... RETURNING included, runs to its end inside execute() . The result of a query stays open until a fetch returns no rows, or until fetchall() , df() or fetchnumpy() reads the rest of it. After a partial read with fetcho...Exception: Resource In Use Error: connection has an unfinished result from execute(); call complete() or abort(), or fetch until a fetch returns no rows, before other work on this connection, or use a separate connection from cursor() con.complete() c... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- CHECKPOINT Statement 11634
- The CHECKPOINT statement synchronizes data in the write-ahead log (WAL) to the database data file. Examples Synchronize data in the default database: CHECKPOINT; Synchronize data in the specified database: CHECKPOINT file_db; Synchronize da
...: FORCE CHECKPOINT; In earlier DuckDB versions, FORCE CHECKPOINT aborted any in-progress transactions. From v1.4, it waits until it can grab the checkpoint lock. Checkpointing In-Memory Tables Starting with v1.4.0, in-memory tables support checkpointi...ctions. Behavior The default CHECKPOINT command will fail if there are any running transactions. Including FORCE will wait until it can grab the checkpoint lock and then execute the checkpoint operation. In DuckDB versions before v1.4, FORCE CHECKPOIN... - https://man.mtool.work/duckdb/2.0/sql/statements/checkpoint.html
- Appender 10324
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...les. If DuckDB has no temporary directory, a full buffer makes every query on the connection raise an OutOfMemoryException until you call flush() or clear() . If a write into the buffer fails, append_row , append_rows and flush() raise an exception un...result is open, but must finish that result before calling flush() : call con.fetchall() , call con.fetchone() repeatedly until it returns None , or call con.complete() or con.abort() .... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- Timestamp Functions 10055
- This section describes functions and operators for examining and manipulating TIMESTAMP values . See also the related TIMESTAMPTZ functions . Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types
...format string . strptime(text, format-list) Converts the string text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return NULL on failure, use try_strptime . strptime(text, format) Converts th...is a Monday. try_strptime(text, format-list) Converts the string text to timestamp applying the format strings in the list until one succeeds. Returns NULL on failure. try_strptime(text, format) Converts the string text to timestamp according to the f...strptime(text, format-list) | Description | Converts the string text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return NULL on failure, use try_strptime . | | Example | strptime('4/15/2023... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- ALTER VIEW Statement 10055
- 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
...e transactional semantics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on the view are not automatically... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Excel Import 9534
- 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
...ckDB will stop reading the Excel file when encountering an empty row. But when a range is provided, the default is to read until the end of the range. This behavior can be controlled with the stop_at_empty parameter: -- Read the first 100 rows, or unt... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Text Functions 9534
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...lower(string) Converts string to lower case. lpad(string, count, character) Pads the string with the character on the left until it has count characters. Truncates the string on the right if it has more than count characters. ltrim(string[, characters...h_slash (default), forward_slash , backslash . parse_dirpath(path[, separator]) Returns the head of the path (the pathname until the last slash) similarly to Python's os.path.dirname . separator options: system , both_slash (default), forward_slash ,...cts the right-most count grapheme clusters. rpad(string, count, character) Pads the string with the character on the right until it has count characters. Truncates the string on the right if it has more than count characters. rtrim(string[, characters... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Connect 9266
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...on. Check a connection out of the pool with db.Conn() , which returns a *sql.Conn that is not shared with other goroutines until it is closed: conn, err := db.Conn(context.Background()) if err != nil { log.Fatal(err) } defer conn.Close() The client al...defer conn.Close() rows, _ := conn.QueryContext(context.Background(), "SELECT 42") defer rows.Close() // or drain the rows until Next() returns false connector, _ := duckdb.NewConnector("", nil) defer connector.Close() // if the connector is passed to... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Vectors 8998
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...result res; duckdb_query(con, "SELECT CASE WHEN i%2=0 THEN NULL ELSE i END res_col FROM range(10) t(i)", &res); // iterate until result is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhaust...CT CASE WHEN i%2=0 THEN CONCAT('short_', i) ELSE CONCAT('longstringprefix', i) END FROM range(10) t(i)", &res); // iterate until result is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhaust...NULL ELSE {'col1': i, 'col2': CASE WHEN i%2=0 THEN NULL ELSE 100 + i * 42 END} END FROM range(10) t(i)", &res); // iterate until result is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhaust... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Migrating Python Code to DuckDB 2.0 8998
- This page lists what Python code written for DuckDB 1.x must change to run on DuckDB 2.0. Each item gives the 1.x form, the 2.0 form and the page that explains it. For changes outside the Python client, see Migrating to DuckDB v2.0 . Python
...onnection ran while a result was partly read. 2.0: running another query on the connection raises a ResourceInUseException until the result is read to its end or ended with con.complete() or con.abort() , and the next execute() replaces the open resul...that fails aborts the transaction: con.commit() then rolls it back, and any other statement raises a TransactionException until con.rollback() . See Transactions . Writing files with overwrite=False . 1.x: rel.write_csv(path, overwrite=False) and rel... - https://man.mtool.work/duckdb/2.0/clients/python/migration.html
DuckDB 2.0 Documentation / man.mtool.work