Results of 1 - 10 of about 36 for find (0.001 sec.)
- Graph Queries 13994
- DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for
...ions. Moreover, some features may be incomplete. See the DuckPGQ website for the latest status. Graph queries allow you to find patterns and paths in connected data, such as social networks, financial transactions, or knowledge graphs, using a visual...on (id) DESTINATION KEY (person2_id) REFERENCES Person (id) ); Pattern Matching Use the GRAPH_TABLE function with MATCH to find patterns. The syntax uses () for nodes and [] for edges: FROM GRAPH_TABLE (social_network MATCH (a:Person)-[k:Knows]->(b:P...(a.name AS person1, b.name AS person2, k.since) ); person1 person2 since Alice Bob 2020-01-01 Bob Charlie 2021-06-15 Path Finding Find paths of variable length using quantifiers like {1,5} (1 to 5 hops) or + (one or more): FROM GRAPH_TABLE (social_n... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Performance Guide 11157
- DuckDB aims to automatically achieve high performance by using well-chosen default configurations and having a forgiving architecture. Of course, there are still opportunities for tuning the system for specific workloads. The Performance Gu
...hieving good performance when loading and processing data with DuckDB. The guides include several microbenchmarks. You may find details about these on the Benchmarks page .... - https://man.mtool.work/duckdb/2.0/guides/performance/overview.html
- Linux 10095
- Prerequisites On Linux, install the required packages with the package manager of your distribution. Ubuntu and Debian CLI Client On Ubuntu and Debian (and also MX Linux, Linux Mint, etc.), the requirements for building the DuckDB CLI clien
...py3-pip python3-dev pip install duckdb Using the DuckDB CLI Client on Linux Once the build finishes successfully, you can find the duckdb binary in the build directory: build/release/duckdb For different build configurations ( debug , relassert , et...g the httpfs extension on Linux, the build may fail with the following error. CMake Error at /usr/share/cmake-3.22/Modules/FindPackageHandleStandardArgs.cmake:230 (message): Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the sy... - https://man.mtool.work/duckdb/2.0/dev/building/linux.html
- File Formats 9382
- Handling Parquet Files DuckDB has advanced support for Parquet files, which includes directly querying Parquet files . When deciding on whether to query these files directly or to first load them to the database, you need to consider severa
...f cardinality estimates, and are especially important if the queries contain a large number of join operators. Tip. If you find that DuckDB produces a suboptimal join order on Parquet files, try loading the Parquet files to DuckDB tables. The improve...ght compression methods like Snappy, LZ4, and zstd, are faster to decompress. You may use the parquet_metadata function to find out the compression algorithm used. Microbenchmark: Running TPC-H on a DuckDB Database vs. Parquet The queries on the TPC-...files with 1 row group or 1 file with 10 row groups will achieve full parallelism. It is also beneficial to keep the size of individual Parquet files moderate. Bestpractice The ideal range is between 100 MB and 10 GB per individual Parquet file. Hive... - https://man.mtool.work/duckdb/2.0/guides/performance/file_formats.html
- Import from Numpy 9382
- It is possible to query Numpy arrays from DuckDB. There is no need to register the arrays manually – DuckDB can find them in the Python process by name thanks to replacement scans . For example: import duckdb import numpy as np columns = {
... - https://man.mtool.work/duckdb/2.0/guides/python/import_numpy.html
- Subqueries 9382
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...NOT EXISTS operator is generally the most useful as a correlated subquery to express antijoin operations. For example, to find Person nodes without an interest: CREATE TABLE Person (id BIGINT, name VARCHAR); CREATE TABLE interest (PersonId BIGINT, t...correlated subquery is a function that is applied to every row in the source dataset. For example, suppose that we want to find the minimum grade for every course. We could do that as follows: SELECT * FROM grades grades_parent WHERE grade = (SELECT... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- My Workload Is Slow 9033
- If you find that your workload in DuckDB is slow, we recommend performing the following checks. More detailed instructions are linked for each point. Do you have enough memory? DuckDB works best if you have 1-4 GB memory per thread . Is you
... - https://man.mtool.work/duckdb/2.0/guides/performance/my_workload_is_slow.html
- Import from Pandas 9033
- CREATE TABLE ... AS and INSERT INTO can be used to create a table from any query. We can then create tables or insert into existing tables by referring to the Pandas DataFrame in the query. There is no need to register the DataFrames manual
...ly – DuckDB can find them in the Python process by name thanks to replacement scans . import duckdb import pandas # Create a Pandas dataframe m... - https://man.mtool.work/duckdb/2.0/guides/python/import_pandas.html
- ODBC Configuration 8669
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
...meters: [DuckDB] : between the brackets is a DSN for the DuckDB. Driver : Describes the driver's name, as well as where to find the configurations in the odbcinst.ini . Database : Describes the database name used by DuckDB, can also be a file path to... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Relational API on Pandas 8669
- DuckDB offers a relational API that can be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can poin
...was separated for clarity output_df = transformed_rel.df() Relational operators can also be used to group rows, aggregate, find distinct combinations of values, join, union and more. They are also able to directly insert results into a DuckDB table o... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
DuckDB 2.0 Documentation / man.mtool.work