Results of 1 - 3 of about 3 for topic (0.002 sec.)
- Analyzing a Git Repository 11924
- 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
...───────────────────────────────────────────────┘ Analyzing the Log We can analyze the table as any other in DuckDB. Common Topics Let's start with a simple question: which topic was the most commonly mentioned in the commit messages: CI, CLI, or Pytho...n? SELECT message.lower().regexp_extract('\b(ci|cli|python)\b') AS topic, count(*) AS num_commits FROM commits WHERE topic <> '' GROUP BY ALL ORDER BY num_commits DESC; ┌─────────┬─────────────┐...│ topic │ num_commits │ │ varchar │ int64 │ ├─────────┼─────────────┤ │ ci │ 828 │ │ python │ 666 │ │ cli │ 49 │ └─────────┴──────... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Building Configuration 8092
- 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
...isting the names of the extensions that are to be built. BUILD_EXTENSIONS='tpch;httpfs;fts;json;parquet' make More on this topic at building DuckDB extensions . Package Flags The Makefile has flags to control which components are built. These can be e... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Subqueries 7868
- 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
...d Person nodes without an interest: CREATE TABLE Person (id BIGINT, name VARCHAR); CREATE TABLE interest (PersonId BIGINT, topic VARCHAR); INSERT INTO Person VALUES (1, 'Jane'), (2, 'Joe'); INSERT INTO interest VALUES (2, 'Music'); SELECT * FROM Perso... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work