Results of 1 - 9 of about 9 for located (0.002 sec.)
- sqllogictest Introduction 13067
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...alling the original, then copying the syntaxes/sqllogictest.tmLanguage.json into the installed extension (on macOS this is located in ~/.vscode/extensions/benesch.sqllogictest-0.1.1 ). A syntax highlighter is also available for CLion . It can be install... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Writing Tests 11072
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...e structured and how to make new tests for DuckDB. The tests can be run by running the unittest program located in the test folder. For the default compilations this is located in either build/release/test/unittest (release) or build/... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
- Command Line Client 8753
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...the first example below, or out to another file, as in the second example. In this example, the file select_example.sql is located in the same directory as duckdb.exe and contains the following SQL statement: SELECT * FROM generate_series(5); To execute...h SQL and dot commands, can also be run in a single .read command. In this example, the file write_markdown_to_file.sql is located in the same directory as duckdb.exe and contains the following commands: .mode markdown .output series.md SELECT * FROM ge... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- QUALIFY Clause 8753
- The QUALIFY clause is used to filter the results of WINDOW functions . This filtering of results is similar to how a HAVING clause filters the results of aggregate functions applied based on the GROUP BY clause . The QUALIFY clause avoids t
...does not need to be specified), and before the ORDER BY . Examples Each of the following examples produce the same output, located below. Filter based on a window function defined in the QUALIFY clause: SELECT schema_name, function_name, -- In this exam... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/qualify.html
- Swift Client 8430
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...Complete Project For the complete example project, clone the DuckDB Swift repository and open up the runnable app project located in Examples/SwiftUI/ExoplanetExplorer.xcodeproj .... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Reading Multiple Files 8088
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...upported for reads over S3 due to HTTP encoding issues. Here is an example that reads all the files that end with .parquet located in the test folder: Read all files that match the glob pattern: SELECT * FROM read_parquet('test/*.parquet'); Handling Pat... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Tableau – A Data Visualization Tool 8088
- 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
...2.app/Contents/MacOS/Tableau\" -DDisableVerifyConnectorPluginSignature=true" quit Create this file with the Script Editor (located in /Applications/Utilities ) and save it as a packaged application : You can then double-click it to launch Tableau. You w... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Catalogs 7423
- 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
... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Pragmas 7100
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...les the majority of the data processed. However, certain in-memory data structures such as vectors and query results are allocated outside of the buffer manager. Additionally, aggregate functions with complex state (e.g., list , mode , quantile , string...y for Spilling Data to Disk By default, DuckDB uses a temporary directory named ⟨database_file_name⟩.tmp to spill to disk, located in the same directory as the database file. To change this, use: SET temp_directory = '/path/to/temp_dir.tmp/'; Returning... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work