Results of 1 - 10 of about 11 for generic (0.002 sec.)
- Data Import 12767
- Recommended Import Methods When importing data from other systems to DuckDB, there are several considerations to take into account. We recommend importing using the following order: For systems which are supported by a DuckDB scanner extens
...ion, it's preferable to use the scanner. DuckDB currently offers scanners for MySQL , PostgreSQL and SQLite , as well as a generic ODBC scanner . If there is a bulk export feature in the data source system, export the data to Parquet or CSV format, then... - https://man.mtool.work/duckdb/2.0/guides/performance/import.html
- query and query_table Functions 10633
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...query_table($1); EXECUTE select_from_table('my_table'); i 42 When combined with the COLUMNS expression , we can write very generic SQL-only macros. For example, below is a custom version of SUMMARIZE that computes the min and max of every column in a ta... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- Query 9922
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...nd example that prints the above result to CSV format using the duckdb_fetch_chunk function. Note that the function is NOT generic: we do need to know exactly what the types of the result columns are. duckdb_database db; duckdb_connection con; duckdb_op...s an example that prints the above result to CSV format using the duckdb_value_varchar function. Note that the function is generic: we do not need to know about the types of the individual result columns. // print the above result to CSV format using `d... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Casting 9922
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
...│ 42 │ └───────┘ This function is primarily useful in macros , as it allows you to maintain types. This helps with making generic macros that operate on different types. For example, the following macro adds to a number if the input is an INTEGER : CRE... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- Building DuckDB from Source 9210
- When Should You Build DuckDB? DuckDB binaries are available for stable and preview builds on the installation page . In most cases, it's recommended to use these binaries. When you are running on an experimental platform (e.g., Raspberry Pi
...e instructions provided for macOS and Linux. Troubleshooting Guides We provide troubleshooting guides for building DuckDB: Generic issues Python R... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- Tableau – A Data Visualization Tool 8499
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Execution Format 8499
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...ry function is unfeasible due to the combinatorial explosion of possibilities. Instead of doing this, whenever you want to generically use a vector regardless of the type, the UnifiedVectorFormat can be used. This format essentially acts as a generic vi... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Run Queries 7788
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...d and Composite Types DuckDB's nested types , such as LIST , STRUCT , and MAP , and its JSON type, are scanned through the generic duckdb.Composite[T] wrapper. Choose the Go type parameter to match the SQL shape, then read the decoded value with Get() :... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Catalogs 7077
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...in the overview . The section below describes the generic way of attaching an Iceberg REST Catalog. For instructions specific to a catalog implementation, see Amazon S3 Tables , AW... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Loading JSON 7077
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...oJSON when you opt in. Pass geojson := true to read_json so geometry objects become GEOMETRY (the spatial type) instead of generic JSON: SELECT * FROM read_json('features.geojson', geojson := true); .geojson / .geojsonl files are also recognized as JSON... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
DuckDB 2.0 Documentation / man.mtool.work