Results of 1 - 10 of about 23 for readable (0.003 sec.)
- Output Formats 14695
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...eature-rich ASCII-art style output format. The duckbox mode supports the large_number_rendering option, which allows human-readable rendering of large numbers. It has three levels: off – All numbers are printed using regular formatting. footer (default)...– Large numbers are augmented with the human-readable format. Only applies to single-row results. all - All large numbers are replaced with the human-readable format. See the f... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Migrating to DuckDB 2.0 9685
- 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
...abase files created by earlier versions. These files keep their storage version when v2.0.0 writes to them, so they remain readable by the earlier version. For example, creating a database with v2.0.0 and then opening it with v1.5.6 results in an error:...ng In a deployment with many DuckDB processes running different versions, a database file created by a v2.0.0 process is unreadable by the remaining older processes. Roll out the upgrade carefully and verify that every process that touches a shared datab...ase file is on a compatible version. Writing Files for Older Versions If you need database files that remain readable by an older DuckDB version, write them with an explicit storage version using the -storage-version command line argument:... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Text Functions 9685
- 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
...ted. ends_with(string, search_string) Alias for suffix . format(format, ...) Formats a string using the fmt syntax . formatReadableDecimalSize(integer) Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc....). format_bytes(integer) Converts integer to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded strin...x . | | Example | format('Benchmark "{}" took {} seconds', 'CSV', 42) | | Result | Benchmark "CSV" took 42 seconds | formatReadableDecimalSize(integer) | Description | Converts integer to a human-readable representation using units based on powers of 10... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Agent Mode 9300
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- JSON Overview 9300
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...Installing and Loading” page . About JSON JSON is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other serializable values). Whi... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- DuckDB_% Metadata Functions 9300
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...me . VARCHAR metric_type The type of the metric's value, e.g., double , uint64 , string or map . VARCHAR description Human readable text that describes the metric. VARCHAR unit The unit of the metric, e.g., seconds or rows . Empty for unitless metrics. V...built-in, otherwise, the filesystem path where the binary that implements the extension resides. VARCHAR description Human readable text that describes the extension's functionality. VARCHAR aliases List of alternative names for this extension. VARCHAR[]...registered, e.g., by extensions. Column Description Type name The name of the grammar extension. VARCHAR description Human readable text that describes the grammar extension. VARCHAR duckdb_indexes The duckdb_indexes() function provides metadata about se... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Configuration 8914
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...alue The amount of config options available. Syntax size_t duckdb_config_count ( ); duckdb_get_config_flag Obtains a human-readable name and description of a specific configuration option. This can be used to e.g. display configuration options. This will... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- Handle Results 8529
- Overview Beyond the standard JDBC ResultSet , the DuckDB driver can hand results to Apache Arrow , stream large results instead of materializing them, and expose raw columnar data chunks. This page covers each of these result-handling optio
...PreparedStatement; import org.duckdb.DuckDBChunkedResult; import org.duckdb.DuckDBDataChunkReader; import org.duckdb.DuckDBReadableVector; try (DuckDBConnection conn = DriverManager .getConnection("jdbc:duckdb:") .unwrap(DuckDBConnection.class); DuckDBPr...indices are 0-based for (long col = 0; col < chunk.columnCount(); col++) { // get a vector for the specified column DuckDBReadableVector vector = chunk.vector(col); // iterate over the vector rows for (long row = 0; row < chunk.rowCount(); row++) { int...aces. The chunked result API currently supports basic data types only. Composite types such as LIST and STRUCT are not yet readable through this interface. The query() method is available on prepared statements only; there is no query(String) overload. F... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- Utility Functions 8529
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...f a = b , else return a . Equivalent to CASE WHEN a = b THEN NULL ELSE a END . parse_formatted_bytes(string) Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on invalid input. pg_typeof(expression)...ELSE a END . | | Example | nullif(1+1, 2) | | Result | NULL | parse_formatted_bytes(string) | Description | Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on invalid input. | | Example | parse_f... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- COPY Statement 8529
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ectory which will contain the exported files. If a file exceeds the set limit (specified as bytes such as 1000 or in human-readable format such as 1k ), the process creates a new file in the directory. This parameter works in combination with PER_THREAD_...to infer automatically. STRUCT (empty) ROW_GROUP_SIZE_BYTES The target size of each row group. You can pass either a human-readable string, e.g., 2MB , or an integer, i.e., the number of bytes. This option is only used when you have issued SET preserve_i... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
DuckDB 2.0 Documentation / man.mtool.work