Results of 1 - 10 of about 17 for become (0.001 sec.)
- Run Queries 12225
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...nd a java.time or java.sql temporal value, the driver wraps it in the matching internal holder — java.sql.Date / LocalDate become an org.duckdb.DuckDBDate , Timestamp / LocalDateTime become a DuckDBTimestamp , OffsetDateTime becomes a DuckDBTimestampTZ..., and Time / LocalTime become a DuckDBTime — and marshals it to the corresponding DuckDB type: import java.time.LocalDate; import java.time.LocalDateTim... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Writing JSON 11311
- The contents of tables or the result of queries can be written directly to a JSON file using the COPY statement. For example: CREATE TABLE cities AS FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id); COPY cities TO 'cities.json
...ETRY AS geom, 10 AS my_field) TO 'test.jsonl' (FORMAT GEOJSONL); Optional ID_COLUMN and GEOMETRY_COLUMN pick which columns become the Feature id and geometry. st_asgeojson / st_geomfromgeojson convert a single value. Reading GeoJSON is documented on th... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
- Import from Numpy 11311
- 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 = {
...e an array whose outer dimension represents rows before querying it. A masked array is read with its mask: masked elements become NULL . my_masked_arr = np.ma.masked_array([1.0, 2.0, 3.0], mask=[False, True, False]) duckdb.sql("SELECT * FROM my_masked_... - https://man.mtool.work/duckdb/2.0/guides/python/import_numpy.html
- VACUUM Statement 10397
- The VACUUM statement only has basic support in DuckDB and is mostly provided for PostgreSQL-compatibility. Some variants of it, such as when calling for a given column, recompute the distinct statistics (the number of distinct entities) if
...they have become stale due to updates. Warning The behavior of VACUUM is not consistent with PostgreSQL semantics and it is likely going to... - https://man.mtool.work/duckdb/2.0/sql/statements/vacuum.html
- Loading JSON 9949
- 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
...less this is set. BOOL false Note that DuckDB can convert JSON arrays directly to its internal LIST type, and missing keys become NULL : SELECT * FROM read_json( ['birds1.json', 'birds2.json'], columns = {duck: 'INTEGER', goose: 'INTEGER[]', swan: 'DOU...in DuckDB 2.0. The json extension can read GeoJSON 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); .geojso... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Pivot Internals 9035
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...PIVOT statement, it must be translated into multiple queries. ENUM types are used to find the distinct values that should become columns. Each ENUM is then injected into one of the PIVOT statement's IN clauses. After the IN clauses have been populated... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
- C++ API 8586
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...x = 0; col_idx < result->ColumnCount(); col_idx++) { // GetValue returns a duckdb::Value; ToString renders it (NULL values become "NULL") cout << result->Collection().GetValue(col_idx, row_idx).ToString(); cout << (col_idx + 1 < result->ColumnCount() ?... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Writing to Iceberg 8138
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...SET ('format-version' = 3); Each ALTER TABLE statement updates the current-schema-id of the Iceberg table, and the changes become visible to other Iceberg-aware engines the next time they query the LoadTableInformation endpoint. Iceberg schema evolutio... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Data Ingestion 7673
- This page contains examples for data ingestion to Python using DuckDB. First, import the DuckDB package: import duckdb Then, proceed with any of the following sections. CSV Files CSV files can be read using the read_csv function, called eit
...s in a NumPy masked array are NULL . In a dict of arrays, names that differ only in case get a suffix, so the keys a and A become the columns a and A_1 . Use register() to give a DataFrame or Arrow object a SQL name. This also works for objects stored... - https://man.mtool.work/duckdb/2.0/clients/python/data_ingestion.html
- Metrics 7673
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...running the query. Name Type Unit Description system.blocked_thread_time double seconds Time spent waiting for a thread to become available system.peak_buffer_memory uint64 bytes Peak memory usage of the buffer manager system.peak_streaming_buffer_size... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
DuckDB 2.0 Documentation / man.mtool.work