Results of 1 - 10 of about 37 for missing (0.001 sec.)
- Combining Schemas 13449
- Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When
...eads the schema of the first file provided, and then matches the columns of subsequent files to it by column name: columns missing from the first file are dropped, and columns of the first file missing from a later file cause an error. This works correc...results in a schema mismatch error). When specifying the union_by_name option, the columns are correctly unified, and any missing values are set to NULL . SELECT * FROM read_csv(['flights3.csv', 'flights4.csv'], union_by_name = true); FlightDate Origin... - https://man.mtool.work/duckdb/2.0/data/multiple_files/combining_schemas.html
- Troubleshoot 12170
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...he driver resolves its entire JNI surface eagerly when its native library initializes, so a single class, method, or field missing from the reachability metadata fails the whole initialization. This indicates that the metadata compiled into the image is...missing or older than the driver: upgrade to a driver version that ships its own metadata, or regenerate the metadata with the tra...ckdb_java.⟨suffix⟩ This is what the library's JNI_OnLoad reports when an internal lookup failed, and the cause is the same missing metadata, not a JNI version problem. Native Image: UnsatisfiedLinkError: Can't load library In a Native Image executable,... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Deploy as Native Image 10260
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...d run it during mvn package or gradle nativeCompile . Further Reading Troubleshoot — the Native Image errors that indicate missing metadata or a missing shared library. Define Connections — driver registration and connection configuration. Java (JDBC) C... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Troubleshoot 9613
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...bError *duckdb.Error if errors.As(err, &duckdbError) { switch duckdbError.Type { case duckdb.ErrorTypeCatalog: // Handle a missing table, view, or other catalog entry. case duckdb.ErrorTypeConstraint: // Handle a constraint violation. } } } duckdb.Error...ler has decided cgo is unavailable, so the DuckDB bindings were not compiled. There are two common causes: Build tools are missing. cgo needs a C compiler and toolchain. On Debian or Ubuntu, install them with: bash sudo apt-get update && sudo apt-get in... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Benchmark Suite 9613
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...eate a benchmark file, we can look at the benchmark for the FILL window function. (The FILL function linearly interpolates missing values in an ordered partition.) Benchmarks are similar to unit test files, and have the same type of header. # name: benc...4 For FILL these are * The scale factor (millions of rows per partition) * The error rate (fraction of the values that are missing) * The number of partitions. Benchmarks generally require some data preparation before running the query. Data preparation... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Troubleshooting 9297
- Curl Request Fails Problem When trying to attach to an Iceberg REST Catalog endpoint, DuckDB returns the following error: IO Error: Curl Request to '/v1/oauth/tokens' failed with error: 'URL using bad/illegal format or missing URL' Solution
... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/troubleshooting.html
- AsOf Join 9297
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...00:01:30 21.16 It essentially executes a function defined by looking up nearby values in the prices table. Note also that missing ticker values do not have a match and don't appear in the output. Outer AsOf Joins Because AsOf produces at most one match...from the right hand side, the left side table will not grow as a result of the join, but it could shrink if there are missing times on the right. To handle this situation, you can use an outer AsOf Join: SELECT h.ticker, h.when, price * shares AS v... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
- Spark API 8650
- The DuckDB Spark API implements the PySpark API , allowing you to use the familiar Spark API to interact with DuckDB. All statements are translated to DuckDB's internal plans using our relational API and executed using DuckDB's query engine
...vers are tested against PySpark 4.2.0 and 3.5.9. Warning The DuckDB Spark API is experimental and receives bug fixes only: missing features will not be added, and a later release will deprecate it. We recommend SQLFrame , which runs PySpark DataFrame co... - https://man.mtool.work/duckdb/2.0/clients/python/spark_api.html
- Python DB API 8334
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...any statement run with execute() that fails aborts the transaction, including one with a syntax error or one that names a missing table. After that, commit() rolls the transaction back without raising an error, and any other statement raises a Transact...until you roll back: con.begin() con.execute("INSERT INTO items VALUES ('drill', 80, 1)") try: con.execute("SELECT * FROM missing_table") except duckdb.CatalogException: pass con.execute("SELECT count(*) FROM items") _duckdb.TransactionException: Trans... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- CSV Import Tips 8334
- Below is a collection of tips to help when attempting to import complex CSV files. In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the hea
...ding Files with Different Schemas The union_by_name option can be used to unify the schema of files that have different or missing columns. For files that do not have certain columns, NULL values are filled in. SELECT * FROM read_csv('flights*.csv', uni... - https://man.mtool.work/duckdb/2.0/data/csv/tips.html
DuckDB 2.0 Documentation / man.mtool.work