Results of 1 - 9 of about 9 for almost (0.001 sec.)
- Describe 13894
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...E YES NULL NULL NULL cnt_kirk_hookups BIGINT YES NULL NULL NULL cnt_downed_redshirts BIGINT YES NULL NULL NULL bool_aliens_almost_took_over_planet BIGINT YES NULL NULL NULL bool_aliens_almost_took_over_enterprise BIGINT YES NULL NULL NULL cnt_vulcan_ne... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Building DuckDB from Source 8807
- 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
...M64) builds are available for these platforms (except for macOS on x86_64, which only has partial support, see below), and almost all extensions are distributed for these platforms. Platform name Description Comment linux_amd64 Linux x86_64 (AMD64) wit... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- Writing Tests 8807
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...y to avoid testing components individually because that makes those components more difficult to change later on. As such, almost all of our tests can (and should) be expressed in pure SQL. There are certain exceptions to this, which we will discuss in... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
- Timestamp Issues 8807
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...Half-Open Intervals Another subtle problem in using SQL for temporal analytics is the BETWEEN operator. Temporal analytics almost always uses half-open binning intervals to avoid overlaps at the ends. Unfortunately, the BETWEEN operator is a closed-clo... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Securing Quack with a Reverse Proxy 8412
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...tication_token-from-quack_serve⟩' ); Caddy + Let's Encrypt Caddy auto-provisions certificates from Let's Encrypt and needs almost no configuration. A complete public-facing Quack proxy: # /etc/caddy/Caddyfile quack.example.com { reverse_proxy 127.0.0.1... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Geometry Data Type 8412
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...optimizations, statistics, etc.) are therefore only available in databases using storage version v1.5 and above. However, almost all of the associated functions for working with geometries (e.g., calculating distances, areas, intersections) are still...──┐ │ database_name │ database_size │ │ varchar │ varchar │ ├───────────────┼───────────────┤ │ shredded_db │ 2.2 MiB │ -- Almost 3x smaller storage thanks to shredding! │ geometry_db │ 6.5 MiB │ │ memory │ 0 bytes │ └───────────────┴───────────────┘ -... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- SQL Quirks 8412
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...dot_product which returns 0 on empty lists. 0 vs. 1-Based Indexing To comply with standard SQL, one-based indexing is used almost everywhere, e.g., array and string indexing and slicing, and window functions ( row_number , rank , dense_rank ). However,... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Excel Extension 8016
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...cel extension has to do some guesswork to "infer" and decide the types of the columns when importing an Excel sheet. While almost all columns are inferred as either DOUBLE or VARCHAR , there are some caveats: TIMESTAMP , TIME , DATE and BOOLEAN types a... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Reading and Writing Parquet Files 7243
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...oading the Parquet Extension The support for Parquet files is enabled via extension. The parquet extension is bundled with almost all clients. However, if your client does not bundle the parquet extension, the extension must be installed separately: IN... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work