Results of 1 - 10 of about 10 for analysis (0.002 sec.)
- PostgreSQL Extension Functions 11674
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...attached PostgreSQL database sql_query ( VARCHAR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to st...attached PostgreSQL database sql_query ( VARCHAR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to st... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Dutch Railway Datasets 11674
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...links to our mirrors to the datasets. In 2024, we have published a blog post on the analysis of these datasets . Loading the Datasets You can load the datasets directly as follows: CREATE TABLE services AS FROM 'htt... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- Deploy as Native Image 9618
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
....DuckDBDriver"); Driver auto-registration through ServiceLoader is not always visible to Graal Native Image's closed world analysis, and the explicit load makes registration deterministic. Providing the Shared Library DuckDB's engine is a native library... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Multiple Python Threads 9618
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Building Configuration 8938
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...ARK=1 set. tidy-check This creates a build and then runs Clang-Tidy to check for issues or style violations through static analysis. The CI will also run this check, causing it to fail if this check fails. format-fix | format-changes | format-main This d... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Result Verification 8938
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...llowed by a certain regex. If the result value matches the regex the test is passed. This is primarily used for query plan analysis. query II EXPLAIN SELECT tbl.a FROM 'data/parquet-testing/arrow/alltypes_plain.parquet' tbl(a) WHERE a = 1 OR a = 2 ---- p... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Jupyter Notebooks 8241
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...ks. jupysql : Convert a Jupyter code cell into a SQL cell Pandas : Clean table visualizations and compatibility with other analysis matplotlib : Plotting with Python duckdb-engine (DuckDB SQLAlchemy driver) : Used by SQLAlchemy to connect to DuckDB (opti... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Analyzing a Git Repository 8241
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...┘ Out of these three topics, commits related to continuous integration dominate the log! We can also do a more exploratory analysis by looking at all words in the commit messages. To do so, we first tokenize the messages: CREATE TABLE words AS SELECT unn... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Connect 6185
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...xecutables, always use this explicit load: the service-provider discovery is not reliably visible to Native Image's static analysis. To create a DuckDB connection, call DriverManager with the jdbc:duckdb: JDBC URL prefix, like so: import java.sql.Connect... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Integration with Ibis 6185
- Ibis is a Python dataframe library that supports 20+ backends, with DuckDB as the default. Ibis with DuckDB provides a Pythonic interface for SQL with great performance. Warning Ibis 12.0.0 and earlier do not support DuckDB 2.0. The example
...─────┴───────────────────┴─────────────┴────────┴───────┘ You can use any Boolean comparison in a filter. select Your data analysis might not require all the columns present in a given table. select lets you pick out only those columns that you want to w... - https://man.mtool.work/duckdb/2.0/guides/python/ibis.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work