Results of 1 - 10 of about 10 for Kind (0.005 sec.)
- Node.js API – DuckDB 14284
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...er ~OPEN_CREATE : number ~OPEN_FULLMUTEX : number ~OPEN_SHAREDCACHE : number ~OPEN_PRIVATECACHE : number duckdb~Connection Kind : inner class of duckdb ~Connection .run(sql, …params, callback) ⇒ void .all(sql, …params, callback) ⇒ void .arrowIPCAll(s....close(callback) ⇒ void connection.run(sql, …params, callback) ⇒ void Run a SQL statement and trigger a callback when done Kind : instance method of Connection Param Type sql …params \* callback connection.all(sql, …params, callback) ⇒ void Run a SQL...query and triggers the callback once for all result rows Kind : instance method of Connection Param Type sql …params \* callback connection.arrowIPCAll(sql, …params, callback) ⇒ void R... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Hugging Face Support – DuckDB 8509
- 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
...ormats-csv-1 is the name of the dataset repository data.csv is the file path in the repository The result of the query is: kind sound dog woof cat meow pokemon pika human hello To read a JSONL file, you can run: SELECT * FROM 'hf://datasets/datasets-...anch / path_to_file For example: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-csv-1@~parquet/**/*.parquet' ; kind sound dog woof cat meow pokemon pika human hello The previous query will read all parquet files under the ~parquet revisio... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/hugging_face.html
- CREATE TABLE Statement – DuckDB 8438
- 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 Columns The [type] [GENERATED ALWAYS] AS (expr) [VIRTUAL|STORED] syntax will create a generated column. The data in this kind of column is generated from its expression, which can reference other (regular or generated) columns of the table. Since t...very time the data of their dependencies change (through an INSERT / UPDATE / DROP statement). Currently, only the VIRTUAL kind is supported, and it is also the default option if the last field is left blank. The simplest syntax for a generated colum... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- R-Tree Indexes – DuckDB 8402
- 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 IS NULL THEN st_area ( geom ) ELSE NULL END AS area , row_id , CASE WHEN row_id IS NULL THEN 'branch' ELSE 'leaf' END AS kind FROM rtree_index_dump ( 'my_idx' ) ORDER BY area DESC ; ┌───────┬──────────────────────────────┬────────────────────┬─────...───┬─────────┐ │ level │ geom │ area │ row_id │ kind │ │ int32 │ geometry │ double │ int64 │ varchar │ ├───────┼──────────────────────────────┼────────────────────┼────────┼──... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- SQL Introduction – DuckDB 8366
- 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
...in query, so that the query won't fail if a duplicate column name is later added to one of the tables. Join queries of the kind seen thus far can also be written in this alternative form: SELECT * FROM weather INNER JOIN cities ON weather.city = citi...ies row(s). If no matching row is found we want some “empty values” to be substituted for the cities table's columns. This kind of query is called an outer join. (The joins we have seen so far are inner joins.) The command looks like this: SELECT * F... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Querying Parquet Metadata – DuckDB 8330
- 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
...rnal details of the Parquet file such as the statistics of the different columns. This can be useful for figuring out what kind of skipping is possible in Parquet files, or even to obtain a quick overview of what the different columns contain: SELECT... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Overview of DuckDB Internals – DuckDB 8330
- 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
...RENCE ). SQL Statement The SQLStatement represents a complete SQL statement. The type of the SQL Statement represents what kind of statement it is (e.g., StatementType::SELECT represents a SELECT statement). A single SQL string can be transformed int... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- FILTER Clause – DuckDB 8277
- 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
...vot data from rows into columns. This is a static pivot, as columns must be defined prior to runtime in SQL. However, this kind of statement can be dynamically generated in a host programming language to leverage DuckDB's SQL engine for rapid, larger... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/filter.html
- DuckDB_% Metadata Functions – DuckDB 8205
- 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
...schema where the function resides. VARCHAR function_name The SQL name of the function. VARCHAR function_type The function kind. Value is one of: table , scalar , aggregate , pragma , macro VARCHAR description Description of this function (always NUL... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Spatial Functions – DuckDB 8170
- 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
...──────┬────────┬──────────────────────┬─────────┬────────────────────┬────────────┬───────────┬────────────────────────┐ │ kind │ id │ tags │ refs │ lat │ lon │ ref_roles │ ref_types │ │ enum ( 'node' , 'way' … │ int64 │ map ( varchar , varch … │ int... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work