Results of 1 - 10 of about 79 for results (0.004 sec.)
- Dot Commands – DuckDB 12486
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...working directory to DIRECTORY .changes on/off Show number of rows changed by SQL .columns Column-wise rendering of query results .constant COLOR Sets the syntax highlighting color used for constant values .constantcode CODE Sets the syntax highlightin...ection for more details .highlight_colors COMPONENT COLOR Configure the color of each component in (duckbox only). See the result syntax highlighting section for more details .highlight_results on/off Toggle highlighting in result tables on / off (duckb...ox only). See the result syntaxx highlighting section for more details .import FILE TABLE Import data from FILE into TABLE .indexes TABLE Show names... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Non-Deterministic Behavior – DuckDB 12293
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ehavior Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-threa...n-determinism is the set semantics used by SQL. E.g., if you run the following query repeatedly, you may get two different results: SELECT * FROM ( SELECT 'A' AS x UNION SELECT 'B' AS x ); Both results A , B and B , A are correct. Different Results on D...ifferent Platforms: array_distinct The array_distinct function may return results in a different order on different platforms : SELECT array_distinct ([ 'A' , 'A' , 'B' , NULL , NULL ]) AS arr ; For this... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- Export to Apache Arrow – DuckDB 10398
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...d Format Execution Format Pivot Sitemap Live Demo Documentation / Guides / Python Copy Markdown Export to Apache Arrow All results of a query can be exported to an Apache Arrow Table using the arrow function. Alternatively, results can be returned as a...RecordBatchReader using the fetch_record_batch function and results can be read one batch at a time. In addition, relations built using DuckDB's Relational API can also be exported. Export t...'j' : [ "one" , "two" , "three" , "four" ]}) # query the Apache Arrow Table "my_arrow_table" and return as an Arrow Table results = duckdb . sql ( "SELECT * FROM my_arrow_table" ). arrow () Export as a RecordBatchReader import duckdb import pyarrow as... - https://man.mtool.work/duckdb/1.3/guides/python/export_arrow.html
- Multiple Python Threads – DuckDB 10096
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...this thread local_con = duckdb_con . cursor () # Query the current row count thread_name = str ( current_thread (). name ) results = local_con . execute ( """ SELECT ? AS thread_name, count(*) AS row_counter, current_timestamp FROM my_inserts """ , ( th...read_name ,)). fetchall () print ( results ) Create Threads We define how many writers and readers to use, and define a list to track all of the threads that will be...))) # Shuffle the threads to simulate a mix of readers and writers random . seed ( 6 ) # Set the seed to ensure consistent results when testing random . shuffle ( threads ) Run Threads and Show Results Now, kick off all threads to run in parallel, then... - https://man.mtool.work/duckdb/1.3/guides/python/multiple_threads.html
- Result Verification – DuckDB 9107
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Result Verification 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 res...1 OR a = 2 . * If we instead want the result not to contain a snippet of text, we can use the <!REGEX>: modifier. File As results can grow quite large, and we might want to re-use results over multiple files, it is also possible to read expected result...g ---- 200 values hashing to b8126ea73f21372cdb3f2dc483106a12 This approach is useful for reducing the size of tests when results have many output rows. However, it should be used sparingly, as hash values make the tests more difficult to debug if they... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- Python DB API – DuckDB 8901
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ell. Querying SQL queries can be sent to DuckDB using the execute() method of connections. Once a query has been executed, results can be retrieved using the fetchone and fetchall methods on the connection. fetchall will retrieve all results and complet...e the transaction. fetchone will retrieve a single row of results each time that it is invoked until no more results are available. The transaction will only close once fetchone is called...and there are no more results remaining (the return value will be None ). As an example, in the case of a query only returning a single row, fetchone sh... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Executing SQL in Python – DuckDB 8901
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ing the result conversion functions. For example, the fetchall method can be used to convert the result to Python objects. results = duckdb . sql ( "SELECT 42" ). fetchall () print ( results ) [(42,)] Several other result objects exist. For example, you...can use df to convert the result to a Pandas DataFrame. results = duckdb . sql ( "SELECT 42" ). df () print ( results ) 42 0 42 By default, a global in-memory connection will be used. An...n . sql ( "INSERT INTO integers VALUES (42)" ) con . sql ( "SELECT * FROM integers" ). show () 関連キーワード duckdb using results integers queries executed show default example fetchall used convert objects print connection connect Documentation Guides... - https://man.mtool.work/duckdb/1.3/guides/python/execute_sql.html
- GROUPING SETS – DuckDB 8310
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...he grouping can themselves contain actual NULL -values, then it can be challenging to distinguish whether the value in the resultset is a “real” NULL -value coming out of the data itself, or a NULL -value generated by the grouping construct. The GROUPIN...grouping_id()" FROM days GROUP BY GROUPING SETS ( ( y , q , m ), ( y , q ), ( y ), () ) ORDER BY y , q , m ; These are the results: y q m grouping_id() 2023 1 1 0 2023 1 2 0 2023 1 3 0 2023 1 NULL 1 2023 2 4 0 2023 2 5 0 2023 2 6 0 2023 2 NULL 1 2023 3...to that level are simply aggregate rows and the GROUPING_ID(y, q, m) function returns 0 for those. The grouping set (y, q) results in super-aggregate rows over the month level, leaving a NULL -value for the m column, and for which GROUPING_ID(y, q, m) r... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 8200
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndle name Statement Type name SQL_HANDLE_STMT Description Handles the execution of SQL statements, as well as the returned result sets. Use case Executing SQL queries, fetching result sets, managing statement options. Additional information To facilitat..., and allows the application to specify the structure of data to be bound/retrieved. Use case Describing table structures, result sets, binding columns to application buffers Additional information Used in situations where data structures need to be exp...licitly defined, for example during parameter binding or result set fetching. They are automatically allocated when a statement is allocated, but can also be allocated explicitly. Connect... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- Benchmarks – DuckDB 8200
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...uckDB, please make sure you are using the latest version (preferably the preview build ). If in doubt about your benchmark results, feel free to contact us at [email protected] . Disclaimer on Benchmarks Note that the benchmark results presented in this...guide do not constitute official TPC or LDBC benchmark results. Instead, they merely use the data sets of and some queries provided by the TPC-H and the LDBC BI benchmark frameworks, an...d omit other parts of the workloads such as updates. 関連キーワード benchmark Benchmarks benchmarks sets results guide table DuckDB Note system Documentation Guides Performance Copy Markdown several recommendations performance microben... - https://man.mtool.work/duckdb/1.3/guides/performance/benchmarks.html
DuckDB 1.3 Documentation / man.mtool.work