⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 14 for console (0.002 sec.)
Crashes 13478
DuckDB is thoroughly tested via an extensive test suite. However, bugs can still occur and these can sometimes lead to crashes. This page contains practical information on how to troubleshoot DuckDB crashes. Types of Crashes There are a few ... : these should never occur. Please submit an issue . Internal errors: an operation may result in an Internal Error , e.g.: console INTERNAL Error: Attempted to access index 3 within vector of size 3 After encountering an internal error, DuckDB enters a ... restricted mode where any further operations will result in the following error message: console FATAL Error: Failed: database has been invalidated because of a previous fatal error. The database must be restarted prior ... n runs out of memory, consult the “OOM errors” page . Corrupted database or WAL file: DuckDB displays the following error: console Corrupt database file: computed checksum [...] does not match stored checksum [...] in block at location [...] If the WAL ...
https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
Quack on WebAssembly 10958
CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th ... e same org/region). Template is maintained at https://github.com/duckdb/duckdb-quack-infra Deploy via Web UI Visit https://console.aws.amazon.com/cloudformation/home#/stacks/quickcreate?templateURL=https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/qua ... on us-east-2 Web UI To see the status of your CloudFormation stack on the AWS web user interface, visit the CloudFormation console . ...
https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
Logging 10467
DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia ... CT * FROM duckdb_logs; In the CLI client , the default log storage is shell_log_storage , which prints log messages to the console but does not support querying. Therefore, the example above passes storage = 'memory' . In other clients, the default log ... ges. Note Switching the CLI to a log storage other than shell_log_storage means that warnings are no longer printed to the console. To restore the default behavior, run CALL enable_logging(storage = 'shell_log_storage') . Log Types In DuckDB, log messag ... the stdout of the current process (in CSV format) file Log to (a) csv file(s) shell_log_storage Print log messages to the console (default in the CLI) The shell_log_storage cannot be queried: duckdb_logs , duckdb_logs_parsed() and truncate_duckdb_logs( ...
https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
Node.js Client (Neo) 9207
Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi ... musl osx_amd64 osx_arm64 windows_amd64 windows_arm64 Examples Get Basic Information import duckdb from '@duckdb/node-api'; console.log(duckdb.version()); console.log(duckdb.configurationOptionDescriptions()); Connect import { DuckDBConnection } from '@d ... nge(10_000_000)'); const pending = prepared.start(); while (pending.runTask() !== DuckDBPendingResultState.RESULT_READY) { console.log('not ready'); await sleep(1); } console.log('ready'); const result = await pending.getResult(); // ... Ways to Run SQL ...
https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
LibreDB Studio SQL Editor 9207
LibreDB Studio is an open-source, self-hosted, browser-based SQL editor. It runs as a single server, either via npx , Docker, or a native package, and is reached through the browser rather than installed as a desktop application. LibreDB St ... sted in the project's README . Open http://localhost:3000 in a browser. On first run, the admin password is printed to the console. Connecting to a DuckDB Database Click the + button next to the LibreDB Studio logo in the sidebar to open the New Connect ...
https://man.mtool.work/duckdb/2.0/guides/sql_editors/libredb_studio.html
Deploying Quack 8454
This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud ... aws cloudformation delete-stack --stack-name quack-demo --region us-east-1 Or use the Delete button in the CloudFormation console. What the Stack Provisions An AWS::EC2::Instance from a public AMI (per-region map baked into the template) running DuckDB ...
https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
CLI Charting with YouPlot 8209
DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi ... d can easily generate various types of plots including bar, line, histogram and scatter. With DuckDB, you can write to the console ( stdout ) by using the TO '/dev/stdout' command. And you can also write comma-separated values by using WITH (FORMAT csv, ...
https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
DuckDB Wasm Client 7947
Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab ... ");`], { type: 'text/javascript' }) ); const worker = new Worker(worker_url); const db = new duckdb.AsyncDuckDB(new duckdb.ConsoleLogger(), worker); await db.instantiate(bundle.mainModule, bundle.pthreadWorker); URL.revokeObjectURL(worker_url); // Open ... a connection and run a query const conn = await db.connect(); const result = await conn.query('SELECT 42 AS answer'); console.log(result.toArray()[0].answer); // prints 42 // Release resources await conn.close(); await db.terminate(); await worker. ...
https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
Profiling 7947
Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA ... no_output profiling_coverage Set the operators to profile SELECT SELECT , ALL profiling_output Set a profiling output file Console A filepath profiling_mode Deprecated, has no effect standard standard , detailed , all tracked_metrics Select which metric ...
https://man.mtool.work/duckdb/2.0/dev/profiling.html
Catalogs 7457
The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located ... and more), see the aws extension . Then, connect to the catalog using your S3 Tables ARN (available in the AWS Management Console) and the ENDPOINT_TYPE s3_tables option: ATTACH '⟨s3_tables_arn⟩' AS my_s3_tables_catalog ( TYPE iceberg, ENDPOINT_TYPE s3 ...
https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work