Results of 1 - 9 of about 9 for suitable (0.002 sec.)
- Friendly CLI 13103
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
...set manually using the .highlight_mode command: .highlight_mode dark .highlight_mode light To use a mix of colors suitable for both dark and light backgrounds: .highlight_mode mixed The mode can also be selected when launching the CLI using the... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Importing Data 10101
- The first step to using a database system is to insert data into that system. DuckDB can directly connect to many popular data sources and offers several data ingestion methods that allow you to easily and efficiently fill up the database.
...r your use case. INSERT Statements INSERT statements are the standard way of loading data into a database system. They are suitable for quick prototyping, but should be avoided for bulk loading as they have significant per-row overhead. INSERT INTO peopl... - https://man.mtool.work/duckdb/2.0/data/overview.html
- Map Type 10101
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Troubleshoot 9095
- 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
...s unable to find the DuckDB driver, it may throw the following error: Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:duckdb: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:706) at java.sql/java.sq... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Interval Type 8088
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...s can be 25 hours or 23 hours long because of daylight saving time). The division into components makes the INTERVAL class suitable for adding or subtracting specific time units to a date. For example, we can generate a table with the first day of every... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Struct Functions 8088
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...e works; a typed NULL literal (e.g. NULL::STRUCT(v1 INT, v2 INT) ) is a convenient way to declare the target shape when no suitable value is at hand. mapping is a STRUCT keyed by target field name whose values name the source field to read from; defaults... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Samples 8088
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
...ual to the specified percentage of the table, but the variance is vectorSize times higher. As such, system sampling is not suitable for datasets with fewer than ~10k rows, where it can happen that all rows will be filtered out, or all the data will be in... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Security 7082
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...ization before each query the client wants to issue. Default Configuration Both hooks ship with built-in defaults that are suitable for local development and single-user deployments, and each is exposed as an overridable callback for deployments with str... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Timestamp Types 7082
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...g the offset from UTC is needed: Time Zone Support The TIMESTAMPTZ type can be binned into calendar and clock bins using a suitable extension. The built-in icu extension implements all the binning and arithmetic functions using time zone data built from... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work